The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
Hi,
I have around 100k soft-deleted posts on my forum. Is there a way to physical remove all of them? Thanks |
#2
|
||||
|
||||
![]()
Prune Threads Manager
then choose Thread is Deleted (Has a deletion notice) |
#3
|
|||
|
|||
![]()
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.
|
#4
|
|||
|
|||
![]()
Is there any solution for this? I also have very much soft deleted posts on my forums and would like to remove them physically...
|
#5
|
|||
|
|||
![]()
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.
|
#6
|
||||
|
||||
![]()
Try this (backup your post table first !!)
Code:
DELETE FROM post WHERE visible = 2 |
#7
|
|||
|
|||
![]()
Hello, I'm wondering if the query works with vb4. Could someone please confirm that! Thanks so much!
|
#8
|
|||
|
|||
![]()
any confirmation if this worked ok?
|
#9
|
||||
|
||||
![]()
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: Code:
DELETE FROM vb_post WHERE visible = 2 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. |
#10
|
|||
|
|||
![]() Quote:
Quote:
It's a baaaad way ![]() Need another one. |
![]() |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|