deleting ALL comments at once

[LuthienMoss]

I have 5000 SPAM comments and I'd hate to have to delete them usng the cpanel, meaning I'd have to click 50 times ... Would it be possible, with a single click, delete them ALL?

[Nibbler]

Empty the comments table using phpmyadmin.

[LuthienMoss]

I already did it and ti doesnt seem to work. I logged into PHPMyAdmin, chose the "cpg143_comments" table, and cliked "EMPTY". However, when I return to the gallery, the comments are still there.

[Nibbler]

Make sure you are looking at the right database. Check by reading the name from include/config.inc.php.

[LuthienMoss]

Hmm ... I tried, but when I try to open the database I get this error

#1203 - User 'databasename' already has more than 'max_user_connections' active connections

What could this mean? 

[LuthienMoss]

I managed to access the database, and I did as instructed, but it didn't help. The thousands of spam comments are stil there, whilst phpMyAdmin tells me the database IS emptied (see attached). This is really confusing me  :-\

[LuthienMoss]

sorry to be posting again but now Im desperate. Last time I checked I had over 40 000 (forty thousand!!!) spam comments! I received a complaint from Google Adsense threatening to ban my account unless I changed my content (which was apparently adult content) I am assuming they are referring to all the nasty links the SPAM comments contain.  So I really really really need to get rid of the comments, and deleting all 40 000 manually isn't even an option, I'd take me way too long.

Please anyone?

[Joachim Müller]

Make sure that you're editing the right table. After emptying the comments table using phpMyAdmin, all comments should be gone. If this is not the case (you can easily check in coppermine's frontend), you have emptied the wrong table. Review.

[LuthienMoss]

Thanks for yoru reply!

I am pretty sure I have emptied the right table - if you take a look at my attachment, I've marked the table I've emptied (cpg143_comments). It also says "Rows: 0" and "Size: 1,0Kib". So it looks pretty empty to me, but, the SPAM comments are still there. This is really confusing me. Is there something wrong with my phpAdmin?

Someone else having the same problems?!

[Joachim Müller]

Edit include/config.inc.php with a plain text editor, find the line that starts with

Code Select Expand

$CONFIG['dbname'] =and the line that starts with

Code Select Expand

$CONFIG['TABLE_PREFIX'] =and post the full content of those two line here. Do not post the rest of the file!

[tuxsoul]

Hi, may be do like read about cpg-dnsbl (gpl project), to block spam, more info here:
http://forum.coppermine-gallery.net/index.php/topic,50081.new.html

Greeting's  .