XF 2.2 How to change name of deleted member

[Mr Lucky]

I deleted a member due to GDPR request.

So they show as Deleted Member 4567. Does anyone know if there is a way to now change this name to something else?

If there is no easier direct way within xenForo (censor words doesn't seem to take effect) then maybe a safe database query?

Thanks

 

[Mr Lucky]

Found the answer. You need to create a temporary user with the name you want, find their id (eg 9999 in the example below) and run this query.

UPDATE `xf_post`
SET `user_id` = replace(user_id, '0', '9999')
WHERE username = 'Deleted Member 4567'

The deleted member is now live again with new name and they can then be deleted.

 

[Ricsca]

Weren't you better at renaming the user and changing their password and email?

 

[MentaL]

Found the answer. You need to create a temporary user with the name you want, find their id (eg 9999 in the example below) and run this query.

UPDATE `xf_post`
SET `user_id` = replace(user_id, '0', '9999')
WHERE username = 'Deleted Member 4567'

The deleted member is now live again with new name and they can then be deleted.

765 days later.

Repect.

 

[TPerry]

765 days later.

Ahhh... the quickness of support....