Re: [Zope] \n problems with mysql5
--On Freitag, 15. September 2006 01:08 -0700 Ferhat Ayaz <[EMAIL PROTECTED]> wrote: 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 ) Crazy syntax. What about SELECT bla FROM table1 JOIN table2 USING bla ? Regards Tino ___ 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 )
Re: [Zope] \n problems with mysql5
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 <[EMAIL PROTECTED]> 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 ___ 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 )
[Zope] \n problems with mysql5
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 )