How to Recover Posts/Threads/Messages from a Deleted User in XenForo

If you have deleted a user in XenForo and their posts or private messages are still visible, you can reassign that content to a new user with a simple SQL script. This article will show you how to do that for public posts and private conversations.

Scripts for public posts and topics
Run this SQL command to update posts, topics, and profile posts for a deleted user:

SQL:

UPDATE xf_post SET username = 'NewUsername', user_id = NEW_USER_ID WHERE username = 'OldUsername'; UPDATE...

Click to expand...