Forums / General / can't edit object assigned to root node (2)

can't edit object assigned to root node (2)

Author Message

Andrew Kelly

Tuesday 05 June 2007 7:29:25 am

Hi all,

I've just upgraded from 3.8.6 to 3.8.8 and suddenly I cannot edit the object at my root node (object ID 1, Node ID 2). It keeps chucking a fatal error with transaction ID in the browser, and the error logs tell me
Error: error executing query: DELETE FROM eznode_assignment WHERE id='' ERROR: invalid input syntax for integer: ""

I've tracked this to the purge function in kernel/classes/eznodeassignment.php (which incidentally is unchanged compared to the previous version).

Anybody seen something like this before?

Andy

Andrew Kelly

Tuesday 07 August 2007 6:08:47 am

Still baffled by this one, folks, and looking for any help out there.

There's an additional problem, very likely related. If I'm embedding an object and choose to select an existion object, I get an error if I try to "go upstream" of node 2. Basically this call:

/layout/set/dialog/content/browse/1

returns an error, "The requested object is not available...."

What is causing all this?

Anybody?

Andy

Kristof Coomans

Friday 10 August 2007 12:34:48 am

Hello Andrew

Looks like you have some serious troubles. Did you run all database update scripts? The issue didn't occur on 3.8.6, did it?

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Andrew Kelly

Friday 10 August 2007 6:31:06 am

Hi Kristof, long time no read ;-)

You know, I can't really answer that question for you right now, not with any real accuracy anyway. I do know that I first encountered this error condition after the upgrade to 3.8.8. And I do know that this condtion did not exist immediately after the upgrade to 3.8.6. But I cannot say if the condition appeared immediately following the upgrade to 3.8.8 or if it was already present at that time. Editing the root node isn't something we really need to do much, you see.

To more tightly localise when this might have first appeared, I'm going to have to play in some backups and check things out. Sadly, though, the disks I need are off-site in a vault and everybody who has access is currently away on vacation and will be for a while yet. (How's that for great planning at the boss-level ;-) ).

My guts are telling me that the problem has something to do with a node-assignment record disappearing, or something of that nature. It's definitely in the db, at any rate.

For what it's worth, I upgraded to 3.9.2 two days ago, and the condition persists.

Out of curiosity, how the heck is node 1 maintained in the DB. I can't find a direct assignment in any table anywhere. The closest I can come is finding it listed (correctly) as parent node of several others.

Andy

Andrew Kelly

Wednesday 19 September 2007 3:35:43 am

Just a follow up, in case anybody ever bumps into this as well.

I've been able to verify that the upgrade from 3.8.6 to 3.8.8 did not have any involvement. The "breakage" occurred prior to and independantely of the upgrade.
It's impossible for me to reconstruct HOW it happened, but WHAT happened was pretty much what I had suspected. In table 'ezcontentobject_tree', the record for contentobject_id=1 had gone missing. A reconstruction of this record solved this, and several other related problems.

Andy

eZ debug

Timing: Jan 19 2025 07:14:41
Script start
Timing: Jan 19 2025 07:14:41
Module start 'content'
Timing: Jan 19 2025 07:14:42
Module end 'content'
Timing: Jan 19 2025 07:14:42
Script end

Main resources:

Total runtime0.8098 sec
Peak memory usage4,096.0000 KB
Database Queries200

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0068 589.0781180.8203
Module start 'content' 0.00680.6557 769.8984573.9375
Module end 'content' 0.66240.1472 1,343.8359337.3750
Script end 0.8097  1,681.2109 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00410.5050210.0002
Check MTime0.00160.1961210.0001
Mysql Total
Database connection0.00080.100610.0008
Mysqli_queries0.725389.56602000.0036
Looping result0.00220.27761980.0000
Template Total0.779496.320.3897
Template load0.00190.240520.0010
Template processing0.777596.013520.3887
Template load and register function0.00020.020310.0002
states
state_id_array0.00130.159810.0013
state_identifier_array0.00090.114620.0005
Override
Cache load0.00170.2073380.0000
Sytem overhead
Fetch class attribute can translate value0.00210.263930.0007
Fetch class attribute name0.00120.153670.0002
XML
Image XML parsing0.00300.373830.0010
class_abstraction
Instantiating content class attribute0.00000.0029100.0000
General
dbfile0.00540.6622330.0002
String conversion0.00000.001730.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
5content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
5content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
8content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 23
 Number of unique templates used: 7

Time used to render debug report: 0.0002 secs