Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Pete 213 posts 285 karma points
    Aug 26, 2013 @ 16:19
    Pete
    0

    Deleted Comments do not empty from Recycle Bin

    I'm running 4.11.9 and ublogsy 2.1.1.0, I've got 40 comments in the bin, with half of them published, when I go to empty the recycle bin it hangs. Shouldn't the deleted comments get unpublished when moved to the recycle bin?

    Thanks
    Pete

    Copy Link
  • Anthony Dang 1404 posts 2558 karma points MVP 3x c-trib
    Aug 27, 2013 @ 16:55
    Anthony Dang
    0

    Possibly an umbraco bug?

    Try some dangerous sql:

     

    begin transaction

    -- 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 umbracoDomains WHERE domainRootStructureID IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20)

    DELETE FROM umbracoUser2NodePermission WHERE nodeId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20)

    DELETE FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20

    commit transaction

     

     

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft