MyBB Community Forums

Accidentally deleted a user that wasn't meant to. I managed to restore his account and link his posts/threads back to his name, but he lost all of his Private Messages as well. I was wondering if there was a way I could link these back to him like I did with the posts/threads.

UPDATE mybb_posts SET uid = 'X' WHERE username = 'X'

That was the query I used to link the posts back, do Private Messages work like this as well?

No, I'm afraid that's not possible. When you delete a user via ACP, the private messages are also deleted. Together with all reputation and other stuff. Only the posts are kept.

Would be a lovely plugin (like the "undo delete" one for threads) to have user and pm backup tables for such cases.

^ that would waste the resources as there can be thousands of deleted messages..

if it is really important then extracting/restoring from a database backup might help