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

A database transaction error after send for publishing

« 
Previous topic
|
Setup & design
|
Next topic
 »
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 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

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 eZ Publish DB user.

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

eZ debug

Timing: Jan 18 2025 19:33:11
Script start
Timing: Jan 18 2025 19:33:11
Module start 'content'
Timing: Jan 18 2025 19:33:12
Module end 'content'
Timing: Jan 18 2025 19:33:12
Script end

Main resources:

Total runtime1.0182 sec
Peak memory usage4,096.0000 KB
Database Queries197

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0087 587.9531180.8125
Module start 'content' 0.00870.8642 768.7656548.5234
Module end 'content' 0.87290.1452 1,317.2891332.7266
Script end 1.0181  1,650.0156 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00410.3979210.0002
Check MTime0.00140.1392210.0001
Mysql Total
Database connection0.00140.135310.0014
Mysqli_queries0.937992.11811970.0048
Looping result0.00330.32651950.0000
Template Total0.986396.920.4932
Template load0.00240.233520.0012
Template processing0.983996.635420.4920
Template load and register function0.00030.030010.0003
states
state_id_array0.00160.157510.0016
state_identifier_array0.00140.134220.0007
Override
Cache load0.00200.1978180.0001
Sytem overhead
Fetch class attribute can translate value0.00220.216430.0007
Fetch class attribute name0.00120.115150.0002
XML
Image XML parsing0.00110.108230.0004
class_abstraction
Instantiating content class attribute0.00000.001460.0000
General
dbfile0.00440.4327290.0002
String conversion0.00000.000830.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
4content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
4content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
2content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 14
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs