August 10, 2005

Closing Trackbacks

Okay, I have a little SQL query that will close all trackbacks on all entries (on one blog or all of them) older than a given date.

What should that date be? I've just done my blog for anything older than last month, which seems reasonable.

Update: Done the same for Munuviana.

Posted by Pixy Misa at August 10, 2005 03:42 AM | TrackBack
Comments
#1

I close comments after two weeks, I think it is, and haven't been comment-spammed since. I'd love to do the same for trackbacks.

Posted by Jennifer at August 10, 2005 05:09 AM
#2

I can do your blog for you, no problem.

Then I need to set up a little program to keep doing it, once a week or something.

Posted by Pixy Misa at August 10, 2005 06:52 AM
#3

I'd like one month please.

Pixy, I'm getting flooded with 60k spam emails all along the "Password violation", "Online violation" etc. lines. Anyway to deflect it? I keep deleting as they come in, but they're overwhelming me.

Posted by Simon at August 10, 2005 11:58 AM
#4

Yay! Have I mentioned lately how you're the best, Pixy?

Posted by Jennifer at August 10, 2005 04:44 PM
#5

Simon - Turn on Spam Assassin in CPanel. It works. I'd be dead without it. And I HATE that password violation spam. (I do tech support for an ISP, among the many hats I wear at work. If you think you're getting flooded...)

Posted by Pixy Misa at August 10, 2005 05:50 PM
#6

I've been closing mine monthly as well. So far I'm not overwhelmed, but it's good to know these 2 alternatives are out there if things get out of hand.

Pixy, thanks for all your hard work!

Posted by Michele at August 10, 2005 09:04 PM
#7

Whatever is the easiest thing for YOU... thank you for your hospitality and all your hard work!

Posted by Madfish Willie at August 10, 2005 10:49 PM
#8

I like the month threshold. I'm getting very little comment-wise but the trackback spam seems to be on the uptake.

Posted by Jim at August 11, 2005 12:23 AM
#9

As a rule, I close trackbacks and comments to any post that gets any form of spam.

Spam me once shame on you. Spam me twice shame on me. So far its manageable.

Posted by Stephen Macklin at August 11, 2005 01:14 AM
#10

Thanks Pixy. I checked and already have Spam Assassin/Spam box enabled. It just seems this latest flood got through the net. I just re-enabled it, so we'll see if that helps.

Thanks again on the trackback closing. Very much appreciated.

Posted by Simon at August 11, 2005 01:46 AM
#11

Yay! All Hail Pixy, the Munuvian Overlord of Spam blockers!

Thank you again Pixy for all your hard work!

Posted by michele at August 11, 2005 02:34 AM
#12

Can my trackbacks be closed, too, pretty please? I still get trackback spam and it makes me crazy. One month is fine-I close comments after 7 days.

Posted by Helen at August 11, 2005 01:40 PM
#13

I close comments automatically after 60 days. Since I added that, I haven't gotten any comment spam at all, but of course I still get tons of trackback spam. I'd like to close trackbacks automatically after 60 days too, but I'd be fine with after 30 days, if that's easier for you.

How hard would it be to write a program to read a config file and close everybody's trackbacks according to their wishes? I'm sure that if I knew Linux/Server stuff better I could do it in minutes (I just signed up at eApps, I'm on the steep part of the learning curve at the moment, but that kind of stuff is not on my need-to-know list... yet).

Posted by David Boxenhorn at August 11, 2005 02:13 PM
#14

Not too hard. The SQL statement is easy enough, so I just need to set up a little program to fire them off one after the other.

Posted by Pixy Misa at August 11, 2005 02:23 PM
#15

Helen, unless I did something wrong, trackbacks should be closed on all posts older than 1st July this year.

...

Okay, I did something wrong. Let me try again.

Posted by Pixy Misa at August 11, 2005 02:33 PM
#16

Ah, no, it worked. Anything that was last modified before the first of July has had trackbacks closed.

Posted by Pixy Misa at August 11, 2005 02:36 PM
#17

I'd like to close off trackbacks as well, please. I wouldn't mind closing off comments except that one post I did on Welsh rap has turned into a fascinating bulletin board for the Welsh rap community. Who knew?

Posted by RP at August 11, 2005 02:49 PM
#18

I just discovered that I suffered a trackback 'Pearl Harbor' during the night. Something like 20 or so trackbacks to some gambling place.

The interesting part is that I think that closing of trackbacks is being felt NOW in the spamming world - all 20 or so trackbacks were on the posts currently up over at my place....nothing past August 4th or so.

Posted by Mad Mikey at August 11, 2005 05:54 PM
#19

(Sorry for the multiple comments here)

Pixy - where exactly on CPanel is the 'Spam Assassin'?? I've looked but I'm not seeing it.

I'm thinking to ask it now as I too am starting to get spam addressed to 'madmikey1@madmikey.....' which is impossible since I only use 'madmikey1' on my old Hotmail account.

Your Humble Munuvian,
Mike

Posted by Mad Mikey at August 11, 2005 05:58 PM
#20

Pixy, I don't know if you did it for my site yesterday but I was hit with a small flood of trackback spam again last night, some on posts going back 6 months or more.

Just letting you know.

Posted by Simon at August 12, 2005 01:10 AM
#21

Yeah, I got some too.

I think you might actually need to rebuild your blog before it works.

Posted by Pixy Misa at August 12, 2005 02:48 AM
#22

I'm rebuilding everything right now, so will let you know.

Posted by Simon at August 12, 2005 04:12 AM
#23

OK so here's something curious. Most of the trackback spam has been blocked, but I just got a couple for old posts. When I went back to those posts in MT, it has the Pings box unchecked and has no record of the ping. Mystery trackbacks?

Also Pixy do you mind doing both Showcase and Memeblog too please. 1 month for each is fine.

Posted by Simon at August 16, 2005 10:47 AM
Live Comment Preview
Post a comment









Remember personal info?