Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 10 Years, 3 Months, 2 Weeks ago Recover a deleted account
#2
Solved: 10 Years, 3 Months, 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.
Jump to the post that solved this thread.


Messages In This Thread
Recover a deleted account - by Stely - 2011-02-24, 04:12 PM
RE: Recover a deleted account - by Yaldaram - 2011-02-24, 04:35 PM
RE: Recover a deleted account - by Stely - 2011-02-25, 02:35 PM
RE: Recover a deleted account - by Alan S. - 2011-02-25, 04:52 PM
RE: Recover a deleted account - by Steven - 2011-02-25, 09:41 PM
RE: Recover a deleted account - by pyridine - 2011-02-26, 12:28 AM
RE: Recover a deleted account - by Steven - 2011-02-26, 12:46 AM
RE: Recover a deleted account - by StrikerMan780 - 2013-04-22, 03:14 PM
RE: Recover a deleted account - by GamingCave - 2014-09-20, 04:36 PM
RE: Recover a deleted account - by mwforum - 2014-12-11, 06:56 PM
RE: Recover a deleted account - by Nammy - 2015-08-08, 12:02 PM
RE: Recover a deleted account - by .m. - 2015-08-08, 12:16 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)