-- Uncomment below to verify the number of nodes returned is the -- same as the number of nodes that is in the Recycle Bin -- select * from umbracoNode where path like '%-20%' and id!=-20 -- Delete all 'related' nodes and table contents... delete from cmsPreviewXml where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20) delete from cmsContentVersion where contentId in (select id from umbracoNode where path like '%-20%' and id!=-20) delete from cmsDocument where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20) delete from cmsContentXML where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20) delete from cmsContent where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20) delete from cmsPropertyData where contentNodeId in (select id from umbracoNode where path like '%-20%' and id!=-20) -- delete the XML nodes.... delete from umbracoNode where path like '%-20%' and id!=-20
Umbraco Fix – Empty recycle bin using SQL if backend fails
Leave a comment ?
Its it really useful??
Sometimes very …. !!! Umbraco recycle bin crashes on many items…
Also may need to clean up relations with this before deleting from umbracoNode
delete from umbracoUser2NodePermission where nodeId in (select nodeId from umbracoNode where path like ‘%-20%’ and id!=-20)