WordPress.org

Ready to get started?Download WordPress

Forums

Error Number 14 (5 posts)

  1. ian2
    Member
    Posted 8 years ago #

    Hi I am getting this error when accessing my posts:

    ************

    WordPress database error: [Can't open file: 'wp_posts.MYI'. (errno: 144)]
    SELECT * FROM wp_posts WHERE 1=1 AND (post_status = "publish" OR post_author = 1 AND post_status != 'draft' AND post_status != 'static') AND post_status != "attachment" GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 15

    ************

    Anything I can do other than report it to my server manager?

  2. Matt Mullenweg
    Troublemaker
    Posted 8 years ago #

    This is a MySQL error, so tell your sysadmin to run a repair on the table asap.

  3. ian2
    Member
    Posted 8 years ago #

    Thanks Matt. I own the server and have root access. I did a repair and this is what I got:

    teen_wrdp1.wp_categories repair status OK
    teen_wrdp1.wp_comments repair status OK
    teen_wrdp1.wp_email_list repair status OK
    teen_wrdp1.wp_linkcategories repair status OK
    teen_wrdp1.wp_links repair status OK
    teen_wrdp1.wp_options repair status OK
    teen_wrdp1.wp_post2cat repair status OK
    teen_wrdp1.wp_postmeta repair status OK
    teen_wrdp1.wp_posts repair error 13 when fixing table
    teen_wrdp1.wp_posts repair error Can't copy datafile-header to tempfile, error 9
    teen_wrdp1.wp_posts repair status Operation failed
    teen_wrdp1.wp_snowfall repair status OK
    teen_wrdp1.wp_usermeta repair status OK
    teen_wrdp1.wp_users repair status OK

  4. ian2
    Member
    Posted 8 years ago #

    BTW: If this makes any difference, when I am looking at all of my databases at the home, it says wp_posts is "in use".

    And when I try to access it I Get this:

    SQL query: Edit

    SHOW KEYS FROM wp_posts ;

    MySQL said: Documentation
    #1016 - Can't open file: 'wp_posts.MYI'. (errno: 144)

  5. ian2
    Member
    Posted 8 years ago #

    Ok, my friend who knows MYSQL helped me and fixed it. For future reference I will note what he said was the problem and what he did:

    : The issues were 1 : mysql had crashed, and had taken mysql into journal editing mode - you'd need to use phpmyadmin to run repair on any tables that shows " in use "

    and 2) the server was stopped in appropriately.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags