Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Recover Deleted Topic
Avatar
Michael Wilding
Member
Free Members
sp_UserOfflineSmall Offline
Feb 28, 2016 - 12:37 pm

Hi, we deleted a topic rather than a post by mistake. How can we recover the topic?

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 28, 2016 - 12:43 pm

Unless you can get from a db backup, afraid there is no way to recover...   We currently do not have a trash feature that holds deleted items until you empty the trash...  it is on our wishlist, but no ETA...

Avatar
Michael Wilding
Member
Free Members
sp_UserOfflineSmall Offline
Feb 28, 2016 - 12:45 pm

I thought you might say that. If I just want to restore that one thread from a backup, what content do I need to pull from which tables?

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 28, 2016 - 12:55 pm

Well, its rather messy... it will touch many different tables in the db...  the topic data itself will be in sftopics... the posts would be in the sfposts table...  but each member who made a post in that topic, would have their sfmembers row touched (post count)... also it may touch sfgroups and sfforums if the latest topic in the forum or group...

Personally, I would manually recreate each post...  and then use the forum tools, to reassign the post to the right user...

so create the topic with the data from the db...  reassign that post using forum tools to proper author...  then add each post reply with the data from the db and again reassign the user... 

the topic will be recreated though its position within the forum will be the newest instead of its old slot/order... minor detail...

Avatar
Michael Wilding
Member
Free Members
sp_UserOfflineSmall Offline
Feb 28, 2016 - 12:56 pm

Dang, that's a lot of work.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 28, 2016 - 2:07 pm

sorry hopefully not a huge topic...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626