Copied to clipboard

Flag this post as spam?

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


  • Iain Martin 54 posts 98 karma points
    Jul 30, 2012 @ 09:27
    Iain Martin
    0

    Orphaned Node - how to delete?

    I have a running site where there is an orphaned node that is proving impossible to delete. It does not appear anywhere in the content tree or in the recycle bin, but each time the site is published, this node reappears. You can see the node in the raw database tables.

    As you cannot get to the node via the GUI, I need to find a way to delete this node from SQL Server. Obviously I have tried to delete it using an SQL Query, but run in to the foreign key constraints and as the site is live I don;t want to go around deleting content out of the various tables with gay abandon.

    Does anyone have a TSQL script or stored procedure that could achieve this function?

    Regards

    Iain

     

  • Jeroen Breuer 4908 posts 12265 karma points MVP 5x admin c-trib
    Jul 30, 2012 @ 11:29
  • Iain Martin 54 posts 98 karma points
    Jul 30, 2012 @ 13:14
    Iain Martin
    0

    That pretty much worked.

    Had to add in the 'Delete from cmsContentXml where nodeID=xxx' line as well, and then delete the umbraco.config file and rebuild/republish the site and refresh the cache, but eventually the node dismissed itself to hellfire and damnation.

     

    Cheers Jeroen.

Please Sign in or register to post replies

Write your reply to:

Draft