Title: Delete users without role Last modified: August 22, 2016 --- # Delete users without role * Resolved [infusiongenius](https://wordpress.org/support/users/infusiongenius/) * (@infusiongenius) * [11 years, 9 months ago](https://wordpress.org/support/topic/delete-users-without-role/) * 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/](https://wordpress.org/plugins/bulk-delete/) Viewing 15 replies - 1 through 15 (of 22 total) 1 [2](https://wordpress.org/support/topic/delete-users-without-role/page/2/?output_format=md) [→](https://wordpress.org/support/topic/delete-users-without-role/page/2/?output_format=md) * [Sudar Muthu](https://wordpress.org/support/users/sudar/) * (@sudar) * [11 years, 9 months ago](https://wordpress.org/support/topic/delete-users-without-role/#post-5213330) * 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](https://wordpress.org/support/users/infusiongenius/) * (@infusiongenius) * [11 years, 9 months ago](https://wordpress.org/support/topic/delete-users-without-role/#post-5213332) * No it is not which is what I find really strange. Here is a screenshot. * [https://dl.dropboxusercontent.com/u/3251529/users.png](https://dl.dropboxusercontent.com/u/3251529/users.png) * [Sudar Muthu](https://wordpress.org/support/users/sudar/) * (@sudar) * [11 years, 9 months ago](https://wordpress.org/support/topic/delete-users-without-role/#post-5213338) * 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/](http://sudarmuthu.com/contact/) * Thread Starter [infusiongenius](https://wordpress.org/support/users/infusiongenius/) * (@infusiongenius) * [11 years, 9 months ago](https://wordpress.org/support/topic/delete-users-without-role/#post-5213342) * Just sent you and email. Thank you. * [Sudar Muthu](https://wordpress.org/support/users/sudar/) * (@sudar) * [11 years, 9 months ago](https://wordpress.org/support/topic/delete-users-without-role/#post-5213636) * I haven’t heard back from you. Are you still facing this issue? * [rachelcjstuf](https://wordpress.org/support/users/rachelcjstuf/) * (@rachelcjstuf) * [11 years, 2 months ago](https://wordpress.org/support/topic/delete-users-without-role/#post-5213734) * 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. * [Sudar Muthu](https://wordpress.org/support/users/sudar/) * (@sudar) * [11 years, 2 months ago](https://wordpress.org/support/topic/delete-users-without-role/#post-5213735) * [@rachelcjstuf](https://wordpress.org/support/users/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](https://wordpress.org/support/users/rachelcjstuf/) * (@rachelcjstuf) * [11 years, 2 months ago](https://wordpress.org/support/topic/delete-users-without-role/#post-5213736) * 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. * [Sudar Muthu](https://wordpress.org/support/users/sudar/) * (@sudar) * [11 years, 2 months ago](https://wordpress.org/support/topic/delete-users-without-role/#post-5213737) * 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. * [Sudar Muthu](https://wordpress.org/support/users/sudar/) * (@sudar) * [11 years, 2 months ago](https://wordpress.org/support/topic/delete-users-without-role/#post-5213738) * [@rachelcjstuf](https://wordpress.org/support/users/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](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. * [Sudar Muthu](https://wordpress.org/support/users/sudar/) * (@sudar) * [11 years, 2 months ago](https://wordpress.org/support/topic/delete-users-without-role/#post-5213739) * [@rachelcjstuf](https://wordpress.org/support/users/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? * [rachelcjstuf](https://wordpress.org/support/users/rachelcjstuf/) * (@rachelcjstuf) * [11 years, 2 months ago](https://wordpress.org/support/topic/delete-users-without-role/#post-5213740) * [@sudar](https://wordpress.org/support/users/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 * [rachelcjstuf](https://wordpress.org/support/users/rachelcjstuf/) * (@rachelcjstuf) * [11 years, 2 months ago](https://wordpress.org/support/topic/delete-users-without-role/#post-5213741) * [@sudar](https://wordpress.org/support/users/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? * [Sudar Muthu](https://wordpress.org/support/users/sudar/) * (@sudar) * [11 years, 2 months ago](https://wordpress.org/support/topic/delete-users-without-role/#post-5213742) * [@rachelcjstuf](https://wordpress.org/support/users/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. * [Sudar Muthu](https://wordpress.org/support/users/sudar/) * (@sudar) * [11 years, 2 months ago](https://wordpress.org/support/topic/delete-users-without-role/#post-5213743) * [@rachelcjstuf](https://wordpress.org/support/users/rachelcjstuf/), * Are you willing to give me access to your db for debugging? Viewing 15 replies - 1 through 15 (of 22 total) 1 [2](https://wordpress.org/support/topic/delete-users-without-role/page/2/?output_format=md) [→](https://wordpress.org/support/topic/delete-users-without-role/page/2/?output_format=md) The topic ‘Delete users without role’ is closed to new replies. * ![](https://ps.w.org/bulk-delete/assets/icon-256x256.png?rev=3422675) * [Bulk Delete](https://wordpress.org/plugins/bulk-delete/) * [Frequently Asked Questions](https://wordpress.org/plugins/bulk-delete/#faq) * [Support Threads](https://wordpress.org/support/plugin/bulk-delete/) * [Active Topics](https://wordpress.org/support/plugin/bulk-delete/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/bulk-delete/unresolved/) * [Reviews](https://wordpress.org/support/plugin/bulk-delete/reviews/) * 22 replies * 6 participants * Last reply from: [lindsayLu](https://wordpress.org/support/users/lindsaylu/) * Last activity: [10 years, 10 months ago](https://wordpress.org/support/topic/delete-users-without-role/page/2/#post-5213752) * Status: resolved