• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.1 User ban : how to delete name

kankan

Active member
#1
Hello

I have deleted a user on our forum. (XF 1.1.3)
But his name (not active) still appears on postbit.
Please can you tell me which SQL request to parse in order to replace his name by another ?
Thank you for your support.
 

Jake Bunce

XenForo moderator
Staff member
#2
Code:
UPDATE xf_post
SET username = 'new username'
WHERE username = 'old username'
AND user_id = 0;

UPDATE xf_thread
SET username = 'new username'
WHERE username = 'old username'
AND user_id = 0;