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

[lucien_lies]

lucien_lies submitted a new resource:

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

If you've deleted a user in XenForo and their posts or private messages are still showing up, you can reassign that content to a new user with a simple SQL script. This tutorial covers how to do that for public posts and private conversations.

Script for Public Posts and Threads​

Run this SQL script to update posts, threads, and profile posts for a deleted user:

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

Read more about this resource...