eZ Community » Forums » Developer » Fatal error: A database transaction...
expandshrink

Fatal error: A database transaction in eZ Publish failed.

Fatal error: A database transaction in eZ Publish failed.

Thursday 11 August 2011 3:32:22 am - 15 replies

Hi all,I'm new to these forums but have been using EZ Publish to develop sites for around 6 months now.I've just started installing the 2011.7 community version and seem to have a weird problem when trying to delete content objects.

This problem only seems to be related to some objects and not others. I have no idea what's going on. sad.gif Emoticon

I'm getting the following error in EZ 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-bd33fef8bbcb7b0436b2257ef248070b and has been logged.Please include the transaction ID and the current URL when contacting the system administrator.

My debug output has the following error:

Error: eZMySQLiDB Aug 11 2011 11:20:35Query 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='327' AND filepath IN ( )

The log has this output.

[ Aug 11 2011 11:20:35 ] [124.169.141.223] Timing Point: Module start 'content'
[ Aug 11 2011 11:20:35 ] [124.169.141.223] eZFileHandler::move:Cannot rename file var/ezflow_site/storage/images/boards-accessories/sup/albatross-touring-board/yellow/327-1-eng-AU/yellow.jpg, it does not exist
[ Aug 11 2011 11:20:35 ] [124.169.141.223] 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='327' AND filepath IN ( )
[ Aug 11 2011 11:20:35 ] [124.169.141.223] eZDBInterface::commit TRANSID-bd33fef8bbcb7b0436b2257ef248070b:Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-bd33fef8bbcb7b0436b2257ef248070b.

I am at a complete loss as to why this is happening on individual content objects and not others.

Also I can't seem to see what class or file that sql query is coming from so I can't even work out what file there might be an error in.Though removal is working fine on other content objects on the site.....

Any help is greatly appreciated!!

Cheers
Dan

Modified on Thursday 11 August 2011 3:39:44 am by Daniel Clements

Friday 12 August 2011 9:13:26 pm

Hi,

I'm no expert, but I would check two things. Permissions on the var folder where the image yellow.jpg is being moved. And also the existence of that path and same image.

Regards Robin

Tuesday 16 August 2011 8:03:58 am

Hey,

After to pass eZ Publish 2011.7, I have the same problem that Daniel, the same error when I want to remove a specifi datatype, someone has a solution ?

Thanks in advance !

Tuesday 16 August 2011 8:17:53 pm

Hey,

After to pass eZ Publish 2011.7, I have the same problem that Daniel, the same error when I want to remove a specifi datatype, someone has a solution ?

Thanks in advance !

Hi,

Which datatype did you try to remove? I'll try and get it confirmed once you let me know, might be a bug we need to add to http://issues.ez.no.

-- Robin

Tuesday 16 August 2011 10:40:28 pm

Hi Daniel, Fou, 

Are you guys working on brand new installations of eZ Publish Community Project 2011.7, or results of upgrades from previous versions ? Given the log posted, the ezimage datatype could be at the source of these errors. Can you confirm or invalidate that this is happening only with objects containing an attribute of the 'ezimage' datataype ?

I just tried locally on a fresh install : all is working correctly.

Last check : in case eZ Find is enabled, is the 'ezfind_elevate_configuration' table present ? (the SQL dump can be found in 'extension/ezfind/sql/mysql/mysql.sql' ).

Let us know how things go,
Cheers, 

Wednesday 17 August 2011 8:12:25 am

Hi Robin, Nicolas,

@Robin : it's a custom datatype, a container with per example an attribute image

@Nicolas : yes it's the eZ Publish Community Project 2011.7, not a new install, I upgrade the previous version (4.5) and upgrade the database. If I want to delete a another datatype it's works but not for this datatype :s

eZ Find is disable, and so I have not the ezfind_elevate_configuration table, I must to enable ?

Wednesday 17 August 2011 8:25:39 am

@Nicolas, I confirm, this problem happens onyl with a datatype with ezimage attribute :s

Monday 22 August 2011 8:32:51 pm

Nicolas, what's your take on this? It's beyond my experience with eZ I'm afraid.

Thursday 25 August 2011 11:18:29 am

Hi Guys, 

I think we can call this a bug.

@Fou, Daniel : could you guys please report an issue for this, here : http://issues.ez.no/ezpublish . Feel free to link to this forum thread, where some troublehsooting already happened.

Thanks in advance !
Cheers, 

Tuesday 27 September 2011 12:37:04 pm

A workaround is found at http://issues.ez.no/IssueView.php?Id=18641&activeItem=4, just delete objects without moving them to trash

Thursday 29 September 2011 6:08:45 pm

Seems this bug was fixed in 2011.9 community version.

Wednesday 15 February 2012 10:37:22 am

