Copied to clipboard

Flag this post as spam?

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


  • Corey Toolis 12 posts 32 karma points
    Mar 05, 2014 @ 20:33
    Corey Toolis
    0

    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

     

  • Corey Toolis 12 posts 32 karma points
    Mar 05, 2014 @ 20:58
    Corey Toolis
    0

    Maybe a way with sql to delete unpublished nodes? IS that possible?

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies