Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: HUGE Spam Problem  (Read 2870 times)

0 Members and 1 Guest are viewing this topic.

sapphiire

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
HUGE Spam Problem
« on: August 24, 2008, 01:29:25 am »

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.
Logged

Gizmo

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 1015
    • BullsEye Photos
Re: HUGE Spam Problem
« Reply #1 on: August 24, 2008, 04:07:26 am »

Do a search for "captcha" to help prevent robots from leaving SPAM all over your gallery.
Logged
Did you read the manual first???? Taking 2 minutes to backup your files can save you hours of wondering what you screwed up.
Billy Bullock - BullsEyePhotos Blog of Indecision

apanda

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: HUGE Spam Problem
« Reply #2 on: September 02, 2008, 03:27:14 am »

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
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: HUGE Spam Problem
« Reply #3 on: September 02, 2008, 06:44:23 am »

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.
Logged

McKenzie

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 129
    • My car gallery
Re: HUGE Spam Problem
« Reply #4 on: September 02, 2008, 12:40:37 pm »

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)
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: HUGE Spam Problem
« Reply #5 on: September 03, 2008, 09:15:17 am »

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.
Logged

McKenzie

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 129
    • My car gallery
Re: HUGE Spam Problem
« Reply #6 on: September 03, 2008, 01:55:37 pm »

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

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: HUGE Spam Problem
« Reply #7 on: September 03, 2008, 04:29:19 pm »

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

McKenzie

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 129
    • My car gallery
Re: HUGE Spam Problem
« Reply #8 on: September 03, 2008, 05:28:37 pm »

'It blogs bad Roberts' must be 'It blocks bad robots'  ;D
Logged
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 20 queries.