XF 1.1 User ban : how to delete name

[kankan]

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]

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;

 

[kankan]

Thank you Jake.

 

[kankan]

Re jake
working but had to remove AND user_id=0;

 

[kankan]

But the name on the Postbit under Avatar remains
don't know how to remove it.