After updating to MT 3.16, I still was unable to turn off Trackback Pings for all the old entries that had it turned on.
I really did not relish the thought of having to manually visit a hundred or so entries to disable Trackbacks, So I did a spot of Googling.. and found this rather helpful page. As you are unable to update all your entries from within MT – why not do it using SQL… What a great idea, I hadn’t thought of that – obvious really… So thats what I have done:
UPDATE mt_entry
SET entry_allow_pings = 0
WHERE entry_allow_pings = 1
Let’s hope this will stop those annoying Online Casinos from SPAMMING my website. It should also make my webstats a little more readable!!
Related posts:
Hey, thanks for the awesome idea. You just saved me hours (or days) worth of work.
I did modify the script a bit since I didn’t want to turn off all the trackbacks, just ones earlier than the first of the month.
The code I used is:
UPDATE mt_entry SET entry_allow_pings = 0 WHERE entry_allow_pings = 1 AND entry_created_on < ‘2005-07-01 00:00:37′
Thanks again for the great idea.