XF 2.1 Removing name and posts of banned member

[MBJ86]

We had to remove a problematic member, but messed up at the point where we had the option to rename that member's content in the process (so that previous posts/activity would come up as by BannedUser123 or whatever). So now we still have the banned person's username showing up around the forum with their old activity, but no link to a profile or way to manage it, as their account has been deleted.

Ideally we would like to remove both the name AND all of their previous activity in the forum.

Help? :/

 

[djbaxter]

You'd have to do this with an SQL query via phpMyAdmin.

UPDATE `xf_post` SET username = 'Deleted member' WHERE username = 'oldusername';

This assumes you are using a prefix of xf_ for your database tables. If you don't use a prefix, change to this:

UPDATE `post` SET username = 'Deleted member' WHERE username = 'oldusername';