WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)]
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 (234)
GROUP BY ID
the blog of DC Drinking Liberally
If you’re like me, you’re probably subscribed to John Kerry’s e-mail announcement list. Maybe you made a donation during the 2004 campaign, or maybe you just signed up to keep up to date on events. But if you’re like me (or like John in DC at Americablog), you’re also not exactly excited by the prospect of Kerry’s running in 2008, and you’re irritated by news articles that describe the list as “an online army of 3 million supporters”.
Well, Jonathan Zasloff at the Reality-Based Community has an idea: If you’re on the list but you don’t want Kerry to run in 2008, then unsubscribe. It’s easy — I just did it. At the bottom of each message you get, there’s a little “Click here to unsubscribe” link. Use it. If the word spreads, maybe we can stop hearing about Kerry’s huge base of online supporters.
By the way, the Reality-Based Community, at samefacts.com, is the site formerly known as Mark A.R. Kleiman (markarkleiman.com). Mark has had several other academics blogging with him for a while now, so they’re finally making the site less Kleiman-focused. Looks like they’re still working a few bugs out of the new setup, but it remains a source of great posts and one of the blogs I visit daily.
WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)]
SELECT * FROM wp_comments WHERE comment_post_ID = '234' AND comment_approved = '1' ORDER BY comment_date
Subscribe to an announcement list (or more than one) so you’ll always know what’s going on:
WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)]
SELECT * FROM wp_comments LEFT JOIN wp_posts ON wp_posts.ID=wp_comments.comment_post_ID WHERE (post_status = 'publish' OR post_status = 'static') AND comment_approved= '1' AND post_password = '' AND comment_type = '' ORDER BY comment_date DESC LIMIT 10
39 queries. 0.636 seconds