Can’t open file: ‘wp_posts.MYI’ (errno: 145)?

  • I’m running 1.5.2. I just did a post and now I’m getting this error all over the place.

    WordPress database error: [Can’t open file: ‘wp_posts.MYI’ (errno: 145)]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND ID = 60 AND post_date_gmt <= ‘2006-05-16 16:45:59’ AND (post_status != “static”) GROUP BY wp_posts.ID ORDER BY post_date DESC

    What does this mean and what can I do to resolve it?

    -Dave

Viewing 6 replies - 1 through 6 (of 6 total)

  • If it’s not your server, try contacting the server admin. It’s possible the database went wonky and locked your posts table. Otherwise, try restarting MySQL.

    Definitely a mysql error – contact your host.

    If using CPANEL, go to MySQL databases, select your WordPress database, click “check.” Below is the result I received when I clicked “check” for the same error as you describe (I have ###’d out my actual database name). Clicking “Repair” fixed it. I’m not sure how this happened but will upgrade (I was nervous about doing so dreading some similar situation as came about without):

    Checking MySQL Database
    ### is now being checked.

    ###.wp_categories
    warning : 2 clients are using or haven’t closed the table properly
    status : OK
    ####_comments
    warning : 3 clients are using or haven’t closed the table properly
    status : OK
    ####_linkcategories OK
    ####_links OK
    ###_options OK
    ###_post2cat
    warning : 2 clients are using or haven’t closed the table properly
    status : OK
    ###_postmeta OK
    ###_posts
    warning : Table is marked as crashed
    warning : 4 clients are using or haven’t closed the table properly
    error : Found 167 keys of 168
    error : Corrupt
    ###_users
    warning : 1 client is using or hasn’t closed the table properly
    status : OK

    So basically to put it in a NUTSHELL this issue can happen at any time. its not your fault as the BLOGGER

    Its someone at your host who messed it up

    SOlution is. Go into Cpanel Go to DAtabase click on CHECK then click on REPAIR

    that will fix it! Worked for me

    Wow, this just happened on my main content site and it was pretty scary since I depend on it for close to a thousand dollars a month in revenue.

    Good thing WordPress support archives are always here when I need them. ??

    rustyellis

    (@rustyellis)

    You guys just completely saved my life with this post!!! Glad I started here for the fix. I almost started messing with my backups and trying to figure out what to do to upload them (I am in no way a database person).

    Thank you again!!!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Can’t open file: ‘wp_posts.MYI’ (errno: 145)?’ is closed to new replies.