WordPress database error: [Got error 28 from table handler]
SELECT DISTINCT ID, category_id, cat_name, category_nicename, category_description, category_parent FROM wp_str8_categories, wp_str8_post2cat, wp_str8_posts WHERE category_id = cat_ID AND post_id = ID AND post_id IN (5436)

WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_str8_posts LEFT JOIN wp_str8_comments ON ( comment_post_ID = ID AND comment_approved = '1') WHERE post_status = 'publish' AND ID IN (5436) GROUP BY ID

STR8BLOGGIN » Blog Archive » Problems with MySQL data-dir on Ubuntu 10.04?

Problems with MySQL data-dir on Ubuntu 10.04?

If you are having trouble modifying your MySQL configuration under Ubuntu (primarily, MySQL hangs/doesn’t start), the problem is apparmor. Do “service apparmor stop” and then “chmod -x /etc/init.d/apparmor”; restart MySQL and it should work.

The problem is that AppArmor tries to limit the folders that MySQL can access, and therefore when you change the data-dir in mysql.conf, mysqld_safe cannot properly start.

WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT * FROM wp_str8_comments WHERE comment_post_ID = '5436' AND comment_approved = '1' ORDER BY comment_date

Leave a Reply