Delete all soft-deleted posts
 

Hi,

I have around 100k soft-deleted posts on my forum. Is there a way to physical remove all of them?

Thanks

Prune Threads Manager

then choose

Thread is Deleted
(Has a deletion notice)

Thanks, but it can only delete soft-deleted threads. There are topics which have many soft-deleted posts inside. I need to delete these posts without delete the topic.

Is there any solution for this? I also have very much soft deleted posts on my forums and would like to remove them physically...

i had a query that did this. i totally forget what it was but i asked over at vb.com if you wanna search my posts.

Try this (backup your post table first !!)

Hello, I'm wondering if the query works with vb4. Could someone please confirm that! Thanks so much!

any confirmation if this worked ok?

The only reason it wouldn't work is if you have specified a table prefix in your config.php file.

For example if your table prefix is: vb_

Then the code would be:

I see no reason why it wouldn't work on VB4 but if your question is about VB4 I suggest asking in the VB4 forum.

Also as this is a database edit, even 1 small typo could wipe out your entire forum, so make sure you have a backup before you try this- this is not a suggestion it is a FACT.

It's working. But it's killing to sh*t all indexes.
It's a baaaad way :(
Need another one.

How about a query to delete posts made before a certain date?

No clue how to write a query, but for example: delete soft-deleted posts if date is at least X days ago

This way you can run the query several times for a part of your posts only & reduce the X progressively.

Helpful also if you want to delete only the old posts.

Possible to write such query?