WordPress database error: [Can't open file: 'wp_comments.MYD'. (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 (84,83) GROUP BY ID

Curioso! » 2006 » March

Archive for March, 2006

Move songs between iTunes libraries

Thursday, March 9th, 2006

I could not find an easy way to move songs from one iTunes library to another. After some searching and trial and error, I settled on the following.
Read the rest of this entry »

Posted in Mac, Hacks |

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 84 AND comment_approved = '1';

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '84' AND comment_approved = '1'

No Comments »

Switching between several iTunes libraries

Thursday, March 9th, 2006

I wanted to distribute my mp3 collection over several drives, which is not well supported by iTunes. The article Switch between two iTunes Libraries describes an approach how to set this up, but this is a bit too complicated. Here is my approach.
Read the rest of this entry »

Posted in Mac, Hacks |

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 83 AND comment_approved = '1';

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '83' AND comment_approved = '1'

No Comments »