Forums / Install & configuration / Database Error Ez4.1

Database Error Ez4.1

Author Message

Piotr Dabrowski

Saturday 21 March 2009 4:01:18 am

Hi,
During updating to 4.1 from 4.0.3 run script addlockstategroup.php and got error listed bellow.
It is test site with postgres database.
All other update scrips run successfully. Site and Admin module seems working fine.
Didn't come across any other problems as yet.

good work
Peter

PHP Warning: Module 'gd' already loaded in Unknown on line 0
storing state group ez_lock
Fatal error: A database transaction in eZ Publish failed.

The current execution was stopped to prevent further problems.
You should contact the System Administrator of this site.
The current transaction ID is TRANSID-ff4d223b5bc6bec6c3d3a8f78f8d6ea0 and has been logged.
Please include the transaction ID and the name of the current script when contacting the system administrator.

PHP Notice: Undefined index: HTTP_USER_AGENT in /var/www/html/ezpublish-4.1.0/lib/ezutils/classes/ezsession.php on line 486

André R.

Saturday 21 March 2009 4:52:04 am

Take a look at this issue:
http://issues.ez.no/IssueView.php?Id=14624&

Is that the one your experiencing? In other words are your sql mode is set to strict?
(If it is just comment on the issue, if not here.)

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Piotr Dabrowski

Sunday 22 March 2009 3:58:38 am

It's look like this is maybe only mysql solution.
My site is running on Postgresql DB. I couldn't find any reference how to
reset sql mode.