Fatal error: A database transaction in eZ Publish failed.

Fatal error: A database transaction in eZ Publish failed.

Thursday 18 March 2010 12:50:19 am - 4 replies

Author Message

Steven E. Bailey

Thursday 18 March 2010 2:48:10 am

That's pretty much what you see in your browser when a database transaction fails. What you want to do is look in the eZPublish error log files for that that transaction id and you'll usually get a useful error message from your database server - such as column not found, etc.

Certified eZPublish developer
http://ez.no/certification/verify/396111

Available for ezpublish troubleshooting, hosting and custom extension development: http://www.leidentech.com

Alexander Trotter

Thursday 18 March 2010 3:06:28 am

Hi,

thanks for your reply.

I already looked into the error.log. It says:

The error message in the error log is:
eZDBInterface::commit TRANSID-45d2af34c8f58513b380b91bd3f1cf17:
Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-45d2af34c8f58513b380b91bd3f1cf17.

I read that this problem occurs, if the database user doesn't has the right LOCK_TABLES, but I already checked this and it isn't the problem.

Alexander Trotter

Thursday 18 March 2010 3:23:26 am

Just checked with our hosting provider. There isn't an underlying MySQL error in the MySQL error log to this error.

Can anybody point me in the right direction, please?^^

Steven E. Bailey

Thursday 18 March 2010 3:32:05 am

You might want to try DatabaseSettings -> SQLOutput=enabled to see what query is failing.

Certified eZPublish developer
http://ez.no/certification/verify/396111

Available for ezpublish troubleshooting, hosting and custom extension development: http://www.leidentech.com

You must be logged in to post messages in this topic!

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