Help, spam killed my members site
This is an open discussion with 4 replies, filed under General.
Search
I would go into the database to find the record(s) that are causing the error. Some quick SQL surgery should leave it up and running.
Typing this query should put up a list of the records that are causing the error:
select e.id, count(ed.id) from symentries AS e join symentriesdata10 as ed on e.id = ed.entry_id group by e.id having count(ed.id) > 1;
Hope this helps.
EDIT: Don't know how to preserve the underscores in the table names.
That worked like a charm. Thanks so much! Anyone got any tips of what they do to keep SPAM at bay on registration forms? I guess I could hack the event to use a honeypot...
I've used honeypots in the past to great success :)
Good call. I implemented it last night and haven't gotten a drop of spam yet... =)
Create an account or sign in to comment.
I have had a members site running for awhile now. It's still on 2.2.5. I haven't been working on it quite as much lately, but the SPAM bots have been registering roughly every 15 minutes or so.
For awhile, I would go in every week or so and just delete a ton of the unactivated members out of the system. However, since I haven't been doing that I'm at around 4,000 currently.
The site is still humming along fine on the front-end, but after I log in, the Members section (within the Symphony admin) fails to load.
Can anyone give me any clue of how to troubleshoot this? Heres the error I'm getting on the members page: