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 (96,95,94,93,92) GROUP BY ID

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

Archive for April, 2011

Snapfish Not Giving Much Away

Thursday, April 26th, 2011

I had an email offer from Snapfish yesterday. Snapfish is the new name for what used to be HP Photo.
They enticed me to read the email by giving it the title “Free mug from Snapfish” or something similar.
It didn’t take me long to junk it though. In order to receive your free mug you had […]

WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 96 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 = '96' AND comment_approved = '1'

No Comments »

The Power of Forum Signatures

Wednesday, April 18th, 2011

I’ve heard it said that forum signatures are weak and worthless links to pursue by other SEO’s.
While this might have some grain of truth in pagerank terms, it couldn’t be further from the truth in simple referral traffic.
If you participate in a busy forum, closely related to the subject of your website then a signature […]

WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 95 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 = '95' AND comment_approved = '1'

No Comments »

All the Ins and Outs of Link Baiting

Friday, April 13th, 2011

I read this brilliant article this morning on the ins and outs of link baiting.
For those not so deeply immersed in SEO, link baiting is the process of offering content, products or services that makes people link to your website in a viral marketing fashion.

WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 94 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 = '94' AND comment_approved = '1'

No Comments »

Paypal Alternative for UK Vendors

Friday, April 13th, 2011

If you’re selling online and not heavily involved enough in it to get a merchant account with all it’s cost and risk, you’re probably using the big gun Paypal or perhaps Nochex to process payments.
It seems now that Google want a foothold in this market too and Google Checkout has launched in the UK.
It would […]

WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 93 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 = '93' AND comment_approved = '1'

No Comments »

New Baby

Monday, April 2nd, 2011

It’s been pretty quiet here on this blog recently and part of the reason is that my wife made me a Dad, again, a couple of weeks ago. Everyone is healthy and all is well, but it has kept me off the radar for a while so if I’ve missed an email from anyone, please […]

WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 92 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 = '92' AND comment_approved = '1'

No Comments »