[Zope] \n problems with mysql5

[Ferhat Ayaz]

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 at 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 at 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