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

Please Sign in or register to post replies

Write your reply to:

Draft