How to rotate out Soft Deletes?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mikeinjersey
    Senior Member
    • Apr 2005
    • 369

    How to rotate out Soft Deletes?

    Hello, I posted this on vbulletin.org, but nobody ever helps out over there.

    can someone tell me if there is a mod available out there that can rotate out Soft Deletes over a period of time? My understand is that soft deletes never get deleted from the database...thus, taking up space just like a normal post.

    Would be great if there is either a mod out there that can do this..or instructions on how to add a cron to do this would be awesome.

    thanks
    MB
  • Jake Bunce
    Senior Member
    • Dec 2000
    • 46598
    • 3.6.x

    #2
    You want to physically delete the soft deletes?

    Doing that automatically would require a custom scheduled task. For help writing such a task, I recommend you post on www.vbulletin.org.

    Or you can do it manually in your:

    Admin CP -> Threads & Posts -> Prune

    Comment

    • mikeinjersey
      Senior Member
      • Apr 2005
      • 369

      #3
      Jake, i dont see the option to delete all Soft Deleted messages , using the prune option. Can u be more specific?

      thanks

      Comment

      • mikeinjersey
        Senior Member
        • Apr 2005
        • 369

        #4
        If i select "Prune All Forums".. does that eliminate just the soft deleted messages..or does that delete all posts from the forums? I was a little gun shy just now..was about to do it..but decided to play it safe and post here first.

        Comment

        • Steve Machol
          Former Customer Support Manager
          • Jul 2000
          • 154488

          #5
          There is no option to prune all soft-deleted posts. And if you Prune All Forums, then this will remove all posts, so you definitely don't want to do that.
          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment

          • Jake Bunce
            Senior Member
            • Dec 2000
            • 46598
            • 3.6.x

            #6
            Admin CP -> Threads & Posts -> Prune

            Thread State = Deleted

            Comment

            • Marco van Herwaarden
              Senior Member
              • Nov 2004
              • 6999
              • 3.8.x

              #7
              Originally posted by Jake Bunce
              Admin CP -> Threads & Posts -> Prune

              Thread State = Deleted
              That would only work for soft deleted Threads i think, not for just Posts.
              Want to take your board beyond the standard vBulletin features?
              Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

              Comment

              • Jake Bunce
                Senior Member
                • Dec 2000
                • 46598
                • 3.6.x

                #8
                You can manually restore soft posts with this query:

                Code:
                DELETE FROM deletionlog
                WHERE type = 'post'
                Code:
                UPDATE post
                SET visible = 1
                WHERE visible = 2
                That should work, but I haven't tested it.

                Comment

                • Marco van Herwaarden
                  Senior Member
                  • Nov 2004
                  • 6999
                  • 3.8.x

                  #9
                  Jake,

                  If i understand this all correct, the user wants to permantly remove soft-deleted post, not make them visible again.
                  Want to take your board beyond the standard vBulletin features?
                  Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

                  Comment

                  • Jake Bunce
                    Senior Member
                    • Dec 2000
                    • 46598
                    • 3.6.x

                    #10
                    Oh my bad. Change that second query:

                    Code:
                    DELETE FROM post
                    WHERE visible = 2
                    Once again, untested. Backup first.

                    You will need to update counters afterwards:

                    Admin CP -> Maintenance -> Update Counters

                    Comment

                    • Marco van Herwaarden
                      Senior Member
                      • Nov 2004
                      • 6999
                      • 3.8.x

                      #11
                      If you only want to delete them after X days, you can user the following query, replacing X with the number of days:
                      Code:
                      DELETE FROM `post`
                      WHERE visible = 2
                      AND dateline < UNIX_TIMESTAMP() - (60 * 60 * 24 * X)
                      Want to take your board beyond the standard vBulletin features?
                      Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

                      Comment

                      • mikeinjersey
                        Senior Member
                        • Apr 2005
                        • 369

                        #12
                        I initially posted this thread 6 months ago or so.. was wondering if any new functions were added to help with this in 3.6?

                        A function to physically delete all soft deletes. Which would save alot of space on my server.

                        Also, Do I have to update my counters once I :

                        Admin CP -> Threads & Posts -> Prune
                        Thread State = Deleted
                        ?

                        Comment

                        • Jake Bunce
                          Senior Member
                          • Dec 2000
                          • 46598
                          • 3.6.x

                          #13
                          You can delete soft deletions in your:

                          Admin CP -> Threads & Posts -> Prune

                          Comment

                          • mikeinjersey
                            Senior Member
                            • Apr 2005
                            • 369

                            #14
                            Jake, but this only deleted Threads that have been soft deleted.

                            How about posts within a thread that have been soft deleted? Is there a automatic cron that physically deletes them after a month or so? If not, I think there should be one implemented as it would be very helpful and reduce the database size.

                            Comment

                            • Smoothie
                              Senior Member
                              • Oct 2001
                              • 250

                              #15
                              Yea, there definitely should be an option in the admin cp to control how long soft deleted threads and or posts are kept.

                              Comment

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