umbracoNode records without their cmsContent counterpart
Hello,
I have these nodes that have an umbracoNode element, but not it's cmsContent counterpart. I've done some programmatic manipulation (deletes) and I think this might have caused this. Should I just delete these umbracoNodes?
This is the querie that shows them:
SELECT id, trashed, parentID, nodeUser, [level], path, sortOrder, uniqueID, text, nodeObjectType, createDate FROM umbracoNode WHERE (id NOT IN (SELECT nodeId FROM cmsContent))
Just to be sure, there are many core nodes in that query, I refined it to this :
SELECT TOP (10000) id, trashed, parentID, nodeUser, [level], path, sortOrder, uniqueID, text, nodeObjectType, createDate FROM umbracoNode WHERE (id NOT IN (SELECT nodeId FROM cmsContent)) AND (parentID <> - 1) ORDER BY path
This way I just see my styles and my broken nodes. (I have 3).
umbracoNode records without their cmsContent counterpart
Hello,
I have these nodes that have an umbracoNode element, but not it's cmsContent counterpart. I've done some programmatic manipulation (deletes) and I think this might have caused this. Should I just delete these umbracoNodes?
This is the querie that shows them:
SELECT id, trashed, parentID, nodeUser, [level], path, sortOrder, uniqueID, text, nodeObjectType, createDate
FROM umbracoNode
WHERE (id NOT IN (SELECT nodeId FROM cmsContent))
Thanks
Just to be sure, there are many core nodes in that query, I refined it to this :
SELECT TOP (10000) id, trashed, parentID, nodeUser, [level], path, sortOrder, uniqueID, text, nodeObjectType, createDate
FROM umbracoNode
WHERE (id NOT IN (SELECT nodeId FROM cmsContent)) AND (parentID <> - 1)
ORDER BY path
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.