WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 145)]
SELECT ID, COUNT( comment_ID ) AS ccount
FROM wp_posts
LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1')
WHERE ID IN (935)
GROUP BY ID
WordPress database error: [Can't open file: 'wp_secureimage.MYI' (errno: 145)]
DELETE from wp_secureimage WHERE img_datetime < '2008-10-12 19:21:14'
I just spent half an hour deleting a particularly annoying flood of comment spam… dozens upon dozens of faked comments… forthwith, all comments will now be moderated. I’ll still have to delete them, I think, but at least the bastards won’t get the benefit of a boost in Google from them. Maybe it will even discourage this.
WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 145)]
SELECT * FROM wp_comments WHERE comment_post_ID = '935' AND comment_approved = '1' ORDER BY comment_date