Restor posts

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Cliff Evans
Registered User
Posts: 72
Joined: Fri Jan 17, 2014 11:36 am

Restor posts

Post by Cliff Evans »

Is it possible to restore user posts that have been deleted? I have a backup of the Db from before the deletion but only want to restor posts from one user.
User avatar
warmweer
Jr. Extension Validator
Posts: 5855
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: Restor posts

Post by warmweer »

Cliff Evans wrote:
Fri Jan 17, 2020 9:32 am
Is it possible to restore user posts that have been deleted? I have a backup of the Db from before the deletion but only want to restor posts from one user.
Yes, it's possible, but the question is how many posts you want to restore.
If there are few, the easiest way would be to enter them manually using the normal board features (writing the post, saving, then assigning the post to a different user, possibly also changing the post_time.).
If there are many it could be done with SQL but that is (a lot) more complicated.
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.
User avatar
Mick
Support Team Member
Support Team Member
Posts: 22919
Joined: Fri Aug 29, 2008 9:49 am
Location: Watching cricket probably.

Re: Restor posts

Post by Mick »

"The more connected we get the more alone we become" - Kyle Broflovski©
Cliff Evans
Registered User
Posts: 72
Joined: Fri Jan 17, 2014 11:36 am

Re: Restor posts

Post by Cliff Evans »

Thanks for the quick reply. 1787 posts including photos, quite a lot!!
Cliff Evans
Registered User
Posts: 72
Joined: Fri Jan 17, 2014 11:36 am

Re: Restor posts

Post by Cliff Evans »

Mick wrote:
Fri Jan 17, 2020 9:45 am
Have you got soft delete active? https://www.phpbb.com/support/docs/en/3 ... ls_delete/
Unfortunately no!
Cliff Evans
Registered User
Posts: 72
Joined: Fri Jan 17, 2014 11:36 am

Re: Restor posts

Post by Cliff Evans »

It is my own fault, rushing through things!!
User avatar
david63
Registered User
Posts: 18584
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Contact:

Re: Restor posts

Post by david63 »

Cliff Evans wrote:
Fri Jan 17, 2020 9:46 am
Thanks for the quick reply. 1787 posts including photos, quite a lot!!
And how many posts since?
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored
Cliff Evans
Registered User
Posts: 72
Joined: Fri Jan 17, 2014 11:36 am

Re: Restor posts

Post by Cliff Evans »

From other users, quite a few!
User avatar
warmweer
Jr. Extension Validator
Posts: 5855
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: Restor posts

Post by warmweer »

The first thing you should do is to extract all the posts from that user to a dedicated table and then take your time to perform some thorough checks.
Check whether the post_id's are still available (join with the current posts_table: if there are no records so much the better, if there are you'll have to edit)
Check whether the topic still exists (you may have deleted a topic if no other user posted in that topic, in which case the topic has to be inserted also).
Just check everything you can think of (e.g. does the forum in which each post was made still exist).

At the end you'll probably want to set the user's postcount correct also, (and the postcounts per forum, per topic).

It's feasible but not something you should try on a live forum before having tested the procedure.

IIRC there was a similar request about 2 months ago (for a lot more posts even).
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.
Cliff Evans
Registered User
Posts: 72
Joined: Fri Jan 17, 2014 11:36 am

Re: Restor posts

Post by Cliff Evans »

Thank you.
Post Reply

Return to “[3.3.x] Support Forum”