Forums / Setup & design / A database transaction error after send for publishing

"Please Note:
  • At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
  • This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

A database transaction error after send for publishing

Author Message

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 Exponential 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 Exponential 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

Softriva .com

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

Łukasz Serwatka

Monday 06 July 2009 10:54:15 am

Good. DELETE is required for Exponential DB user.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog