deleting thousends of spam comments at once?

[Fking]

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!

[Nibbler]

You can delete them from the database using phpmyadmin.

[Fking]

You can delete them from the database using phpmyadmin.

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

[Nibbler]

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

[Fking]

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

[JohnM-UK]

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.

[Fking]

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

[Nibbler]

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

[macleem]

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

[Joachim Müller]

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

[macleem]

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?

[Joachim Müller]

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!).

[macleem]

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

[Joachim Müller]

Marking as "solved", locking.