Nobody did find anything strange in the query???
Regards,
Martin Marconcini www.marconcini.com.ar
"Life must be lived looking forward and can be understood only looking backward." Soren Kierkegaard
-----Original Message----- From: phpmyadmin-devel-admin@lists.sourceforge.net [mailto:phpmyadmin- devel-admin@lists.sourceforge.net] On Behalf Of Martin Marconcini Sent: Thursday, August 23, 2001 7:59 PM To: phpmyadmin-devel@lists.sourceforge.net; phpmyadmin- users@lists.sourceforge.net Subject: [Phpmyadmin-devel] 2.2.0 Final Issue!?
Guys. Under 2.2r2 I executed (very often)
This query (I have it saved so there are no typos that may have appeared) used to work fine. MySQL/OS/Configuration is the same
(indeed
I ran this yesterday w/r2)
SELECT visit2.datestamp, visit2.ip, visit2.client_info, visit_type.description FROM visit2 INNER JOIN visit_type ON visit2.visit_type_id = visit_type.visit_type_id WHERE visit2.ip not like '192.168.0.99'
Now this is the result: (and the inner join?)
SQL-query : [Edit]
SELECT visit2.datestamp, visit2.ip, visit2.client_info, visit_type.description FROM visit2 JOIN visit_type ON visit2.visit_type_id = visit_type.visit_type_id WHERE visit2.ip not like '192.168.0.99' LIMIT 0, 30
MySQL said:
You have an error in your SQL syntax near 'ON visit2.visit_type_id = visit_type.visit_type_id WHERE visit2.ip not like '' at line 5
What did change between r2 and final ????????? The statement is plain SQL... as you can see. I pasted the SAME query under mysql console and it worked perfectly. I got the results in no time (almost 400 records).
This time I'm not being THAT lamer.. I swear it used to work under r2. But due to the fact that I don't read all the mails in this list, something may have changed and I missed it?
Regards,
Martin Marconcini www.marconcini.com.ar
"Life must be lived looking forward and can be understood only looking backward." Soren Kierkegaard
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net http://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel