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:
Post a Comment