XF 2.2 How to change name of deleted member

Mr Lucky

Well-known member
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
 
Solution
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.


Code:
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.
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.


Code:
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.
 
Solution
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.


Code:
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.
 
Back
Top Bottom