Announcement

Collapse
No announcement yet.

How to rotate out Soft Deletes?

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

  • 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

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


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

      thanks

      Comment


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


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


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

            Thread State = Deleted

            Comment


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


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


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


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


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


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


                        • #13
                          You can delete soft deletions in your:

                          Admin CP -> Threads & Posts -> Prune

                          Comment


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


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