.: ShaolinTiger - Kung-Fu Geekery :.

Mine did, really it sucks!

Anyway if yours did too, you can get rid of all the spam in a few seconds, go to your control panel or however you get to phpMyAdmin on your server (or command line MySQL interface), whichever you are comfortable with and run this SQL statement:


DELETE FROM `cpgXXX_comments`
WHERE
msg_body LIKE '%cialis%'
OR msg_body LIKE '%viagra%'
OR msg_body LIKE '%tinyurl%'
OR msg_body LIKE '%og-seote%'
OR msg_body LIKE '%custom-tshirts%'


cpgXXX will be whatever your table prefix is for coppermine, depending on when you installed it, mine is cpg131_

You will also have to adjust the words for example OR msg_body LIKE '%custom-tshirts%' can be changed to OR msg_body LIKE '%YOUR_SPAMWORD%' you can just keep adding OR statements on following lines according to any of the words that uniquely identify the spam comments.

I mean don't go deleting everything with 'the' in it for example.

Yah spammers are using tinyurl to spam their dirty generic viagra pills too, abusing a free service.

I hope it doesn't effect legitimate users.