Friday, February 11, 2011

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

No comments: