Copied to clipboard

Flag this post as spam?

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


  • Kim Grandgagnage 63 posts 87 karma points
    Aug 06, 2011 @ 22:12
    Kim Grandgagnage
    0

    No nodes visible in Content section?

    When I go to the content section of my website, no nodes are visible, although when I run the website in the browser, everythings seems ok. I still have all my document types, templates and so on.

    Any ideas? :s

  • Bo Damgaard Mortensen 719 posts 1207 karma points
    Aug 08, 2011 @ 22:21
    Bo Damgaard Mortensen
    0

    Hi Kim,

    That issue is often caused by ghost/rogue nodes in the database.

    If you know the id of the rogue node you can try running a cleanup script like this:

    (!! The following script should NOT be used without taking a backup of both the site and the database !!)

    DELETE FROM cmsDocument where nodeId=1072
    DELETE FROM cmsPreviewXml WHERE versionId
    in(SELECT versionId FROM cmsContentVersion WHERE contentid=1072)
    DELETE FROM cmsContentVersion
    where contentid=1072
    DELETE FROM cmsContentXml
    where nodeid=1072
    DELETE FROM cmsContent
    where nodeid=1072
    DELETE FROM cmsPropertyData
    where contentnodeid=1072
    DELETE FROM umbracoNode
    where id=1072

    If not, you need to get a good cup of warm coffee and clean your head from everything disturbing and search through the tables for the given node that causes the problem ;-)

    Again, be careful when messing with the database as it's quite a steep climb to get it back running again if something goes wrong.

    Hope this helps a bit.

    All the best,

    Bo

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

Please Sign in or register to post replies