Filed under Blogging
I've been getting an increasing amount of trackback spam on my blog. I've never really used the trackback feature, so I disabled it with all my new posts.
All my old posts were still enabled for trackbacks. This setting is per entry, not for the entire blog. The only way to turn it off was to go to each old entry, clear the "Accept Trackbacks" checkbox, and click "Save." This process takes *forever* (probably about 1 minute per entry). Considering I had almost 200 hundred posts that needed updating, I decided to just live with the spam I was getting (about one message a day).
Today I found a quick way to turn all the "Accept Trackbacks" off. My blog is stored as an SQL database. All I had to do was use my website's SQL administration page and enter this SQL command:
update mt_entry set entry_allow_pings = 0
After I did this, I rebuilt my blog (regenerated all the web pages) and now I don't have any pages that accept Trackbacks!
I had an SQL course in college. I never expected to use it because databases were not that interesting to me. But back then, nobody used SQL for personal projects, like blogs. Suddenly, I'm interested in learning more about SQL.
Goodbye Trackback Spam!