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 (106)
GROUP BY ID
You can force your website to be accessed through a canonical hostname by forcing a redirect from other hostnames in .htaccess or httpd.conf:
RewriteEngine on
RewriteCond %{HTTP_HOST} !^canonical\.host\.name [NC]
RewriteCond %{HTTP_HOST} !^$
RewriteRule ^/(.*)$ http://canonical.host.name/$1 [C,L,R=301]
RewriteRule ^$ http://canonical.host.name/ [L,R=301]
WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT * FROM wp_comments WHERE comment_post_ID = '106' AND comment_approved = '1' ORDER BY comment_date