I’m getting a lot of spam registrations on my WordPress blog and have been removing them as they come in (captcha plugins not working, but that’s another story for elsewhere). My Simple-Press forum is located in a subfolder.
To delete these spam registrations, I go into the site’s mysql database via phpMyAdmin and delete them from the wp_users table.
My question is that, while these spammers’ names disappear from my main WordPress site’s members list, I can still see them appearing on my forum pages, at the bottom where the Newest Members are listed. When I click on their names, the pop-up profile shows them as “guest” which indicates that the user has been removed.
I would like to know how do I remove these names in this Newest Members listing altogether?
I thought that removing their registrations from the wp_users table would remove all traces of these spammers, but I have also found them in two other tables, one of them I believe is a Simple Press forum table – wp_signups and wp_sfmembers.
Even when I remove the records in these two other tables, I am still unable to get rid of their names in the Newest Members listing.
Can anyone help with a solution to this issue?