Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 10 Years, 1 Month, 2 Weeks ago Recover a deleted account
#1
Solved: 10 Years, 1 Month, 2 Weeks ago
Is there a way to recover a deleted account? A shitty admin just deleted it and it had over 2000 posts.

I don't want to use backup.
#2
Solved: 10 Years, 1 Month, 2 Weeks ago
You'll have to reassign the old posts to the new account; the only thing to go by once the account is deleted, is the username though. So you want UPDATE mybb_threads/posts SET uid=123 WHERE uid=0 AND username='Oldname' or something like that. And then Recount&Rebuild all counters.

If there were guests who at one point used the same name as the registered user, the guest posts will also be assigned to the user though.

The alternative is selectively restoring the users old data from a backup file.

Either way you'll have to do that manually and you should know a little SQL to do that. Make a backup before you break your forum with a bad SQL command.
#3
Solved: 10 Years, 1 Month, 2 Weeks ago
Can you detail the first option?
#4
Solved: 10 Years, 1 Month, 2 Weeks ago
Create a new account for the deleted member, then run these queries in phpMyAdmin:

UPDATE `mybb_threads` SET `uid` = 'X' WHERE `username` = 'Y';
UPDATE `mybb_posts` SET `uid` = 'X' WHERE `username` = 'Y';

Where X is the new account ID and Y is the old username.

Then go to ACP >> Tools & Maintenance >> Recount & Rebuild and rebuild/recount the first 4 options.
#5
Solved: 10 Years, 1 Month, 2 Weeks ago
(2011-02-25, 04:52 PM)AJS Wrote: Create a new account for the deleted member, then run these queries in phpMyAdmin:

UPDATE `mybb_threads` SET `uid` = 'X' WHERE `username` = 'Y';
UPDATE `mybb_posts` SET `uid` = 'X' WHERE `username` = 'Y';

Where X is the new account ID and Y is the old username.

Then go to ACP >> Tools & Maintenance >> Recount & Rebuild and rebuild/recount the first 4 options.

Er, simply merge the users. ACP -> Users & Groups -> Merge Users.
[Image: 422.png]
#6
Solved: 10 Years, 1 Month, 2 Weeks ago
Um, you can't merge a user if it's deleted...
--Pyridine
#7
Solved: 10 Years, 1 Month, 2 Weeks ago
(2011-02-26, 12:28 AM)pyridine Wrote: Um, you can't merge a user if it's deleted...

Oh, right. Carry on... Toungue

/logic fail
[Image: 422.png]
#8
Solved: 10 Years, 1 Month, 2 Weeks ago
Can someone please make a plugin that can automate this process? Me being a worthless and stupid dumbass, I deleted 11 users off my forum accidentally.. and I have no goddamn backup... :\
#9
Solved: 10 Years, 1 Month, 2 Weeks ago
Could anyone help with this issue on 1.8 I've tired running the above with the correct info to no avil.
Edit never I figured it out.
[Image: DGFZU75.png]
#10
Solved: 10 Years, 1 Month, 2 Weeks ago
I would also like to know how to do this. I have a member who left and asked that his membership be deleted but we kept his posts and now he's back and I'd like to merge his old posts with his new posts.

Thanks.
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)