2

My first EE 1.6.8 site is coming back to haunt me. The site crashed and burned the other day. Took a look at the members in the DB and there's about 78000 spam members in there. I have access to PHPAdmin for the DB, but I don't know what I'm doing in there. Any help?

6

Always backup first!

Hopefully they're all still pending. Go into phpMyAdmin query tab and run the following query to delete pending members:

DELETE FROM exp_members WHERE group_id = 'PENDING GROUP ID'

You can also run the query right from the control panel:

Admin › Utilities › SQL Manager › Database Query Form

If the site isn't setup to verify membership, you could run a query to delete all members after a certain date, specifically the day of spam and after:

DELETE FROM exp_members WHERE join_date > 'UNIXTIMESTAMP'

Use this tool to help figure out the unix timestamp. If you don't feel comfortable running the query at first, you could always run a SELECT query to confirm correct selection of members.

SELECT * FROM exp_members WHERE join_date > 'UNIXTIMESTAMP'
| improve this answer | |
  • Thanks Siebird! I ran the query on exp_members for group_id that all the spam registrations had. I also ran queries for a couple other things and it was a success. Thanks for pointing me in the right direction, I didn't have any previous experience running db queries. – Mike Lohrman May 14 '13 at 17:19
  • Awesome, glad you got it sorted! – Siebird May 14 '13 at 19:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.