Did Your Coppermine Gallery (CPG) Get Spammed? Eww Spam..

April 8th, 2006 by ShaolinTiger at 1:42 PM UTC - 5,179 views

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.

Tags: blog-spam, Comment-Spam, coppermine, coppermine-spam, cpg, how-to, message-spam, ShaolinTiger, spammers, spamming, technical, tinyurl, tinyurl-spam

Follow me on Twitter Subscribe to RSS

Posted in Internet & Tech | 6 comments -

Related Posts:
- “Yue May Not Mail Me Anymore”
- Xmas Eve Party – I was Sober..
- Pukers, Partiers and Perverts
- Combating Spam – Disable Trackbacks for Older Posts in WordPress
- DOTA Wallpaper
- Sun, Sand, Sea and Smiles…

6 Comments so far

mypapit on April 8th, 2006 at 7:12 pm
Using Mozilla Firefox 1.5.0.1 on Windows XP

yeah, i’ve tried to remove the spam url using SQL command in phpMyAdmin interface, works like a charm. Thanks ShaolinTiger
KY on April 9th, 2006 at 1:30 am
Using Mozilla Firefox 1.5.0.1 on Windows XP

I need to castrate spammers
Sashi on April 10th, 2006 at 9:19 am
Using Mozilla Firefox 1.5.0.1 on Windows XP

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."
Hijackqueen on April 10th, 2006 at 1:37 pm
Using Mozilla Firefox 1.0.6 on Windows ME

Wah, why you guys so canggih wan ah?
ShaolinTiger on April 12th, 2006 at 1:03 pm
Using Mozilla Firefox 1.5.0.1 on Windows XP

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..
tuxsoul on September 16th, 2008 at 7:57 pm
Using Galeon 2.0.2 on Debian GNU/Linux

Maybe do you like try this plugins to block spam in coppermine gallery:
http://forum.coppermine-gallery.net/index.php/topic,50081.0.html

Greetings .