WordPress.org

Support

Support » How-To and Troubleshooting » Database error: [Got error 28 from table handler]

Database error: [Got error 28 from table handler]

  • I get the following error where my links are display in word press user menu

    Database error: [Got error 28 from table handler]
    SELECT DISTINCT link_category, cat_name, show_images, show_description, show_rating, show_updated, sort_order, sort_desc, list_limit FROM wp_links LEFT JOIN wp_linkcategories ON (link_category = cat_id) WHERE link_visible = ‘Y’ AND list_limit <> 0 ORDER BY cat_name

    can anyone help
    thanks
    maisy
    x

Viewing 5 replies - 1 through 5 (of 5 total)
  • I did repair and now i get the following error

    Database error: [Can’t open file: ‘wp_links.MYI’. (errno: 144)]
    SELECT DISTINCT link_category, cat_name, show_images, show_description, show_rating, show_updated, sort_order, sort_desc, list_limit FROM wp_links LEFT JOIN wp_linkcategories ON (link_category = cat_id) WHERE link_visible = ‘Y’ AND list_limit <> 0 ORDER BY cat_name

    i get the same error message in WP 1.2.2

    tried repairing the MySQL db. No change.
    How can I fix this error?
    It’s the second time I’ve had this error.

    thanks for any suggestion,
    Sandra

    I get some nice long error message too, very similar infact, when
    i try to run the upgrade file; Any ideas please

    WordPress database error: [Can’t open file: ‘wp_options.MYI’. (errno: 144)]
    DESCRIBE wp_options;

    Warning: Invalid argument supplied for foreach() in /home/alexf40/public_html/alexasigno/wp-admin/upgrade-functions.php on line 530

    WordPress database error: [Can’t open file: ‘wp_options.MYI’. (errno: 144)]
    SHOW INDEX FROM wp_options;

    WordPress database error: [Can’t open file: ‘wp_options.MYI’. (errno: 144)]
    ALTER TABLE wp_options ADD COLUMN option_id bigint(20) NOT NULL auto_increment

    alexasigno – contact your host and tell them they need to repair mysql. You cannot do it from your side, they have to. Copy that message to them.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Database error: [Got error 28 from table handler]’ is closed to new replies.
Skip to toolbar