11th Feb 2005
A Movable Type MySQL hint
I’m getting set to launch my WordPress blog, but in the meantime, I keep getting comment spam here (which, at this writing moment, means Movable Type.. but this entry will show up in WP later). A quick google search of “mysql mt_entry entry_allow_comments” lead me to this entry by Rogers Cadenhead. If you are comfortable with the MySQL CLI, then this statement will turn off all comments for posts older than a week (you back up your MT db, ya?). Usual disclaimers apply.
UPDATE mt_entry
SET entry_allow_comments = 2,entry_allow_pings = 0
WHERE entry_created_on < date_add(curdate(), interval -7 day);
It’s pretty likely that I will reopen all of my entries to comment once I am on WordPress. It’s just that dealing with comment spam in MT is like being pecked to death by parakeets.
I’m getting set to launch my WordPress blog, but in the meantime, I keep getting comment spam here (which, at this writing moment, means Movable Type.. but this entry will show up in WP later). A quick google search of “mysql mt_entry entry_allow_comments” lead me to this entry by Rogers Cadenhead. If you are comfortable with the MySQL CLI, then this statement will turn off all comments for posts older than a week (you back up your MT db, ya?). Usual disclaimers apply.
UPDATE mt_entry
SET entry_allow_comments = 2,entry_allow_pings = 0
WHERE entry_created_on < date_add(curdate(), interval -7 day);
It’s pretty likely that I will reopen all of my entries to comment once I am on WordPress. It’s just that dealing with comment spam in MT is like being pecked to death by parakeets.
Posted in WebTech | Comments Off

