Advertisement:

Perhaps there's a remedy to issue . . .

Aloittaja CWFBoardsManager, elokuu 10, 2011, 01:02:00 IP

« edellinen - seuraava »

CWFBoardsManager



Greetings:


We are using a SMF 1.1.14.


Sometime last night, one of our Staff deleted 30 members erronneously.


We have the details of those members on file as MS OFFICE EXCEL files, and have re-registered them.


Is there any way their posts prior to this mishap can be credited to the deleted members and the Guest label removed from the earlier posts?
Most of the members delted have more more than 50 posts to to their name. The legend in the side bar at left displays their Display Name, and the label "Guest under it, and no other details.


All help will be appreciated.


Regards.



CWFBoardsManager


ApplianceJunk

I would think it should be possible if you have a backup of the database.

a10

Maybe not entirely relevant as my problem was about attachments wiped from posts & server, see http://www.simplemachines.org/community/index.php?topic=335792

Given you have a recent db backup, the process of reinserting users\posts info may be remotely similar to the way I reinserted attachment info, by splicing content from a recent backup into the current active db. Ended up doing like 500x 'INSERT INTO' operations  >:(   see http://www.simplemachines.org/community/index.php?topic=335792.msg2285999#msg2285999 but it all turned out perfect.

Someone here with knowledge may give an exact recipe for your case.
2.0.19, php 8.0.30, MariaDB 10.6.18. Mods: Contact Page, Like Posts, Responsive Curve, Search Focus Dropdown, Add Join Date to Post.
Stand with 🇺🇦

Kindred

under the 1.1.x series, there is no easy way to do this.

You would have to go to phpmyadmin and run a SQL update on the messages table to re-assign the members. (in the future, instead of re-registering them as new users, restoring backup data directly to the database is probably a better choice.)

on 2.0, you could use the "re-attribute messages to a user" option.
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Advertisement: