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.
yeah, i’ve tried to remove the spam url using SQL command in phpMyAdmin interface, works like a charm. Thanks ShaolinTiger
I need to castrate spammers
I love the way SQL commands sound like deranged teenagers:
“Delete that thing from that place where the other thing is, like, this, or OMG, like that too.”
Wah, why you guys so canggih wan ah?
mypapit: No problems, glad to help 🙂
KY: Spammers am teh suck indeed.
Sashi: Always loved SQL, it’s like shouting orders, and it actually makes sense for once..
Maybe do you like try this plugins to block spam in coppermine gallery:
https://forum.coppermine-gallery.net/index.php/topic,50081.0.html
Greetings :-D.