Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 17 Jan 2006, 16:36
vampireus vampireus is offline
 
Join Date: Jan 2005
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
Reply With Quote
  #2  
Old 18 Jan 2006, 04:16
kriscad's Avatar
kriscad kriscad is offline
 
Join Date: May 2004
Prune Threads Manager

then choose

Thread is Deleted
(Has a deletion notice)
Reply With Quote
  #3  
Old 18 Jan 2006, 14:36
vampireus vampireus is offline
 
Join Date: Jan 2005
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.
Reply With Quote
  #4  
Old 08 Oct 2006, 16:08
Paul Janowitz Paul Janowitz is offline
 
Join Date: Dec 2005
Is there any solution for this? I also have very much soft deleted posts on my forums and would like to remove them physically...
Reply With Quote
  #5  
Old 08 Oct 2006, 16:12
SCRIPT3R SCRIPT3R is offline
 
Join Date: Jan 2005
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.
Reply With Quote
  #6  
Old 08 Oct 2006, 18:47
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Try this (backup your post table first !!)


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #7  
Old 30 Jul 2010, 01:29
cvn cvn is offline
 
Join Date: May 2006
Originally Posted by Paul M View Post
Try this (backup your post table first !!)


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.
Hello, I'm wondering if the query works with vb4. Could someone please confirm that! Thanks so much!
Reply With Quote
  #8  
Old 23 Feb 2011, 23:11
dethfire dethfire is offline
 
Join Date: Feb 2003
any confirmation if this worked ok?
__________________
Check out my sites:
http://www.physicsforums.com
http://www.chefsuccess.com
Reply With Quote
  #9  
Old 27 Feb 2011, 18:35
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
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:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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.
__________________
-Joe
Former vb.org Moderator. Retired.

@BirdOPrey5 | All Things BOP5 | Joe's Ultimate Off Topic
Note - I no longer making new VB mods, sorry.
Reply With Quote
  #10  
Old 10 Mar 2011, 15:02
Ramzesik Ramzesik is offline
 
Join Date: Aug 2006
Originally Posted by Paul M View Post
Try this (backup your post table first !!)


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.
Originally Posted by cvn View Post
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.
Reply With Quote
  #11  
Old 26 Apr 2011, 10:13
HeyMe HeyMe is offline
 
Join Date: Mar 2008
Originally Posted by Ramzesik View Post
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?
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mini Mods GS - Delete Soft Deleted Visitor Messages Every 30 Days 1.0 ForumsMods vBulletin 3.8 Add-ons 12 29 Jul 2014 23:42
Mini Mods GS - Delete Soft Deleted Posts Every 30 Days 1.0 ForumsMods vBulletin 3.7 Add-ons 20 02 Jan 2013 08:45
Mini Mods GS - Deluxe Delete Soft Deleted 1.1 ForumsMods vBulletin 3.7 Add-ons 32 21 Aug 2011 09:01
Mini Mods GS - Delete Soft Deleted Threads Every 30 Days 1.0 ForumsMods vBulletin 3.7 Add-ons 7 15 Sep 2008 00:49



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 04:05.

Layout Options | Width: Wide Color: