When a user registers but they do not activate, they are marked as a spammer and their profile get this message:

“This user has been marked as a spammer. Only site admins can view this profile.”

The problem is that the only way I have found to change their status is go into the database. There needs to be another way for the admin to automatically activate them. Also, when they log in, they should get a message that they are not activated and need to do that. I have had several users who signed up and either lost or forgot to register.

If anyone else is running into this problem you need to go into your database in the users table and change the user_status from 2 to 0.

[@gaysurfers Participant 14 years, 8 months ago]

I have the same problem. 50% of my users are marked as spammers
I think they don’t get the activation email, or it gets thrown in their SPAM folders..
It would be nice to have a functionality in WP to send them another email with activation link..

[@gaysurfers Participant 14 years, 7 months ago]

HELP!!!

[@scozzari Member 14 years, 6 months ago]

I’m having the same problem. Is there a way to go into the database and change their status? How do I do that?

THanks.

[@markhahnel Participant 14 years, 5 months ago]

any advances?

[@dianat Member 14 years, 4 months ago]

Go to your wp_users table and set user_status to 0.

[@vernonfowler Participant 13 years, 8 months ago]

Thanks dianat – going to your wp_users table and set user_status to 0 works perfectly. And for those who want the SQL for that, it is:
UPDATE `wp_users`
SET `user_status` = 0
WHERE `user_status` = 2