Kurniawan Kurniawan Blogs: Fix for No Document exists with Version '00000000-0000-0000-0000-000000000000' when sorting

Friday, February 11, 2011

Fix for No Document exists with Version '00000000-0000-0000-0000-000000000000' when sorting

Finally I found what may cause the problem.

It’s because I installed runway sitemap and in some reason, it create a ghost node

http://our.umbraco.org/forum/getting-started/questions-about-runway-and-modules/10685-No-Document-exists-with-Version-%2700000000-0000-0000-0000-000000000000%27?p=0#comment40259

Do a select first to check

select * FROM umbracoNode
WHERE
umbracoNode.nodeObjectType = 'C66BA18E-EAF3-4CFF-8A22-41B16D66A972' -- that are of type 'Content'
AND
umbracoNode.id NOT IN (SELECT nodeId FROM cmsContent) -- but are not in the 'Content' table

===

and delete that node.

Delete FROM umbracoNode
WHERE
umbracoNode.nodeObjectType = 'C66BA18E-EAF3-4CFF-8A22-41B16D66A972' -- that are of type 'Content'
AND
umbracoNode.id NOT IN (SELECT nodeId FROM cmsContent) -- but are not in the 'Content' table

3 comments:

Anonymous said...: When I run the deletion query, I get this:

Msg 547, Level 16, State 0, Line 1
The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_umbracoNode_umbracoNode". The conflict occurred in database "CoastRTA_CMS", table "dbo.umbracoNode", column 'parentID'.
The statement has been terminated.

Any ideas?; 3:09 AM
Anonymous said...: Thank you so much ! It saved me a lot of time and that was exactly my issue.; 5:17 PM
Anwar ul Haq said...: Msg 547, Level 16, State 0, Line 3
The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_umbracoNode_umbracoNode". The conflict occurred in database "DatabaseName", table "dbo.umbracoNode", column 'parentID'.
The statement has been terminated.; 1:48 AM