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?
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.
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
You can try this: http://our.umbraco.org/forum/core/general/17462-Missing-nodes-in-backend?p=1#comment68851.
Jeroen
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.
is working on a reply...