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

Next topic

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 18 2025 11:08:12
Script start
Timing:	Jan 18 2025 11:08:12
Module start 'layout'
Timing:	Jan 18 2025 11:08:12
Module start 'content'
Timing:	Jan 18 2025 11:08:13
Module end 'content'
Timing:	Jan 18 2025 11:08:13
Script end

Main resources:

Total runtime	0.6319 sec
Peak memory usage	4,096.0000 KB
Database Queries	63

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0114	588.0391	152.6406
Module start 'layout'	0.0115	0.0049	740.6797	39.4766
Module start 'content'	0.0163	0.6143	780.1563	568.8438
Module end 'content'	0.6306	0.0012	1,349.0000	16.1250
Script end	0.6318		1,365.1250

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0047	0.7391	16	0.0003
Check MTime	0.0019	0.3029	16	0.0001
Mysql Total
Database connection	0.0016	0.2482	1	0.0016
Mysqli_queries	0.5655	89.5004	63	0.0090
Looping result	0.0011	0.1739	61	0.0000
Template Total	0.5876	93.0	2	0.2938
Template load	0.0026	0.4053	2	0.0013
Template processing	0.5850	92.5863	2	0.2925
Template load and register function	0.0001	0.0143	1	0.0001
states
state_id_array	0.0013	0.2127	1	0.0013
state_identifier_array	0.0016	0.2459	2	0.0008
Override
Cache load	0.0022	0.3559	38	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0989	2	0.0003
Fetch class attribute name	0.0011	0.1783	7	0.0002
XML
Image XML parsing	0.0010	0.1509	2	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0036	10	0.0000
General
dbfile	0.0010	0.1587	22	0.0000
String conversion	0.0000	0.0023	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
5	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
5	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
8	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 23 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs