Register Members List Search Today's Posts Mark Forums Read

Reply
 
Article Options
How-To Delete the Contents of a Large Forum
Birched
Join Date: Sep 2007
Posts: 35

by Birched Birched is offline 22 Sep 2009

How To Delete the Contents of a Large Forum

At some point, many of us prune older threads in order to keep our database size manageable.

The most obvious way to delete a large forum (containing many threads, subforums, subsubforums, etc -- you get the idea) seems to be this:
AdminCP -> Forums & Moderators -> Forum Manager

That seems to work for smaller forums.

Unfortunately, according to my own experience and several other reports on this site, vbulletin.com, and others, this doesn't work for anything big. When I tried to delete a large forum representing just over half of my post table, total MYI file size ~2 GB, the script ran for almost 4 hours and then failed silently. It did unsubscribe people from the forum (and subforums), but not from the threads, nor did it delete anything (or, if it did, the amount of deletion performed was negligible). I found no trace of any error messages.

vBulletin support suggested that I go in and delete the subforums individually by hand. Unfortunately, there were over a thousand of them, and the interface is clunky at best. Spending the next 2 weeks deleting forums for 8 hours a day just wasn't going to work out.

To automate this job, one should instead start go to:
AdminCP -> Threads & Posts -> Prune

And prune threads. In our case, with a ~5 GB database and 4 GB of memory, I could process about 2000 threads at a time with successful completion. For me, this meant stepping through the thread 50 to 100 days at a time through its history (your rate of thread addition will likely be different, but the same general approach can be applied).

Once the forum I wanted to remove had less than about 10,000 threads in it (including in subforums), I was able to remove all of the rest of it the officially prescribed way, using forum manager.

And that's it! Sounds pretty simple, but if I'd run across a post containing this information earlier this weekend, I'd have saved hours of my time.

Last edited by Birched; 22 Sep 2009 at 13:09..
Views: 8533
Reply With Quote
Comments
  #2  
Old 04 Apr 2013, 17:03
matrex722's Avatar
matrex722 matrex722 is offline
 
Join Date: Jan 2007
nice informations
can you help me please
Prune Post Edit History Manager is not working in my admincp
i dont know how to use it
its always say there is nothing to do
Reply With Quote
  #3  
Old 04 Apr 2013, 17:21
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Originally Posted by matrex722 View Post
nice informations
can you help me please
Prune Post Edit History Manager is not working in my admincp
i dont know how to use it
its always say there is nothing to do
It may already be empty. Did you ever have it turned on and use it? If not, then there is nothing to do. See if there are any rows in your postedithistory table. If there aren't any, then there is nothing to do.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #4  
Old 04 Apr 2013, 17:29
matrex722's Avatar
matrex722 matrex722 is offline
 
Join Date: Jan 2007
yes postedithistory table is empty
see this only when i click over it in phpmyadmin

http://www.7elm3aber.com/up/images/7...6983326958.png

put there are many threads have edit history
and i want to delete them

i see it when i choose edit thread from thread options inside the thread
Reply With Quote
  #5  
Old 04 Apr 2013, 19:07
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
edit history is just showing an edit date on the bottom of the thread (table editlog). Post edit history is storing the contents of the posts as it is edited so you can go back and see what has been changed (table postedithistory).
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #6  
Old 05 Apr 2013, 09:44
matrex722's Avatar
matrex722 matrex722 is offline
 
Join Date: Jan 2007
can you try it yourself here
go to Article Options or Thread Tools as it is in 3.8 translated and choose edit thread > perform action
and click save changes to confirm editing ( do not change any thing i dont want Birched hate me )
do it again go to Article Options you will see this



hahahah i saw it now when i changed language from arabic to english

its in moderatorlog i think not postedithistory table

so how can i remove them

and what will happen if i choose to empty moderatorlog table

i want to thank you so much for your interest
its big honor to me

Last edited by matrex722; 05 Apr 2013 at 13:12.
Reply With Quote
  #7  
Old 05 Apr 2013, 17:32
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
You may delete your moderator logs in admincp > statistics & logs > moderator logs > prune moderator log. If you prune them, you just won't see things in Edit Thread where it shows the moderator log (like in your image).

Why are you trying to do this? You are not going to be saving a bunch of database space by the actions you are talking about here.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #8  
Old 05 Apr 2013, 18:14
matrex722's Avatar
matrex722 matrex722 is offline
 
Join Date: Jan 2007
its not about space
it works like a charm as you said admincp > statistics & logs > moderator logs > prune moderator log
thank you so much
and i hope i didn't bothered you
Reply With Quote
  #9  
Old 05 Apr 2013, 18:19
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Of course you didn't bother me.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
Reply



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

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 03:01.

Layout Options | Width: Wide Color: