Support » Fixing WordPress » Error Number 14

  • 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?

Viewing 4 replies - 1 through 4 (of 4 total)
  • This is a MySQL error, so tell your sysadmin to run a repair on the table asap.

    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

    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)

    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.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Error Number 14’ is closed to new replies.