Support » Plugin: Bulk Delete » Bulk User Delete woes

  • Resolved muskie

    (@muskie)


    Downloaded your plugin as I got too many fake subscribers and no actual newsletter or even much popularity so 24000 spam accounts, I tried deleting all subscribers with and without a date limitation and it just seems to return a blank white screen, of course in another browser window I checked and all the subscribers are still there, is it timing out, should I try deleting a couple 100 at a time? I really could just go into PHAdmin and remove them if I had to it is a one time thing, but I read about your plugin…

    Should I just use SQL? Do I need a better Internet connection?

Viewing 5 replies - 1 through 5 (of 5 total)
  • only 24,000, this is why i disabled it all together

    Plugin Author Sudar Muthu

    (@sudar)

    Looks like either your server is running out of memory or is timing out.

    You can go to Bulk WP -> System Info to find out how much memory is allocated to PHP in your server. You can also try to increase the amount of memory allocated to PHP.

    Try to reduce the number of users that are getting deleted to a very low number and see if it is able to delete it properly. If yes then you can keep increasing the number till you hit the threshold. After that you have to either manually delete the users in batches with that size or buy the scheduler add-on to auto schedule the deletion.

    You can also try to run a SQL query to delete the users, but make sure you do the following (all of which the plugin does)

    – Delete all user meta information from wp_user_meta table
    – Delete all posts (or reassign them) created by these users
    – Delete or retain comments made by these users
    – Delete or retain attachments uploaded by these users

    Yeah I thought on creeping up on it, I tried using a date, but maybe I’ll try a hard number like 100 and keep increasing it, honestly their might be a couple real people in the 24,000 but considering I use Disqus for comments and it cuts down on Spam but also seems to cut down on comments as you can’t as easily make a fake throwaway account, these subscribers are all spammers and script kiddies.

    Thanks I’ll let you know how it works when I get time to test it more.

    I was able to delete 999 users at a time, I guess that is good enough, I should have probably looked into this sooner but I had another plugin stopping the emails and registrations but I got hit by some spammers at some points, I never cared about all the useless subscribers, but now I’m cleaning up my database I guess this update, too many people probing one particular file…

    Thanks for your help.

    Plugin Author Sudar Muthu

    (@sudar)

    Glad to know that you were able to find out the threshold and also clean your database.

    I am marking this as resolved now. Feel free to reopen it if you need any other details regarding this.

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.