Delete all soft-deleted posts [Archive]

View Full Version : Delete all soft-deleted posts

vampireus

01-17-2006, 03:36 PM

Hi,

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

Thanks

kriscad

01-18-2006, 03:16 AM

Prune Threads Manager

then choose

Thread is Deleted
(Has a deletion notice)

vampireus

01-18-2006, 01:36 PM

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

10-08-2006, 03:08 PM

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

10-08-2006, 03:12 PM

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

10-08-2006, 05:47 PM

Try this (backup your post table first !!)

DELETE FROM post WHERE visible = 2

cvn

07-30-2010, 12:29 AM

Try this (backup your post table first !!)

DELETE FROM post WHERE visible = 2Hello, I'm wondering if the query works with vb4. Could someone please confirm that! Thanks so much!

dethfire

02-23-2011, 10:11 PM

any confirmation if this worked ok?

BirdOPrey5

02-27-2011, 05:35 PM

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

03-10-2011, 02:02 PM

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!

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

HeyMe

04-26-2011, 09:13 AM

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?