WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT ID, COUNT( comment_ID ) AS ccount
FROM wp_str8_posts
LEFT JOIN wp_str8_comments ON ( comment_post_ID = ID AND comment_approved = '1')
WHERE post_status = 'publish' AND ID IN (756)
GROUP BY ID
I modified MovableType to allow you to subscribe to comment threads; just click the box to be notified of future comments and you’ll get an email when someone posts another comment on the item. I wrote this because I often lose track of discussions I’m in on other weblogs, and MT really needs this completely obvious feature to be available. Assuming it works ok I’ll post diffs and instructions here.
WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT * FROM wp_str8_comments WHERE comment_post_ID = '756' AND comment_approved = '1' ORDER BY comment_date