| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> ill request it again and put it in the pastebin
<1> since I escape everything going to the database (mysql_escape_string) I also have to unescape after retriving it, right?
<0> http://hashmysql.org/1495
<0> that probably SCREEEAMS for newline
<2> when I get output from a select statement, is there someway to specify the column seperator?
<0> martianlobster: are you using any particular backend language?
<0> that would make it easier.
<2> laurens: no I am using comand line mysql
<2> laurens: I could write a php script, but that would be harder, not easier ;)
<3> yyou usually specify the seperator in the backend you use
<3> !man escape string
<4> Nothing found.
<0> inviso_: I have a transactions table that has a fromaccountid and a toaccountid
<2> Nathalas: what is wierd is that when I run mysql interactivily, it uses | as a seperator, but when I pipe input and output, there is only whitespace between columns
<0> i need to translate those into company names, for which i need to go to the accounts table first
<0> since 1 company can have multiple registered accounts
<3> I interface to mysql through a dll that merely asks me to specify the seperator when I fetch a row from a resultset
<5> martianlobster - that's a feature
<5> unix pipes are non-interactive shells, and mysql knows that, so it uses a more easily parsable format
<6> laurens: updated your pastebin. Give that a shot
<6> laurens: and yes, it was screaming for some formating so I could read it ;o)
<2> what are valid names for mysql command line option --delimiter=name ?
<7> yeah
<8> :P
<2> google sees nothing :'( I can't find what are valid values of name in the command line paramater --delimiter=name
<7> !man server variables
<4> (System Variables) : http://dev.mysql.com/doc/mysql/en/System_Variables.html
<2> shabbs: ok thanks
<0> hi inviso_
<0> thanks
<0> will check it
<0> wow
<0> i have NOOO idea how that works
<9> Hy all... Hoping I can get some help troubleshooting here...
<9> err... Hi even
<0> cx is a temporary table?
<6> laurens: table alias. It allows you to join a table more than once under a different name
<0> ooh
<0> cool
<0> that was what i was doing in the back of my head
<6> also note how the joins were done. use ON rather than putting the conditions in the WHERE clause
<7> I'm finding a cure for cancer in the back of my head
<0> the subquery was more like "this almost works, lets fix it"
<6> BriteLeaf: 42
<9> Anyway... I type mysql to get into mysql and I get this error... ERROR 2002 (HY000): Can't connect to local mysql server through socket '/var/lib/mysql/mysql.sock' (111)
<0> inviso_: i need a good book on SQL
<0> methinks
<6> laurens: yup
<9> I have checked, and mysql.sock is there
<6> !perror 111
<4> System error: 111 = Connection refused
<7> check permissions on the file
<6> REJECTED!!
<0> by the way inviso_
<9> 42? What's that? (other than a popular domino game I mean?)
<0> there is other stuff I'm checking for
<6> BriteLeaf: the answer to life, the universe and everything
<0> BriteLeaf: the answer to life, the universe, and everything
<0> rofl
<0> asl google
<0> *ask google
<0> http://www.google.com/search?q=the+answer+to+life%2C+the+universe%2C+and+everything&start=0&ie=utf-8&oe=utf-8&client=firefox&rls=org.mozilla:en-US:unofficial
<0> inviso_:
<0> I can just add a where clause after that
<0> right?
<6> laurens: of course
<9> must be nice having nothing better to do than to make jokes when someone asks for help
<0> yay! :)
<6> BriteLeaf: basically, it's my smart alec answer when someone forgets to ask a question
<7> BriteLeaf: you didn't actually ask a question
<0> BriteLeaf: inviso_ answered 42 before you asked your question
<9> you should scroll back
<7> BriteLeaf: I mean when he answerd that :)
<7> +e
<0> BriteLeaf: i did
<0> BriteLeaf: inviso_ answered 42 before you asked your question
<7> anyway
<9> anyway
<7> BriteLeaf: check the permissions on the file
<10> that would be 13 shabs and it was 111
<11> Hi all. I am trying to move Bugzilla from one machine running 4.1.10a to a new machine running 5.0.18-log. I did so by running mysqldump on the DB, and then mysql -p db < sqldata.sql. After the move, I get an error on an SQL query, that a column doesn't exist. Same query works on old DB. Copying the directory of the Bugzilla DB directly to the new server - same result. Any idea?
<9> Now that the yuck yucks are finished, can someone help me troubleshoot the problem?
<6> shimi: does the column actually exist?
<11> if I run "select id from flagtypes;", the query succeeds
<0> Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/databeestdigi/resources/tablesetup.php on line 4
<0> doesnt work really
<0> lets enter that into phpmyadmin
<6> laurens: that's a php error. You'll need to run it from the mysql command line client for testing
<11> and the error is: DBD::mysql::st execute failed: Unknown column 'flagtypes.id' in 'on clause' [for Statement "SELECT 1, f...
<0> inviso_: yeah i know
<0> hence: --> lets enter that into phpmyadmin
<0> #1054 - Unknown column 'a.companyid' in 'on clause'
<9> I don't know how to check file permissions, but I am logged on as su - (root) so shouldn't I have access to everything?
<6> shimi: full query please
<0> shouldnt that be a1 instead of a?
<11> the query is REALLY LONG, are you sure? :)
<6> laurens: yup
<0> twice?
<7> BriteLeaf: but mysql doesn't run as root (I hope)
<6> shimi: pastebin it please
<6> laurens: a2 the second time
<9> don't think it does. Still learning all this stuff
<6> shimi: along with the error and the statement that actually works
<0> i see the structure
<0> no clue what it means
<0> but i see the structure :P
<11> http://pastebin.com/575403 < that's the non working
<7> BriteLeaf: ls -la /var/lib/mysql
<11> the working is just select on the column on the table, same column on table it says it doesn't exist... :)
<6> shimi: just add the other stuff as a comment on that pastebin
<0> still not ok
<0> You have an error in your SQL syntax;
<7> BriteLeaf: and you might want to move the sock file out of the install dir and into a globally accessible one, like /var/run
<0> hmmmm
<11> inviso, ok: http://pastebin.com/575405
<9> it is in /var/lib/mysql
<6> shimi: I'd highly recommend that you not mix the two styles of joins. iirc, mysql has bugged out on queries using both styles of joins in past versions. Use FROM flagtypes JOIN flaginclusions ON ... LEFT JOIN flagexclusions.... rather than FROM flagtypes, flaginclusions and see if that fixes it
<0> inviso_: i just added a comment
<0> this produces "bad sql syntax" according to sql
<7> BriteLeaf: right, which is usually the 'install' dir, ie within which your datadir sits. usually not publicly accessible. /var/run or even /tmp are publicly accessible, which is what the sock file needs to be
<12> $result3 = mysql_query('SELECT * FROM _install ORDER BY instid DESC LIMIT 1');
<12> Is that correct?
<12> (Or should it be? :O)
<11> inviso, and ***uming I am not planning on modifying the bugzilla source code? :)
<6> laurens: I'd need the exact query you ran and the full error to be able to help
<9> http://pastebin.com/575409
<6> shimi: can you at least try it from the command line to determine if that's the problem?
<9> ok
<0> inviso_: the query is in pastebin
<0> inviso_: the error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'JOIN accounts a1 ON t.fromaccountid = a1.accountid JOIN companies c1 ON a1.compa' at line 1
<7> BriteLeaf: /var/lib/mysql is accessible but /var/lib isn't (owned by root) it needs to be accessible all the way up the path
<11> I could, however me and JOINs are not best friend... any change you'll fix the code in pastebin as you see fit? :)
<13> lakez: did your bug get verfied in the end?
<11> s/change/chance
<9> one of these days you guys are gonna say something that is not Greek to me lol
<9> on that day I'll have a heart attack and die on the spot lol
<14> if I say something like "SELECT * FROM t1 a, t2 b, t3 c" does that doe a straight join that will give me all possible combinations of all rows in the results?
<7> BriteLeaf: basically edit your my.cnf and add/edit this: socket=/var/run/mysql.sock both in [client/mysql] and [server/mysqld]
<7> and restart the server
<6> laurens: FROM transactions t JOIN accounts ....
<9> I think that might be a problem too.... I used to have the mysql daemon loading on startup. It no longer does that and I have no clue how to make it do it again =( (or how to start/stop it) service mysqld start?
<0> oh yeah
<0> silly me
<7> BriteLeaf: what OS?
<6> shimi: http://pastebin.com/575414
<9> fc 4
<0> inviso_: not FROM transactions t
<0> ?
Return to
#mysql
or
Go to some related
logs:
#perl
the system will reboot when you leave the shell Warning--SELinux is active
#debian
#javascript
etch opengl-update
netstat -a output multiple lines
#sendmail
#javascript
#perl
#ubuntu
|
|