Announcement

Collapse
No announcement yet.

How to rotate out Soft Deletes?

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

  • #16
    They should probably get the same expiration option that thread redirects now receive.

    Comment


    • #17
      Originally posted by Freddie Bingham View Post
      They should probably get the same expiration option that thread redirects now receive.
      Is there an option or setting in the admin cp for that?

      Comment


      • #18
        There is no such option that I can see.

        You can prune soft deleted posts by username if you use the Prune by Username option, but I see no option to delete all soft deleted posts.

        Comment


        • #19
          Originally posted by Jake Bunce View Post
          There is no such option that I can see.

          You can prune soft deleted posts by username if you use the Prune by Username option, but I see no option to delete all soft deleted posts.

          I love vbulletin and all..I would just love to know how come something so substancial like this still hasnt been implemented.

          Comment


          • #20
            Originally posted by Smoothie View Post
            Is there an option or setting in the admin cp for that?
            I was alluding to the idea of adding such an option.

            Comment


            • #21
              Originally posted by Freddie Bingham View Post
              I was alluding to the idea of adding such an option.
              Oops, I missed your previous post, Freddie. Sorry bout that. Glad to hear it may be considered.

              Comment


              • #22
                Originally posted by Jake Bunce View Post
                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
                Dear Jack this is the correct query:
                VB mark the deleted post in deletionlog table BUT the post it self still exist in post table so:
                PHP Code:
                [DELETE FROM post WHERE postid IN (select primaryid from deletionlog where type 'post'
                Then:
                PHP Code:
                DELETE FROM attachment WHERE postid IN (select primaryid from deletionlog where type 'post'
                Then:
                PHP Code:
                DELETE FROM deletionlog WHERE type 'post' 
                Last edited by Alawadat; Sat 16th Sep '06, 5:26am.

                Comment


                • #23

                  PHP Code:
                  [DELETE FROM post WHERE postid IN (select primaryid from deletionlog where type 'post'
                  Then:
                  PHP Code:
                  DELETE FROM attachment WHERE postid IN (select primaryid from deletionlog where type 'post'
                  Then:
                  PHP Code:
                  DELETE FROM deletionlog WHERE type 'post' 
                  Where do i paste this? In "Maintenance" / "Execute SQL Query"?

                  Thanks

                  Comment


                  • #24
                    Yes.
                    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


                    • #25
                      is this still correct for vb4x series? I ask due to the different PHP version.
                      VB 5.4.1 - PHP 7..2.4 - MySQL 5.5.56
                      No Addons - none at all.

                      Comment


                      • #26
                        I ask: is in vb4 a real solution for this issue? How to do it?

                        Running querys is a dangerous thing when you don't know what are you doing.
                        Mauricio Solano R. - Costa Rica
                        Vote for fix the double word issue

                        Comment

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