WordPress.org

Ready to get started?Download WordPress

Forums

Database error: [Got error 28 from table handler] (6 posts)

  1. maisy
    Member
    Posted 9 years ago #

    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

  2. NuclearMoose
    Member
    Posted 9 years ago #

  3. maisy
    Member
    Posted 9 years ago #

    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

  4. nchenga
    Member
    Posted 9 years ago #

    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

  5. alexasigno
    Member
    Posted 8 years ago #

    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

  6. Mark (podz)
    Support Maven
    Posted 8 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags