Remove excessive (19000!) pending members
How Do I?
We left the ability to create a membership active, even though we took the link to join off of the site.
The end result is 19,000 spam-bot “members” in the pending category.
When I click on “Pending” in the Members control panel area, it times out having used up too much memory. (I have 4GB of RAM on this server!!!)
Using 3.1.4.
Is there a SQL command to rid myself of these?
Thanks for any help!
Terry
[EDIT] Will this work with a 3.x.x site? http://expressionengine.stackexchange.com/questions/21628/delete-thousands-of-members-from-an-ee2-site/22146#22146
Delete all pending ExpressionEngine members mysql query
DELETE FROM exp_member_data where member_id in (select member_id FROM exp_members where group_id = 4) LIMIT 1000000
DELETE FROM exp_message_folders where member_id in (select member_id FROM exp_members where group_id = 4) LIMIT 1000000
DELETE FROM exp_member_homepage where member_id in (select member_id FROM exp_members where group_id = 4) LIMIT 1000000
DELETE FROM exp_members where group_id = 4 LIMIT 1000000NOTE: DO NOT DO THIS TO ID = 5 / MEMBERS See https://ellislab.com/forums/viewthread/248821/
Those worked!
(Tested with “Select *” first and a smaller LIMIT entry).
Also found this to be very useful, for anyone else in this situation finding this post:
Delete from exp_members where group_id = ‘group_id_to_delete’ AND member_id not in (Select member_id From exp_member_data where last_visit > 0);
That takes out members who never actually visited after signing up, who only came to plant a profile link or prep things for comment spam. You could increase the number above zero at the end to pull out seldom-visitors.
Always test with “Select *” first with a small LIMIT entry.
Terry