The secure CMS.

Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 09:48 am EST

Geeklog Forums

Another unexplained database error:

 New Topic  Post Reply
 04/22/04 08:50am (Read 1,610 times)  
Status: offline

jnordquist

Forum User
Full Member
Registered: 03/14/03
Posts: 129
Location:Kenosha
SHOW KEYS FROM `gl_userstats`

MySQL said:


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

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

John Nordquist,
Applications Specialist, medical Technologies
 Quote
 04/22/04 01:54pm  
Status: offline

r_f_o_t

Forum User
Full Member
Registered: 07/30/03
Posts: 241
Location:Illinois
Try some of the links here. From these, it seems you need to repair the database.

HTH,

Chuck
Too many hands on my time.
 Quote
 04/22/04 03:35pm  
Status: offline

jnordquist

Forum User
Full Member
Registered: 03/14/03
Posts: 129
Location:Kenosha
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!
John Nordquist,
Applications Specialist, medical Technologies
 Quote
 04/22/04 04:20pm  
Status: offline

r_f_o_t

Forum User
Full Member
Registered: 07/30/03
Posts: 241
Location:Illinois
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.


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

Chuck
Too many hands on my time.
 Quote
 New Topic  Post Reply
All times are EST. The time is now 09:48 am.
  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content