Support » Plugin: Bulk Delete » Delete users without role

  • Resolved infusiongenius

    (@infusiongenius)


    I have a WP site that got hammered with sploggers. There are over 400,000 fake accounts in the system. The strange thing is all of these are set to “none” role. I thought this plugin might help clean all of these out in bulk but I am not finding a way of selecting the “none” role with I go to bulk delete. I have been able to stop this massive flow of signups but need to clean up the database since it is beyond bloated right now. Any ideas?

    https://wordpress.org/plugins/bulk-delete/

Viewing 15 replies - 1 through 15 (of 22 total)
  • Plugin Author Sudar Muthu

    (@sudar)

    Is “none” a role listed under user roles or users are not associated with any role at all?

    Also show me a screenshot of the users page.

    Thread Starter infusiongenius

    (@infusiongenius)

    No it is not which is what I find really strange. Here is a screenshot.

    https://dl.dropboxusercontent.com/u/3251529/users.png

    Plugin Author Sudar Muthu

    (@sudar)

    This is really strange. Will it be possible for you to give me access to your server?

    If yes then I can find out what is happening and then edit my plugin so that those users can also be deleted.

    If you decide to give me access then you can find my email address at http://sudarmuthu.com/contact/

    Thread Starter infusiongenius

    (@infusiongenius)

    Just sent you and email. Thank you.

    Plugin Author Sudar Muthu

    (@sudar)

    I haven’t heard back from you. Are you still facing this issue?

    rachelcjstuf

    (@rachelcjstuf)

    I am having this same issue. I have gradually been deleting over 12K spam accounts. All have a user role of “none” and can only be deleted manually (about 400 at a time). Not sure how they are even getting in as my site requires registration and approval.

    I already have Akismet blocking spam from the site. Is it possible that Akismet blocks the spam but it still sets up a user with a role of “none”? I’m going in and slowly deleting all of these users manually but would like a more permanent solution moving forward.

    Plugin Author Sudar Muthu

    (@sudar)

    @rachelcjstuf,

    Even I am not sure how users with no user role get’s added to WordPress. I suspect some how spammers are able to directly execute SQL queries.

    I kind of found a way to delete those users, but since I was not able to create users with no user role, I was not able to test it.

    Would you be interested in testing a beta version of my plugin with this code?

    If it works then it would be possible for you to delete all the users in a single click.

    rachelcjstuf

    (@rachelcjstuf)

    I’d be happy to test. I still have about 10K users to delete and would love to have a way to prevent it in the future (or at least a way to bulk delete weekly/monthly).

    Let me know how I can get the beta plugin.

    Plugin Author Sudar Muthu

    (@sudar)

    Thanks for accepting to test the beta version.

    I will integrate the code and will give you the beta version in a day or two.

    Plugin Author Sudar Muthu

    (@sudar)

    @rachelcjstuf,

    The beta version is ready. You can get it from http://bulkwp.com/project/wordpress/bulk-delete/bulk-delete-5.4.2-beta.zip

    Kindly note that I haven’t fully tested it. So it is better to take a backup of your site before you try it.

    Let me know if it works.

    Plugin Author Sudar Muthu

    (@sudar)

    @rachelcjstuf

    Did you get a chance to test the beta version of the plugin? Did it allowed you to delete users who didn’t belong to any role?

    @sudar

    Sorry for the delay. I’ve gotten distracted with some other work items. I’m going to back up our site and try it this week. I will let you know.

    RAchel

    @sudar:

    I downloaded the beta and it installed just fine. However, it is not allowing me to delete any users with the “none” role. I select “none” and then ask it to delete the first 800 (I noticed you said it wouldn’t work if there are more than 1000) but after it processes, it says “O users deleted”. I still have the 12,400 users that remain to delete.

    Any ideas?

    Plugin Author Sudar Muthu

    (@sudar)

    @rachelcjstuf,

    Would it be possible for you to give me access to your db?

    I would like to look at how these users without userrole are stored in your db.

    Plugin Author Sudar Muthu

    (@sudar)

    @rachelcjstuf,

    Are you willing to give me access to your db for debugging?

Viewing 15 replies - 1 through 15 (of 22 total)
  • The topic ‘Delete users without role’ is closed to new replies.