Thread

I let my guard down and probably have 100k spam registrations I need to get rid of.

I think a series of searches can help a lot, but at 20 results per page, there’s no way I can do that and still catch the 2020 Olympics.

Is there any way to increase the number of member search results?  Or is there some other method to delete many users all at once (properly - as I was tempted to dive into the DB, but saw how messy it might be).

Maybe there’s an add-on I can’t find that’ll help with this?

EE 2.5.1

Same thing happened to me on a EE 1.67 site (yikes!)

Go into the DB and run the following query and it’ll delete all the members from the specified group (5, in this example):

delete from exp_members where group_id = 5

Make a backup beforehand, just in case!

If I did that I’d wipe out all my members 😊

They’re not all in one group.  Some may be pending, but many are confirmed.  I need to do searches on them, and while I can add a “WHERE” statement to the SQL, I don’t want to orphan any related data in other tables, which there seems to be.

Ah, gotcha 😊

If you’d like to increase the member results per page in the CP, you can override the setting in your config.php (defaults to 50).

/system/expressionengine/config/config.php

$config['memberlist_row_limit'] = 300;

Nice.  I should have looked for something like that, thanks 😊

I was only getting 20 as a default.

Either way, my sweet spot right now seems to be 600.  It’s enough to start making a little dent.

I tried adding this to a client’s site and nothing changed, stayed at the default 50

$conf['memberlist_row_limit'] = "300";

EE 1.7.3

Oops looks like you used “conf” instead of “config”.

as per the wiki “conf” is what’s used http://expressionengine.com/wiki/Config_Overrides

Did you try “config” anyway?

yup, still nothing. thanks for taking the time to reply.