[Phpmyadmin-devel] 2.2.0 Final Issue!?

Martin Marconcini megadeth at millic.com.ar
Fri Aug 24 01:29:10 CEST 2001


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






More information about the Developers mailing list