I ran the query below on my production server and apparently have over 5,000 orphaned records. Can that be? Can I safely delete these?
use umbracoCMS
SELECT * FROM umbracoNode, cmsContent -- return nodes 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
Orphaned content records
I ran the query below on my production server and apparently have over 5,000 orphaned records. Can that be? Can I safely delete these?
use umbracoCMS
SELECT * FROM umbracoNode, cmsContent -- return nodes
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
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.