Umbraco Node error even after deleteing recycle bin
My umbraco content is not loading. I have a sql script that I use to delete the recycle bin whenever this happens. But for some reason this time it is not loading. My script is below.
begin transaction
-- 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 from umbracoRelation where parentId in (select id from umbracoNode where path like '%-20%' and id!=-20)
delete from umbracoRelation where childId in (select id from umbracoNode where path like '%-20%' and id!=-20)
delete from umbracoUser2NodePermission where nodeId in (select nodeId from umbracoNode where path like '%-20%' and id!=-20)
delete from umbracoUser2NodeNotify where nodeId in (select nodeId from umbracoNode where path like '%-20%' and id!=-20)
-- delete the XML nodes....
delete from umbracoDomains WHERE domainRootStructureID in (SELECT id FROM umbracoNode WHERE path like '%-20%' and id != -20)
delete from umbracoNode where path like '%-20%' and id!=-20
Umbraco Node error even after deleteing recycle bin
My umbraco content is not loading. I have a sql script that I use to delete the recycle bin whenever this happens. But for some reason this time it is not loading. My script is below.
begin transaction
-- 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 from umbracoRelation where parentId in (select id from umbracoNode where path like '%-20%' and id!=-20)
delete from umbracoRelation where childId in (select id from umbracoNode where path like '%-20%' and id!=-20)
delete from umbracoUser2NodePermission where nodeId in (select nodeId from umbracoNode where path like '%-20%' and id!=-20)
delete from umbracoUser2NodeNotify where nodeId in (select nodeId from umbracoNode where path like '%-20%' and id!=-20)
-- delete the XML nodes....
delete from umbracoDomains WHERE domainRootStructureID in (SELECT id FROM umbracoNode WHERE path like '%-20%' and id != -20)
delete from umbracoNode where path like '%-20%' and id!=-20
rollback transaction
Maybe a way with sql to delete unpublished nodes? IS that possible?
is working on a reply...