invalid values in eznode_assignment

Author Message

Marko Žmak

Sunday 18 July 2010 6:22:45 am

I came upon a strange eZ error when I was importing some data into the eZ database. The error was just "NodeAssignment '". Then I have looked at the kernel/content/ezcontentoperationcollection.php and found out that the error was produced in this block of code:

elseif ( $opCode == eZNodeAssignment::OP_CODE_MOVE )
            {
                if ( $fromNodeID == 0 || $fromNodeID == -1 )
                {
                    eZDebug::writeError( "NodeAssignment '", $nodeAssignment->attribute( 'id' ), "' is marked with op_code='$opCode' but has no data in from_$
                }

After that I lookd at the data in eznode_assignment table and found out that I have more than 1000 rows with op_code set to 5, and from_node_id set to -1, which according to the code below is invalid.

Where could this invalid data come from?

Is it safe to delete this rows in eznode_assignment?

I'm using eZ 4.1.3.

--
Nothing is impossible. Not if you can imagine it!

Hubert Farnsworth

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 18 2025 05:03:50
Script start
Timing: Jan 18 2025 05:03:50
Module start 'layout'
Timing: Jan 18 2025 05:03:50
Module start 'content'
Timing: Jan 18 2025 05:03:52
Module end 'content'
Timing: Jan 18 2025 05:03:52
Script end

Main resources:

Total runtime1.0563 sec
Peak memory usage4,096.0000 KB
Database Queries46

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0064 589.3672152.6250
Module start 'layout' 0.00640.0032 741.992239.4453
Module start 'content' 0.00961.0452 781.4375473.6875
Module end 'content' 1.05490.0014 1,255.12508.1563
Script end 1.0563  1,263.2813 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00330.3091160.0002
Check MTime0.00150.1375160.0001
Mysql Total
Database connection0.00080.072010.0008
Mysqli_queries1.015796.1570460.0221
Looping result0.00040.0348440.0000
Template Total1.022296.820.5111
Template load0.00230.215620.0011
Template processing1.019996.549620.5099
Template load and register function0.00060.053910.0006
states
state_id_array0.00100.092610.0010
state_identifier_array0.00150.145220.0008
Override
Cache load0.00180.1717100.0002
Sytem overhead
Fetch class attribute can translate value0.00080.071310.0008
Fetch class attribute name0.00050.048720.0003
XML
Image XML parsing0.00050.047210.0005
class_abstraction
Instantiating content class attribute0.00000.000720.0000
General
dbfile0.00160.1545180.0001
String conversion0.00000.000740.0000
Note: percentages do not add up to 100% because some accumulators overlap

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
1content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
2content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 7
 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs