WordPress database error: [Can’t open file: ‘wp_comments.MYD’. (errno: 144)]

  • Resolved fmckinnon

    (@fmckinnon)


    18 years, 3 months ago

    Hey Ya’ll –

    I’m not sure when it happened, but regardless of which “theme” I’m using, I’m getting the following error in the headers of each page. Any help on resolving this? I have access to mySQL database and phpMyAdmin, so I can get to the database if necessary.

    As a matter of fact, I’ve just logged in, and when I attempted to browse the wp_comments table, I get:
    SQL query: Edit

    SHOW KEYS FROM wp_comments ;

    MySQL said: Documentation
    #1016 – Can’t open file: ‘wp_comments.MYD’. (errno: 144)

    Any help would be appreciated!
    FRED MCKINNON
    https://www.fredmckinnon.com/myblog/

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

  • Let your host know, they might be able to help…

    Thread Starter fmckinnon

    (@fmckinnon)

    Yosemite –
    I *AM* the host, LOL.

    Then you’re fscked!

    Seriously, something got corrupt. A repair attempt may have already been done, but you could try it manually.

    Or, restore your backup.

    To be very clear: This is a MySQL issue.

    mmm. Shoulda said:

    Seriously, something got corrupt. A [MySQL] repair attempt may have already been done, but you could try it manually.

    that should be just a corrupt table, use phpmyadin, go in repair it, or if you want to use the shell (since youre the host)

    mysql> REPAIR TABLE wp_comments;

    Thread Starter fmckinnon

    (@fmckinnon)

    aaah – logged into phpmyadmin and did: REPAIR TABLE wp_comments;

    Worked like a charm – phew!

    Hey Fred and all contributors… you saved the day. I had the same problem and fixed it right away. Thanks.

    Keilya

    (@fantasycrusader)

    Thanks for the heads up on this one! I was wondering what on earth happened. =S Scared the hell outta me.

    Man! It happened to me too. I wonder why it hits wp_comments? Possibly related to comment spammers abusing the scripts, but this likely points to a WP-bug.

    Just happened to one of the blogs under my care too, the repair table fixed it. Version 2.0.5

    But what happens if “repair” is not possible.

    I got this error after pushing a backupfile into the DB. Repair the table brougt the next error. The DB wasnt able to create a temp-DB. So I saw that I simply forgot to chmod the DB-Folder to 777.

    Now its working fine

    Good luck

    P.S. Yes, germans are to stupid to learn english ??

    Does anyone have any advice for the technically challenged who are facing this error and have know idea what phpmyadmin is or how to use it? pretty please? ??

    lararose.com/blog

    @ LaraRose
    click on my username and then the contact tab at top of my test blog. I’ll lead you through it.

    It is interesting that’s always the wp_comments table that gets corrupted. Maybe it’s the most added-to table what with all the spammers. I saw a suggestion that this sort of corruption usually occurs because of an out-of-disk-space condition. This is probably what caused it for me recently.

    Interesting: if you google for “Can’t open file: wp_comments.MYD”, the top item is this page. The other 11,000+ items are links to broken WordPress installations.

Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘WordPress database error: [Can’t open file: ‘wp_comments.MYD’. (errno: 144)]’ is closed to new replies.