Forum Subject: Another unexplained database error:

Posted on: 04/22/04 08:50am
By: jnordquist

SHOW KEYS FROM `gl_userstats`

MySQL said:


#1016 - Can't open file: 'gl_userstats.MYI'. (errno: 144)

---------
Any clues?

Another unexplained database error:

Posted on: 04/22/04 01:54pm
By: r_f_o_t

Try some of the links here[*1] . From these, it seems you need to repair the database.

HTH,

Chuck

Another unexplained database error:

Posted on: 04/22/04 03:35pm
By: jnordquist

I did the repair when I first noticed it. That's the easy part. I just can't figure out how that happens, and it happens about 1 or 2 times every couple months.

If I don't check the site for a few days that can be real bad. In this instance, I got a call from someone who said they've been getting an SQL error for two days. Doh!

Another unexplained database error:

Posted on: 04/22/04 04:20pm
By: r_f_o_t

[QUOTE BY= jnordquist] I did the repair when I first noticed it. That's the easy part. I just can't figure out how that happens, and it happens about 1 or 2 times every couple months.[/QUOTE]

Maybe a hardware issue? Failing hd? Wish I could be of help. Good luck with it.

Chuck