Forums / Setup & design / A database transaction error after send for publishing
Softriva .com
Monday 06 July 2009 9:03:21 am
Hello
I am getting this error after I send for publish. This error only occurs on the live server but not locally. I am running 4.1.3.
Thank you
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 with the information on this page. The current transaction ID is TRANSID-269d8fb76eaee6e478acb99e4662c761 and has been logged. Please include the transaction ID and the current URL when contacting the system administrator.
Łukasz Serwatka
Monday 06 July 2009 10:45:10 am
Hi,
More details about which SQL query failed you can find in the eZ Publish error.log. See var/log/error.log and search for the TRANSID.
Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Monday 06 July 2009 10:52:47 am
Fixed it. I enabled the DELETE rights for the db user. For info, the error is shown below:
DELETE command denied to user 'dbuser'@'localhost' for table 'ezcontentobject_link'. Query: DELETE FROM ezcontentobject_link
Monday 06 July 2009 10:54:15 am
Good. DELETE is required for eZ Publish DB user.