This site has been archived and you can no longer log in or post new messages. For up-to-date community resources please visit ezplatform.com

eZ Community » Forums » Developer » DB : Invalid node ids in...
expandshrink

DB : Invalid node ids in eznode_assignment

DB : Invalid node ids in eznode_assignment

Tuesday 14 December 2010 11:48:11 am

Hi eZ Community.

I am running eZ Publish 4.3 with a lot of data import and just found out a bug in my sync scripts related to eznode_assignment db table.

I have in this table invalid values for the parent_node field, deleted nodes I guess as those node ids are not in any other tables (but in a coherent range).

I tried to delete all rows of eznode_assignment with an invalid parent_node (Yes I like making huge sub selects) :

DELETE FROM eznode_assignment WHERE parent_node NOT IN( SELECT node_id FROM ezcontentobject_tree )

I had about 200 / 17000+ rows in this case.

My scripts are working back and everythings looks ok but that's weird...

Before messing with production, I'd like to know if anyone has experienced such a thing ?

No reply yet!

expandshrink

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu

Proudly Developed with from