I had a member (Tommy Tester) who was a moderator and I deleted him, his posts showed as a guest and so I reassigned them to another moderator who was also called Tommy Tester (oops well it is a test forum)

I removed all traces of the original member by going into the database and deleting him in all the places I thought he would be, wp_usermeta, wp_users, wp_sfmembers etc.

In the footer there is a count of the posts for moderators in brackets next to the moderators name. There is only one moderator and poor old Tommy Tester gets this:

Moderators: Tommy Tester(1), (8)

It’s the ghost of Tommy Tester the first who has 8 posts attributed which are actually reassigned to the current Tommy Tester.

How can I get rid of them?