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 (91,90,89) GROUP BY ID

2007 February :: Dave Smith’s SEO from England
  Dave Smith Home | Dave's SEO Services | About Dave Smith | Email me

Archive for February, 2011

Are You Writing For Your Users?

Wednesday, February 28th, 2011

Seems like a simple question, doesn’t it? Are you writing for your users? “Of course I am, that’s why I’ve got a website.”
The thing is, in a lot of cases website managers are producing content that is for anyone but their users. Here are a few examples:

The company brochure. The boss wants a website and […]

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

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

No Comments »

Virtuemart and Google Analytics Goals

Thursday, February 8th, 2011

If you are using the content management system Joomla, you might also be using the Virtuemart ecommerce plugin. I was looking for a way to integrate Google Analytics into Virtuemart so that I could specify a goal and track the number of converted sales.
For the most part you don’t need to worry about doing anything […]

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

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

No Comments »

Travis - Some vague memories

Wednesday, February 7th, 2011

This post might be slightly off topic, but I remembered about a band called Travis. Were around a lot a few years ago. Girls liked the singer. I had a reminder recently about a CD I bought called called 12 Memories. Great I thought, I’ll rip it onto my MP3 player so I can listen […]

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

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

No Comments »