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: deleting thousends of spam comments at once?  (Read 7638 times)

0 Members and 1 Guest are viewing this topic.

Fking

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 37
deleting thousends of spam comments at once?
« on: March 17, 2007, 05:49:08 pm »

I had a problem with those spam bots
And before i know (and turned off posting for non-registered users) i already had thousends of spam comments (i was getting few hundred per day!!)
I guess there wont be good way to filter just the spammy ones, so is there a way to delete all the comments for a specific time frame at once?
Cause currently i have to check them one by one and click delete, which will take weeks to do manual :)

thanks!
« Last Edit: April 23, 2007, 07:36:06 am by GauGau »
Logged

Nibbler

  • Guest
Re: deleting thousends of spam comments at once?
« Reply #1 on: March 17, 2007, 06:55:43 pm »

You can delete them from the database using phpmyadmin.
Logged

Fking

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 37
Re: deleting thousends of spam comments at once?
« Reply #2 on: March 17, 2007, 07:37:38 pm »

You can delete them from the database using phpmyadmin.

well any directions about the table name i should be looking for?
Logged

Nibbler

  • Guest
Re: deleting thousends of spam comments at once?
« Reply #3 on: March 17, 2007, 08:10:43 pm »

It's called comments. You can't miss it.
Logged

Fking

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 37
Re: deleting thousends of spam comments at once?
« Reply #4 on: March 17, 2007, 11:25:12 pm »

thanks i found it
but even with phpmyadmin i have to check them one by one
i need something like select all function, after i've showed the records for the last weeks on one page

or some mysql query dropping the records for specific time range
Logged

JohnM-UK

  • Guest
Re: deleting thousends of spam comments at once?
« Reply #5 on: March 18, 2007, 12:37:20 am »

I use this:
http://forum.coppermine-gallery.net/index.php?topic=36235.0
On my photoblog:
http://www.oneuk.f2s.com/photos/displayimage.php?album=lastup&cat=0&pos=0

Users have to enter a code to allow posting of an image. I have had 0 spam since installing it.

Logged

Fking

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 37
Re: deleting thousends of spam comments at once?
« Reply #6 on: March 18, 2007, 12:32:41 pm »

I use this:
http://forum.coppermine-gallery.net/index.php?topic=36235.0
On my photoblog:
http://www.oneuk.f2s.com/photos/displayimage.php?album=lastup&cat=0&pos=0

Users have to enter a code to allow posting of an image. I have had 0 spam since installing it.



as i mentioned, i've handled the spam bots, but i have to deal with the spam comments from before that :)
Logged

Nibbler

  • Guest
Re: deleting thousends of spam comments at once?
« Reply #7 on: March 18, 2007, 12:43:04 pm »

Come up with a sql query that identifies the comments you want to delete, maybe by content or date.
Logged

macleem

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: deleting thousends of spam comments at once?
« Reply #8 on: April 20, 2007, 09:00:42 pm »

This is exactly the same problem i had. i've since removed the feature to post comments all together. but i have over 2,000 spam comments and all from various names/addresses. I am sadly unfamiliar with using any sql commands. is it possible to just reupload the .php file that pertains to the comment section or the DB..or would uploading the database remove the images as well?

Here is my forum - http://fastbreaknyunltd.com/jboogie_gallery/util.php
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: deleting thousends of spam comments at once?
« Reply #9 on: April 21, 2007, 10:28:37 am »

Comments are not being stored in a file, but in a table within your database. If you're not familiar enough with phpMyAdmin to come up with a query to delete the unwanted comments, then emptying the entire comments table might be an option for you (note: you'll lose all comments ever posted).
Logged

macleem

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: deleting thousends of spam comments at once?
« Reply #10 on: April 21, 2007, 05:48:51 pm »

Comments are not being stored in a file, but in a table within your database. If you're not familiar enough with phpMyAdmin to come up with a query to delete the unwanted comments, then emptying the entire comments table might be an option for you (note: you'll lose all comments ever posted).

That is fine with me. I never wanted comments on the gallery but I forgot to disable that option. Is there a tutorial on using phpmyadmin on the forum?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: deleting thousends of spam comments at once?
« Reply #11 on: April 22, 2007, 01:31:00 pm »

No, but phpMyAdmin comes with loads of documentation. From our point of view, phpMyAdmin is a third party app that we don't support, simply because it's off-scope. Just emtpy coppermine's comments table. To do so, start phpMyAdmin, choose the database you have coppermine installed in (if you have more than one database), then click on the comments table in the left frame, then click on "empty" in the top right frame (do not delete the table, but just empty it!).
Logged

macleem

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: deleting thousends of spam comments at once?
« Reply #12 on: April 22, 2007, 02:55:15 pm »

thank you soooooo much. i just found the phpmyadmin app and emptied the comment table. i had over 40,000 spam comments. whew imagine if i had to do them all at once... once again thank you very much
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: deleting thousends of spam comments at once?
« Reply #13 on: April 23, 2007, 07:36:44 am »

Marking as "solved", locking.
Logged
Pages: [1]   Go Up
 

Page created in 0.024 seconds with 20 queries.