Hi everyone!

I have the same problem when I am deleting a file that appear the information:

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-3dfbd287c3ad2d71009e63dd20b37e3c and has been logged.Please include the transaction ID and the current URL when contacting the system administrator.

see var/log/error.log file that find information:

[ Feb 14 2012 15:45:32 ] [117.136.25.53] eZMySQLDB:Query error: Table 'test4_db.ezfind_elevate_configuration' doesn't exist. Query: DELETE FROM ezfind_elevate_configuration WHERE contentobject_id='3788'
[ Feb 14 2012 15:45:32 ] [117.136.25.53] eZDBInterface::commit TRANSID-bad0cc8740e17ee4f7ed76e41729d6be:Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-bad0cc8740e17ee4f7ed76e41729d6be.

Then I look at the deleting the file that is in trash. But I will want to restorethis file that is not to restore.

My database version is 2011.9 that is upgrading from 4.3 to 2011.9 Can everybody to solve this problem?

Please help me!

Thanks everybody!

Modified on Wednesday 15 February 2012 10:48:38 am by Nicolas Pastorino

Wednesday 13 March 2013 10:38:32 am

Hi,

Try to clear cache from command line

 php bin/php/ezcache.php --clear-all

in my case it help.

Wednesday 11 November 2015 6:34:23 pm

Hello Community,

I am still a newbie and have ezPublish 01/11/2014 eheute only installed, but seem to me Failed to delete forums in the admin area. If I want to move a forum in trash, this is displayed:

Fatal error: A database transaction failed in eZ Publish.
The current execution which 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-f191c75f8fa3a5cda1bce344aa7ba3bd and has been logged.
Please include the transaction ID and the current URL When Contacting the system administrator.

And the error.log shows me the:

[November 11 2015 17:40:05] [95.91.226.51] eZMySQLiDB:
Query error (1146): Table 'd02004d5.ezfind_elevate_configuration' does not exist. Query: DELETE FROM WHERE ezfind_elevate_configuration contentobject_id = '122'
[November 11 2015 17:40:05] [95.91.226.51] eZDBInterface :: commit TRANSID-61cf7244ce5e6b1f3812c0c79e0e268c:
Transaction in progress failed due to DB error, transaction which rollbacked. Transaction ID is TRANSID-61cf7244ce5e6b1f3812c0c79e0e268c.
[November 11 2015 17:47:10] [95.91.226.51] eZMySQLiDB:
Query error (1146): Table 'd02004d5.ezfind_elevate_configuration' does not exist. Query: DELETE FROM WHERE ezfind_elevate_configuration contentobject_id = '122'
[November 11 2015 17:47:10] [95.91.226.51] eZDBInterface :: commit TRANSID-f6d7d293f6ee206eb6f5eebcbdb25f2f:
Transaction in progress failed due to DB error, transaction which rollbacked. Transaction ID is TRANSID-f6d7d293f6ee206eb6f5eebcbdb25f2f.
[November 11 2015 17:47:16] [95.91.226.51] eZMySQLiDB:
Query error (1146): Table 'd02004d5.ezfind_elevate_configuration' does not exist. Query: DELETE FROM WHERE ezfind_elevate_configuration contentobject_id = '122'
[November 11 2015 17:47:16] [95.91.226.51] eZDBInterface :: commit TRANSID-6f764cce1291ffa86314ec21736f1be7:
Transaction in progress failed due to DB error, transaction which rollbacked. Transaction ID is TRANSID-6f764cce1291ffa86314ec21736f1be7.
[November 11 2015 17:47:32] [95.91.226.51] eZImageManager :: createAliasFromINI:
No such group product image in ini file image.ini

Can anyone make anything? I understand it so that a database table is missing, but how can I create with a few experiences at ezPublish.

For assistance I would be grateful.

P.S. Incidentally, you can here on the board, the Forum "General" do not call. It loads and loads and all I see is a blank page - at least just now.

Modified on Wednesday 11 November 2015 6:35:37 pm by Alexander Liebrecht

Wednesday 11 November 2015 8:15:10 pm

Well now I can solve the problem and although I was in the backend of ezPublish a function, in which the system is compared with the database. Such a proposal was made to me, what SQL command I need to enter in the database.
That worked and I was able to create three tables. Now I can delete good content ever.

Friday 02 June 2017 10:27:21 am

This thread had the solution for me: http://share.ez.no/forums/extensions/ez-find/after-activating-ezfind-and-adding-table-for-solaris-index-getting-db-error

 

In short: Run the SQL script stored in extension/ezfind/sql/<yourdbms>/<yourdbms>.sql to create the missing table.

 

After that - deleting content works like a charm happy.gif Emoticon

expandshrink

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

36 542 Users on board!

Forums menu

Proudly Developed with from