Delete all soft-deleted posts

[vampireus]

Hi,

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

Thanks

[kriscad]

Prune Threads Manager

then choose

Thread is Deleted
(Has a deletion notice)

[vampireus]

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.

[Paul Janowitz]

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

[SCRIPT3R]

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.

[Paul M]

Try this (backup your post table first !!)

DELETE FROM post WHERE visible = 2

[cvn]

Originally Posted by Paul M

Try this (backup your post table first !!)

DELETE FROM post WHERE visible = 2

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

[dethfire]

any confirmation if this worked ok?

[BirdOPrey5]

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:

DELETE FROM vb_post WHERE visible = 2

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.

[Ramzesik]

Originally Posted by Paul M

Try this (backup your post table first !!)

DELETE FROM post WHERE visible = 2

Originally Posted by cvn

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

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