[Phpmyadmin-devel] 2.2.0 Final Issue!?

[Martin Marconcini]

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 at lists.sourceforge.net [mailto:phpmyadmin-
> devel-admin at lists.sourceforge.net] On Behalf Of Martin Marconcini
> Sent: Thursday, August 23, 2001 7:59 PM
> To: phpmyadmin-devel at lists.sourceforge.net; phpmyadmin-
> users at 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 at lists.sourceforge.net
> http://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel