WordPress.org

1. fmckinnon
   Member
   Posted 2 years 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
   www.fredmckinnon.com/myblog/

2. Yosemite
   Member
   Posted 2 years ago #

   Let your host know, they might be able to help...

3. fmckinnon
   Member
   Posted 2 years ago #

   Yosemite -
   I *AM* the host, LOL.

4. Yosemite
   Member
   Posted 2 years ago #

   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.

5. Chris_K
   Administrator
   Posted 2 years ago #

   To be very clear: This is a MySQL issue.

6. Yosemite
   Member
   Posted 2 years ago #

   mmm. Shoulda said:

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

7. whooami
   Member
   Posted 2 years ago #

   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;

8. fmckinnon
   Member
   Posted 2 years ago #

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

   Worked like a charm - phew!

9. chrismoncus
   Member
   Posted 2 years ago #

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

10. fantasycrusader
    Member
    Posted 2 years ago #

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

11. phord
    Member
    Posted 2 years ago #

    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.

12. bhyde
    Member
    Posted 2 years ago #

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

13. Abazza
    Member
    Posted 2 years ago #

    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 ;-)

14. LaraRose
    Member
    Posted 2 years ago #

    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

15. samboll
    Moderator
    Posted 2 years ago #

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

16. phord
    Member
    Posted 2 years ago #

    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.

Topic Closed

This topic has been closed to new replies.