Ghost node solve the crawling problem

 

Finally After solve the ghost node, My crawling search start working again.

This query safe my time.

SELECT * FROM umbracoNode, 
WHERE 
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

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