Log in

No account? Create an account
23 August 2007 @ 11:53 am
So the comments spam on my cemurphy.net galleries have gotten utterly out of control (mostly because I tend to forget about them). I don't *really* want to delete all comments, because there are a handful of useful ones identifying people and things (and I'm not sure it can be done anyway), but I also haven't got the time to slog through literally thousands of comments and delete most of them. I can't figure out how to make the Gallery blacklist thing work, which would obviously help, but, well. Not smart enough, or not dedicated enough, more like.

Anybody (where 'anybody' can be one person or several) want to deal with this for me? I will provide signed editions of books, name a character after you, buy you a beer, whatever, and also love you forever!

(By the way, whitewashing this here fence is real fun!)


ETA: I think I have enough of a Team Whack-A-Mole to take care of the problem now. Thanks! :)
Current Mood: hopefulhopeful
(Deleted comment)
kitmizkit on August 23rd, 2007 12:44 pm (UTC)
Whack whack! Yeah, a bit of whacking here and there would be great. It's too much to do all at once, but help would make my life so much nicer! Email me? cemurphyauthor@gmail.com. :)
namemr_cornelius on August 23rd, 2007 12:14 pm (UTC)

Looking at the gallery, it looks like you are using gallery v1 - in which case this link might be of value to you (although I don't know how technical you want to get - I can help out there if you need):


Also, it looks as if the latest safe version (1.5.7) has spam control tools - which means that it might be worth doing an upgrade.

Btw - love the pictures!
kitmizkit on August 23rd, 2007 12:43 pm (UTC)
Actually, that's sort of weird, as it was literally just upgraded to 1.5.7 this morning. Which will hopefully make a difference in the future, but it's not all that helpful (unless your link there is, I haven't looked at it yet) for getting rid of spam that's there. :)

*looks at your link* Way beyond what I'm willing to/capable of doing. :)
namemr_cornelius on August 23rd, 2007 01:25 pm (UTC)
Heh, I totally understand :)

So, it looks like you have a few options:

1. The upgrade. It does have spam control tools - but I don't know if that includes what is currently there. If it did, your problem is solved (doubt it does).

2. The sql database clean-up. It would only take a short while to fix everything. The biggest issue is that its getting into the guts of the database - which means you will need someone technical, and you will need to give them access to the database - which means you should also trust them as well as you will have to give them passwords, etc. (Also, standard precautions will need to be taken - including backing up the data already present in case of accident, etc (I am fairly confident that the code in that link will work, but it always pays to back up data before doing anything))

3. Grunt work. Give someone/give a handful of people admin access to the gallery, and let them go in and remove the spam comments individually. Its a safe and slow approach, with the side-effect of making people bleed from the eyes when they are into their third hour.

I hope you get it cleaned up okay. Let me know if you need any help with it, or if you want any more info, etc.

irishkate: soapboxirishkate on August 23rd, 2007 12:56 pm (UTC)
Will mole whack for whatever..
annathepiper on August 23rd, 2007 02:10 pm (UTC)
I could probably whack a few moles for you. :)
Sunfeet: I SLEEP NOW!dreamstrifer on August 23rd, 2007 02:18 pm (UTC)
will delete comments for allergy medicine.

SEriously. nothing better to do since i can't go to work (well, I suppose i could write, but where's the fun in that?)
kitmizkit on August 23rd, 2007 04:21 pm (UTC)
I emailed your lj address as I'm not sure what else to use, but if you didn't get an email from me, let me know! :)
Sunfeetdreamstrifer on August 23rd, 2007 05:05 pm (UTC)
tIt just sends it to my duskdragon47 @ yahoo addy, so I got it. :-)
Geek of Weird Shit: vengeancegows on August 23rd, 2007 02:38 pm (UTC)
I'll help! Team Whack-A-Mole to the rescue! :)
irishkate: bouncyirishkate on August 23rd, 2007 03:22 pm (UTC)
hmm - do we all get Team Whack-A-Mole superhero names?
dqg_nealdqg_neal on August 23rd, 2007 03:49 pm (UTC)
be careful.. we don't want a superhero trilogy to derail her carefully planned deadlines. :)

Geek of Weird Shitgows on August 23rd, 2007 04:01 pm (UTC)
Ah, she can just slip the name "Team Whack-A-Mole" somewhere into Chance. *grin*
(Anonymous) on August 24th, 2007 04:45 am (UTC)
I know absolutely nothing about live journals and such so I can not help with your spam problem. But I love me a game of Whak-A-Mole so count me in!! :) HEEHEE

xnamkradxnamkrad on August 24th, 2007 07:56 am (UTC)
I've some time on my hands, if I can help out, let me know.