Quick Login
A webmaster forum specifically catering for Australian site owners. We discuss site development, marketing and management issues.
Please welcome our newest member, sweettaylor!
Spice up your web site with the ultimate community message board solution!
Fake Id'sGet fake Id's made right now!
vBSEOSearch Engine Optimization for your VBulletin Forum.
AdminFusion
»
Restoring a single thread
01-11-2008, 05:41 AM
| #1 |
| | |||||
Title: Forum Addict
Join Date: Jan 2006 Posts: 1,338 Location: Illinois  
| Restoring a single thread Is this possible? I asked on vb.com and the reply I received was that he "didn't know of any easy way." Anyone have suggestions? I lost a thread with several thousand posts and would like it back if possible. Thanks,  | ||||
| |
|
01-11-2008, 05:47 AM
| #2 |
| | ||
| how did you lose it? | |
| |
|
01-11-2008, 05:52 AM
| #3 |
| | |||||
|
Title: Forum Addict
Join Date: Jan 2006 Posts: 1,338 Location: Illinois
| It was deleted by a new moderator, unfortunately.  I have a backup that's a week or two older. I'd loose some posts in the thread, but if I could somehow restore it I would save most. | ||||
| |
|
01-11-2008, 06:06 AM
| #4 |
| | ||
|
| ask on vb.org. i'm sure you can do it | |
| |
|
01-21-2008, 11:20 AM
| #7 |
| | |||||
 Title: Member
Join Date: Jul 2007 Posts: 75 Location: Perth, Western Australia 
| Yeah, it's doable. Not the easiest thing to do but anyone who knows SQL and vBulletin would be able to. I would also recommend not giving moderators access to physically remove. | ||||
| |
|
01-21-2008, 11:19 PM
| #8 |
| | |||||
 Title: Member
Join Date: Apr 2007 Posts: 130 Location: Louisville, KY | I swear I saw I hack on vBorg about just this. Restoring old threads. Forgive me, but I can't be bothered to actually find it for you, but I do remember it was in 3.6 modifications. | ||||
| |
|
02-22-2008, 12:59 PM
| #9 |
| | ||||||
 Title: Member
Join Date: Feb 2008 Posts: 58 Location: Bhopal (India) 
| I tried to do the same on my localhost. Result : Successful. Table 1 : post (this is the original vbulletin table that holds the posts' data) Table 2 : post1 (I created this table from an older backup which contained those deleted posts too) Now you need to know the THREADID of the thread that you want to restore. In my case the THREADID was 2. To copy the deleted posts of thread 2 from post1 table to the post table, i ran this query : Code: INSERT INTO post( postid, threadid, parentid, username, userid, title, dateline,pagetext, allowsmilie, showsignature, ipaddress, iconid, visible, attach, infraction, reportthreadid) SELECT postid, threadid, parentid, username, userid, title, dateline, pagetext, allowsmilie, showsignature, ipaddress, iconid, visible, attach, infraction, reportthreadid FROM post1 WHERE threadid = 2 AND parentid <> 0; Now we need to copy the thread information. Table 1 : thread (original vbulletin table that holds the threads' information) Table 2 : thread1 (Created this table too from the same older backup which contained that deleted thread/posts) And then ran this query : Code: INSERT INTO thread( threadid, title, firstpostid, lastpostid, lastpost, forumid, pollid, open, replycount, hiddencount, deletedcount, postusername, postuserid, lastposter, dateline, views, iconid, notes, visible, sticky, votenum, votetotal, attach, similar) SELECT threadid, title, firstpostid, lastpostid, lastpost, forumid, pollid, open, replycount, hiddencount, deletedcount, postusername, postuserid, lastposter, dateline, views, iconid, notes, visible, sticky, votenum, votetotal, attach, similar FROM thread1 WHERE threadid = 2; You're done. Now go to your AdminCP's maintenance section and rebuild all your counters. Quote:
 | |||||
| |
|
02-22-2008, 01:06 PM
| #10 |
| | ||||||
| Title: Lurker
Join Date: Feb 2008 Posts: 9 Location: England | Quote:
Does your host provide nightly backups? You could probably get a more recent version from them if you asked nicely? | |||||
| |
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Thread Runners Group #1 | rex_b | Exchanges and Partnerships | 31 | 08-25-2007 03:09 PM |
| « Previous Thread | New Posts | Next Thread » | Ryan | Forums General | 21 | 07-24-2006 02:25 PM |
| One thread for One thread | MafiaMaster | Exchanges and Partnerships | 9 | 07-18-2006 12:07 AM |
Linear Mode
