HUGE Spam Problem

[sapphiire]

My gallery has over 8,000 comments of spam. Yeah, seriously. I banned the IP address from the main robot, but I don't know how to make it so anonymous users cant comment, OR how to delete every single comment from my gallery. I have comments I wanna keep on there, but to sort out the 200 I wanna keep from the 8,000 thats spam would be pointless. So can anyone help me? Thanks.

[Gizmo]

Do a search for "captcha" to help prevent robots from leaving SPAM all over your gallery.

[apanda]

I had a similar problem, but on a smaller scale.  To solve it I used MySQL.  I put all the comments in order by date, and was then able to delete all the new ones, which happened to work for me because the spam ones were the new ones.  That probably won't work for you      But using MySQL will let you delete all the comments.

As for Capcha, I decided to wait for a version of Coppermine that has Capcha built in.

Andrew

[Joachim Müller]

Manually deleting all new records won't solve the issue, as new spam comments get added on a daily basis. That's why you need to make sure to get spammed less in the first place. The captcha plugin indeed won't clean your database records from existing spam comments - it will just reduce the number of new spam comments, that's all.

[McKenzie]

I have some problems with the captcha (not with the script), because there are often unrecognized elements on the captcha  (its hard for people who have bad eyes too).

And it can't help against picture/content grabber etc..

So you maybe should use:

http://code.google.com/p/cpg-dnsbl/ (I used that and get only one spam comment every three days)
http://www.bad-behavior.ioerror.us/ (English)
http://www.spider-trap.de/en_index.html (English/German)
http://www.bot-trap.de/home/ (German, very good)

[Joachim Müller]

Thanks for sharing those additional spam-protection technologies with us. However, they will get widely unnoticed, as they only exist as a reply to an "ordinary" support thread. If you want to contribute more and maybe even promote the tools you proposed I suggest to come up with a separate thread that contains a concise review of the plugins. This new thread could be made sticky then for the benefit of others with similar issues. Thanks in advance for your readiness to share.

[McKenzie]

Okay, but I found some spelling mistakes in my topic and can't edit it, so feel free to change/enter information

[Joachim Müller]

OK, will do. I made your new thread http://forum.coppermine-gallery.net/index.php/topic,54885.0.html a sticky one.

[McKenzie]

'It blogs bad Roberts' must be 'It blocks bad robots'