Details
-
Bug
-
Resolution: Duplicate
-
Medium
-
None
-
2011.7
-
None
Description
When we try to move an object to trash we receive a fatal error like this:
"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-29ea5b34c3b53b99ae4380722da4ee94 and has been logged.
Please include the transaction ID and the current URL when contacting the system administrator."
Error log:
[ Sep 07 2011 10:14:17 ] [192.168.0.185] eZMySQLiDB: Query error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2. Query: SELECT id, contentobject_attribute_id, filepath FROM ezimagefile WHERE contentobject_attribute_id='754' AND filepath IN ( ) [ Sep 07 2011 10:14:17 ] [192.168.0.185] eZDBInterface::commit TRANSID-29ea5b34c3b53b99ae4380722da4ee94: Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-29ea5b34c3b53b99ae4380722da4ee94.
Steps to reproduce
Every time wh try to move a content to trash we receive the fatal error message. It's not happen when we try to delete a content without moving to trash.
Attachments
Issue Links
- duplicates
-
EZP-18594 Moving content object within datatype ezimage to trash causing DB Transaction error.
- Closed