Support » Fixing WordPress » Removing unconfirmed users

  • I have lots of users and I suspect many of them are inactive spammers that will never confirm their registrations, leaving me with a database full of garbage.

    I was looking for a plugin that cleans up unconfirmed (not inactive) users, but haven’t found one, so I thought of writing a query that deletes from wp_users where user_activation_key is NULL and the date is up to 30 days ago.

    Would that do the right thing?

Viewing 2 replies - 1 through 2 (of 2 total)
  • I have a plan for dealing with such things, and I might do a plugin for it this weekend. I will post an update here.

    If combine it with a good plugin for removing inactive users, that might make it a complete single offer. Either way, will my query do the trick? This way, I can get going manually for a bit.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Removing unconfirmed users’ is closed to new replies.