Forums / General / (Update), error with draft of none existing nodes

(Update), error with draft of none existing nodes

Author Message

H. K.

Sunday 15 July 2007 4:18:47 am

After a power failure I get this error when i try to edit some nodes

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

The debug:

Query error: Can't open file: 'eznode_assignment.MYI'. (errno: 145). Query: SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,
       is_main, from_node_id, parent_remote_id
FROM   eznode_assignment
WHERE  contentobject_id='280788' AND contentobject_version='1'

I have tried to repair eznode_assignment in mysql but no luck.

System:
EZ 3.6.1
Mysql 4.0

H. K.

Sunday 15 July 2007 5:05:56 am

I managed to repair the table

But after deleting the two “dirty nodes” I get this error when I enter my account.

Fatal error: Call to a member function on a non-object in /home/hkk/public_html/ezpublish/kernel/classes/ezcontentobjectversion.php on line 264
Fatal error: eZ publish did not finish its request

The execution of eZ publish was abruptly ended, the debug output is present below.

Notice: Undefined index: /setup/debug_toolbar.tpl in /home/hkk/public_html/ezpublish/kernel/common/eztemplatedesignresource.php on line 384

Error: eZContentObject::fetch()  	Jul 15 2007 13:50:26

Object not found (280690)

In witch table are these drafts stored?

eZ debug

Timing: Jan 30 2025 22:25:51
Script start
Timing: Jan 30 2025 22:25:51
Module start 'content'
Timing: Jan 30 2025 22:25:51
Module end 'content'
Timing: Jan 30 2025 22:25:51
Script end

Main resources:

Total runtime0.1764 sec
Peak memory usage8,192.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0064 588.0547370.2813
Module start 'content' 0.00640.0140 958.33591,001.5625
Module end 'content' 0.02040.1560 1,959.89843,890.7891
Script end 0.1763  5,850.6875 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00422.3832200.0002
Check MTime0.00130.7375200.0001
Mysql Total
Database connection0.00060.340610.0006
Mysqli_queries0.088950.40261410.0006
Looping result0.00100.57911390.0000
Template Total0.155588.110.1555
Template load0.00080.464410.0008
Template processing0.154787.677810.1547
Override
Cache load0.00060.313410.0006
Sytem overhead
Fetch class attribute can translate value0.00181.010110.0018
XML
Image XML parsing0.00020.111810.0002
General
dbfile0.00814.5859200.0004
String conversion0.00000.001630.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
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs