WordPress.org

Forums

WHAT THE HELL!!! HELP!!! (15 posts)

  1. justinshattuck
    Member
    Posted 8 years ago #

    Alright, so this morning I go to log into my blog and my wordpress is giving thousands of errors! I haven't changed anything,

    visit http://www.justinshattuck.com

    any suggestions, help etc will be great!

  2. Chris_K
    Member
    Posted 8 years ago #

    And here I was, wondering that I hadn't seen any "worst title of the day" candidates for the last few days. ;-)

    In your errors, see this? errno: 145 That's a techy way of saying Not a WordPress issue.

    That's a MySQL error. If you have phpMyAdmin, you might try repairing your tables. Or you might contact your host directly and let them know your database is unhappy.

  3. justinshattuck
    Member
    Posted 8 years ago #

    For some reason, when I load phpmyadmin and check out the database, I get this for js_posts table

    SQL query: Edit
    SHOW KEYS FROM
    js_posts ;
    MySQL said: Documentation
    #1016 - Can't open file: 'js_posts.MYI' (errno: 145)

  4. justinshattuck
    Member
    Posted 8 years ago #

    I realize its not a wordpress issue, but I was pretty sure someone has experienced this issue and might have a cause and possibly a solution. I manage my own server -- for the most part, never had an issue like this.

  5. Chris_K
    Member
    Posted 8 years ago #

    Did you try the repair table option?

  6. OperaManiac
    Member
    Posted 8 years ago #

    repairing the database is most likely going to solve the problem for ya.

  7. justinshattuck
    Member
    Posted 8 years ago #

    Well I ran a myisamchk -r js_posts.MYI

    and it appeared to have done something.. it changed the error to
    WordPress database error: [Can't open file: 'js_posts.MYI' (errno: 13)]

    What is the correct way to "repair" the database?

  8. Chris_K
    Member
    Posted 8 years ago #

    maybe a quick search or post here? http://forums.mysql.com/

  9. justinshattuck
    Member
    Posted 8 years ago #

    I did a search and I'm seeing some results, trying everything still doesn't appear to be helping, Handy do you know.. if so, I mean if you know an easy fix or exact command could you tell me?

  10. justinshattuck
    Member
    Posted 8 years ago #

    I've ran myisamchk --safe-recover myisamchk -r the check sequence, repairs etc.. don't seem to be getting anywhere..

  11. OperaManiac
    Member
    Posted 8 years ago #

    go to phpmyadmin.

    select the database.

    select all the tables.

    choose the option which says repair. do an optimize after that.

  12. Chris_K
    Member
    Posted 8 years ago #

    This is offered with no guarantees or warranty :P

    Last time I had this happen, I just fired up phpMyAdmin, selected the DB then selected the table. Clicked on the "Operations" tab and somewhere towards the bottom was "Repair Table."

    That fixed me.

  13. justinshattuck
    Member
    Posted 8 years ago #

    I did as you mentioned and I get this Can't open file: 'js_posts.MYI' (errno: 13)

    It says OK next to every other table.. this is nuts

  14. justinshattuck
    Member
    Posted 8 years ago #

    I feel retarded, I backed up the table js_posts.MYI as root and copied it over, forgot to chown, chgrp back to mysql..

    Fixed, thanks guys! Appreciate it.

  15. Chris_K
    Member
    Posted 8 years ago #

    Lol! Glad you got it going -- and thanks for letting us know what the "root cause" was (ok, bad pun).

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags