[Scott RileyParticipant]

Hello? Still waiting for a response to my request for help deleting users with “none” role.

The WP Bulk plugin does not seem to work. It indicates that there are 0 (zero) users with the “none” role, while in fact there are 139,052 (after I manually deleted a few thousand).

I’ve done everything you suggested. The users do not get created again when deleted from the database, as you suggested. I can spend the hours doing it manually, but if your plugin is faulty, you should let me, and everyone else know what you are planning to do to fix it. Don’t just ignore me.

Please reply. Thank you.

[Scott RileyParticipant]

Thank you for your help Sudar.

I contacted the host provider. They performed a malware scan that came up clean. They also reinstalled the core files and changed the DB P/W. They could not find a hole, but did say that it was most likely caused by an SQL injection of some kind.

I disabled new user registration and installed the Wordfence plugin. I initiated one scan that returned PHP warnings regarding errors while sending Query packets (error_log-1.txt attached). It also returned a “problems found” result while scanning for unknown files in wp-admin and wp-includes, and “comparing plugins against WordPress.org originals”. There was a fatal error regarding memory allocation (I suspect that has something to do with the 450,000 users). It did not provide detailed info, or remedies. I’m currently running a second scan.

I still need help deleting the thousands of users currently in the database. I looked at the wp-users table via phpMyAdmin, but I cannot find a way to select more than one user at a time for deletion. Isn’t that what your plugin is supposed to do? Why won’t it work?

Please help. Thank you.

Attachments:

You must be logged in to view attached files.

[Scott RileyParticipant]

Hi Sudar,

• I believe these were sploggers, so I don’t know how they were created or if they were directly inserted into the DB. They just kept appearing until there were close to 145,000.

• No, it is not a multisite.

• As you requested, a screen shot of the first page of users with “None” roles is attached.

• I also attached a screenshot of the bulk delete users admin page. Note that the select list to delete users (at the top) includes: “none (0 users)”, while the user list shows 140,103 users with “none”.

• I attached a screenshot of the plugins list as well, for you to review for potential conflicts.

Attachments:

You must be logged in to view attached files.

[Author]

Posts