Announcement

Collapse
No announcement yet.

Pruning Soft-Deleted Posts

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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).

  • #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


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

      Comment


      • #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


        • #5
          Originally posted by MoMan View Post
          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


          • #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


            • #7
              Originally posted by mikeinjersey View Post
              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


              • #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


                • #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


                  • #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


                    • #11
                      Originally posted by Dbreh View Post

                      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


                      • #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...
                        X