How to rotate out Soft Deletes?

[Freddie Bingham]

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

[Smoothie]

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?

[Jake Bunce]

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.

[mikeinjersey]

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.

[Freddie Bingham]

Is there an option or setting in the admin cp for that?

I was alluding to the idea of adding such an option.

[mikeinjersey]

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.

[Alawadat]

Oh my bad. Change that second query:

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:

[DELETE FROM post WHERE postid IN (select primaryid from deletionlog where type = 'post') 

Then:

DELETE FROM attachment WHERE postid IN (select primaryid from deletionlog where type = 'post') 

Then:

DELETE FROM deletionlog WHERE type = 'post' 

[hydn]

[DELETE FROM post WHERE postid IN (select primaryid from deletionlog where type = 'post') 

Then:

DELETE FROM attachment WHERE postid IN (select primaryid from deletionlog where type = 'post') 

Then:

DELETE FROM deletionlog WHERE type = 'post' 

Where do i paste this? In "Maintenance" / "Execute SQL Query"?

Thanks

[Steve Machol]

Yes.

[karlm]

is this still correct for vb4x series? I ask due to the different PHP version.

[msolano]

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.