Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Sébastien Richer 194 posts 430 karma points
    Aug 13, 2012 @ 19:29
    Sébastien Richer
    0

    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

    Copy Link
  • Sébastien Richer 194 posts 430 karma points
    Aug 13, 2012 @ 19:45
    Sébastien Richer
    0

    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).

     

     

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft