Pruning Soft-Deleted Posts

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MoMan
    Senior Member
    • Oct 2005
    • 345
    • 3.8.x

    Pruning Soft-Deleted Posts

    My moderation.php?do=viewposts&type=deleted page in the UserCP currently indicates that I nearly have 3,000 soft-deleted posts sitting in the database, but deleting the posts through this interface would take ages, as only four posts are shown per page.

    While I know that opening moderation.php and modifying this line:

    PHP Code:
    sanitize_pageresults($totalposts$pagenumber$perpage2004); 
    would lengthen the list on that page, is there any other way to efficiently prune such deleted posts (and threads, for that matter)?
    Adam

    Admin of PentaxForums.com, premiere photography forum for Pentax users (Big-Board).
  • David Grove
    Senior Member
    • Apr 2008
    • 3507
    • 5.5.x

    #2
    You can use the ACP pruning option to prune all deleted threads and see how many that takes care of. Of course there will still be some deleted posts left over.
    ~~~~~

    Comment

    • mikeinjersey
      Senior Member
      • Apr 2005
      • 369

      #3
      be careful with the pruning tool. And only prune threads that are already in the "deleted" state.

      Comment

      • MoMan
        Senior Member
        • Oct 2005
        • 345
        • 3.8.x

        #4
        I've now successfully pruned all my old deleted threads, but I still can't find a tool that will allow me to prune deleted posts in undeleted / current threads.
        Adam

        Admin of PentaxForums.com, premiere photography forum for Pentax users (Big-Board).

        Comment

        • mikeinjersey
          Senior Member
          • Apr 2005
          • 369

          #5
          Originally posted by MoMan
          I've now successfully pruned all my old deleted threads, but I still can't find a tool that will allow me to prune deleted posts in undeleted / current threads.
          I've been waiting for that function for years as well... And quite frankly im not sure why vBulletin hasnt added it yet.

          Comment

          • MoMan
            Senior Member
            • Oct 2005
            • 345
            • 3.8.x

            #6
            In that case do we have to resort to mysql queries?

            Code:
            DELETE FROM deletionlog WHERE type = 'post'
             
            DELETE FROM post WHERE visible = 2;
            Adam

            Admin of PentaxForums.com, premiere photography forum for Pentax users (Big-Board).

            Comment

            • Will.Spencer
              Member
              • May 2006
              • 43
              • 3.5.x

              #7
              Originally posted by mikeinjersey
              I've been waiting for that function for years as well... And quite frankly im not sure why vBulletin hasnt added it yet.
              4 April 2011 -- still not implemented.

              Comment

              • ablaye
                Member
                • Apr 2006
                • 44

                #8
                I was looking for the same thing. Does anyone know if there is a mod that supports this?
                Project4Hire.com - Find Freelance Progammers and Graphic Designers for all your project needs
                Webmaster forum

                Comment

                • Dbreh
                  New Member
                  • Dec 2004
                  • 16
                  • 3.8.11

                  #9
                  Take Care,

                  You can do it from forum interface no need to get in to Forum Control Panel
                  OK, I'll give you simple way to get red of that

                  1- You Should be Admin
                  2- See this Code, change & paste it in your browser:

                  HTML Code:
                  http://www.xxxxxx/vb/moderation.php?do=viewposts&type=deleted&pp=50&daysprune=100&sort=dateline&order=desc&page=1
                  xxxxxx = your domain
                  deleted&pp=50 means number of posts will be viewed in each page,
                  100&sort=dateline, means how many previous days you would like to check and prune. (If it's for last 2 years change it to be 700 or more)

                  3- do select all, than do normal delete.
                  Note, Don't prune more than 50 posts in each cycle this may over load you server.
                  Aviation & Flying News

                  Comment

                  • Pocket Aces
                    Member
                    • Mar 2007
                    • 99
                    • 4.2.x

                    #10
                    80,000 soft-deleted posts for the past 5 years,
                    still a pain in the ass permanently deleting those posts in batches of 200.
                    vBulletin 4.2.5 | PHP 7.0.31 | MariaDB 10.2.17

                    Comment

                    • Dora
                      New Member
                      • Dec 2010
                      • 13
                      • 4.2.x

                      #11
                      Originally posted by Dbreh

                      HTML Code:
                      http://www.xxxxxx/vb/moderation.php?do=viewposts&type=deleted&pp=50&daysprune=100&sort=dateline&order=desc&page=1
                      thank you
                      Very helpful.

                      Comment

                      • lifanovsky
                        Senior Member
                        • Oct 2004
                        • 269
                        • 4.0.0

                        #12
                        Any news on this one?
                        Boris Lifanovsky; administrator of the biggest Russian classical music forum

                        Lifanovsky.com | ForumKlassika.Ru

                        Comment

                        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                        Working...