ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Deleting registration spam

September 10, 2013 11:05am

Subscribe [2]
  • #1 / Sep 10, 2013 11:05am

    deckard97

    137 posts

    Hello,

    the link to spam fighting leads to a pretty unhelpful 404 not found page.

    http://ellislab.com/blog/entry/fighting_registration_spam/

    Does that entry still exist somewhere?

    Meanwhile, I must delete 17000 members and would like to not do it 50 at a time, so here’s my question:

    1) is it still possible to have a config override to display more members at a time?
    Ideally I would search by IP address (big chunks have the same IP) doing a “New member search”, but I only get 50 back each time and when I delete I get sent back to the View members page and must search again.
    This had no effect in /system/expressionengine/config/config.php:

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

    Or 2) using PHPMyAdmin, can I just search by IP and delete all spam members in the following tables?

    exp_member_data
    exp_member_homepage
    exp_members

    Would that break my DB?

    Many thanks.

    v 1.6.8

  • #2 / Sep 10, 2013 11:29am

    deckard97

    137 posts

    I’ve found this post concerning deleting members with PHPMyAdmin:
    http://ellislab.com/forums/viewthread/198393/

    But would still like to know if I could augment the number of member list rows from the CP as this could be done by the client itself.

    Thanks.

  • #3 / Sep 12, 2013 10:21am

    Following info in the following forum post worked for me…got rid of over 78,000 members and changed settings so won’t be getting anymore.

    http://ellislab.com/forums/viewthread/236065/

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases