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

  • 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