3.9: Install fails with standard mysql 5.0.x

Author Message

Georg Franz

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

Kristof Coomans

Wednesday 03 January 2007 9:07:54 am

Hi George

There are numerous bug reports about similar issues:
http://issues.ez.no/7394
http://issues.ez.no/8163
http://issues.ez.no/9617

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.