Hi, sorry list. The problem was the changed syntax of JOIN between mysql 4 and 5. SELECT bla FROM bla INNER JOIN table1,table2 ON ( bla ) must be changed to SELECT bla FROM bla INNER JOIN (table1,table2) ON ( bla ) Greets, Ferhat --- Ferhat Ayaz <ferhatayaz@yahoo.com> wrote:

Hi,

I used mysql4 with Z MySQL without any problems. Now I want to update to mysql5. Unfortunatly the server reports a syntax error like the follows: ------------------------------------------------- Site Error

An error was encountered while publishing this resource.

Error Type: ProgrammingError Error Value: (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 'on\n(\n articles.store_id = stores.id \n and \n articles.manifacture_id = manifac' at line 7") ------------------------------------------------- I think the problem is the '\n' character. Have you any idea how to solve this problem???

Thanks, Ferhat

__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )

__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com