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 (107,106) GROUP BY ID

Curioso! » 2007 » April

Archive for April, 2007

iPhoto plugins

Thursday, April 12th, 2007

Useful plugins for use with iPhoto:

Posted in Mac, Info |

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

No Comments »

Canonical Hostname

Monday, April 2nd, 2007

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]

Posted in Apache |

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

No Comments »