Support Forum

member stats never update

DE Dre Erwin
Dre Erwin
Member

member stats at bottom of forum never seem to update..members have been deleted but still show up as members…

11 Answers

New Answer

DE Dre Erwin
Dre Erwin
Member

is it generated from wp?  How can I mass delet from wp?  lots of old spam accounts I assume

IK Ike
Ike
Member

There are a few plugins out there for WP that manage bulk deletes, but I’d also be interested to know how you deleted members?

Are you saying that things like the top posters stats show members that no longer exist in the database?

MP Mr Papa
Mr Papa
Member

unless users are deleted from the wp api, we dont know they were deleted, so we cannot remove the additional information we store for users…

DE Dre Erwin
Dre Erwin
Member

can i delete these users from my control panel on hostgator with myphp?  How do I delete users that have never visited the site?

IK Ike
Ike
Member

I don’t know myphp but if it’s similar to phpmyadmin then yes you can use it to delete users that have never visited the forum. You should be able to filter out all users in the sfmembers table (it will probably have your own or WP prefix such as wp_sfmembers) by users who’s post count is -1. This means they have registered and haven’t visited the forum. Also, a user with a -1 shouldn’t appear in the ‘New Members’ list on the forum.

You can also see this in the SP Admin, see Forum > Users > Member Information. There is a ‘Posts’ column in the middle that shows a person with an X for a user who has never visited the forum.

I would be careful doing this though, I’m not sure how you would separate a spam account from a user who has registered but just simply hasn’t visited the forum. You might want to consider other WP plugins which specifically delete spam accounts. Never used so can’t recommend, but things like ‘User Spam Remover’ will bulk delete, and create a backup just in case so you can’t really go too wrong.

IK Ike
Ike
Member

Good news, thats quite a few spam registrations! What did you do in the end?

YS Yellow Swordfish
Yellow Swordfish
Member

You can also use out spam user removal plugin although you would need to do them in smaller chunks than that!

But it might be worth your while to install it and use it, say, once a month to clean up,

DE Dre Erwin
Dre Erwin
Member

spam blocker didnt work with my theme for some reason..that plugin wanted to be a bitch about things and not install properly lol.

 

I went to myphpadmin wp-spmembers..searched for all with posts of 0 and deleted them all.  On our site its a rule everyone must post…I first did -1 and I didnt delete enough lol…thanks

YS Yellow Swordfish
Yellow Swordfish
Member

I don’t know what ‘spam blocker’ is. Thats not one of ours and not what I was referring to