[solved] - Accidentally deleted a forum thread... is there a way to get it back?

Started by anewhobby, December 27, 2010, 02:36:08 PM

Previous topic - Next topic

anewhobby

Accidentally deleted a forum thread... is there a way to get it back?

vbgamer45

Unless you have the recycle bin setup on deleted posts/topics. There is no way to get it back
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

anewhobby

Quote from: vbgamer45 on December 27, 2010, 02:38:29 PM
Unless you have the recycle bin setup on deleted posts/topics. There is no way to get it back

Blast.... google linked me to this recycle bin thing.. but I do not think it is set up...

Where is the option to enable this?

Spoogs

Create a new board, call it Recyble Bin/Trash or whatever you like... only allow moderators and global moderators access (or as you choose)... then go to Admin>>Forum>>Boards>>Settings.... you'll find the option to enable  there... all you have to do is select the board you created... done.

anewhobby

Quote from: Spoogs on December 27, 2010, 02:43:22 PM
Create a new board, call it Recyble Bin/Trash or whatever you like... only allow moderators and global moderators access (or as you choose)... then go to Admin>>Forum>>Boards>>Settings.... you'll find the option to enable  there... all you have to do is select the board you created... done.

Great, thanks man

MrPhil

As far as getting back the original thread (topic?) that was deleted, once it's gone from the database, it's gone. The old data will not be accessible to you unless you're a DB expert who can pick apart the database's internal files and rescue the data before it's overwritten by new posts. If you're desperate to get back that thread, see if your host still has a DB backup from before the thread was deleted. Don't delay -- backups generally aren't kept around that long.

If you restore the old database, you'll lose anything done since then. That might be acceptable, or you might be able to go through the .sql dump/backup with a text editor and tease out the thread in question (and cut and paste it back into a new thread). Of course, you will have to develop some familiarity with how posts and topics are stored, but this is a good excuse to learn! Rather than trying to directly manipulate the database (to store the thread back into it), create a new thread (topic) and paste the original posts in one-by-one (starter post and replies). You could then go into phpMyAdmin and update the poster names, IDs, timestamps, etc. to match the original as closely as possible (you would enter the values you see in the .sql file). Needless to say, back up your database first before trying to do any direct manipulations in phpMyAdmin.

With a recycle board set up, it will be much easier to retrieve deleted threads in the future. Just don't forget to periodically go through and really (finally) delete old threads and posts, once you're sure they're junk/spam or old enough to be of no possible interest to anyone, just to keep the size of the recycle board within reason.

Advertisement: