3.9: Install fails with standard mysql 5.0.x

Wednesday 03 January 2007 6:34:17 am

Hi,

at the last installation step the install fails with an mysql transaction error if you use mysql 5.0.x / winxp and have choosen the standard package.

Reason: There is one update query (from the package installation) which has something like ... data_int = '' ...

mysql 5 expects a numeric value instead of ''.

Workaround:

Change the my.ini / my.cnf settings:

[mysqld]
...
sql-mode="MYSQL40"

Question: Is ez supporting officially mysql 5? Is this a bug or is this an expected behaviour?

Best wishes,
Georg.

--
http://www.schicksal.com Horoskop website which uses eZ Publish since 2004