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