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

[Admin]

Admin submitted a new resource:

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

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 =...

Read more about this resource...