PDA

View Full Version : mySQL query error


NJEyeGuy
4-13-03, 07:22 AM
Hey everyone, I sure could use a little help here. My message board has been running fine for the last few months, but last night I started getting this error message:

mySQL query error: SELECT COUNT(tid) as max FROM ibf_topics WHERE forum_id='3' and approved='1' and (last_post > 1047636807 or pinned=1)

mySQL error: Can't open file: 'ibf_topics.MYI'. (errno: 145)
mySQL error code: 1016
Date: Sunday 13th of April 2003 03:13:27 AM

Before I start tearing into it and trying to fix something that may not be broken, I would appreciate it if anyone could tell me if it's a hosting problem or if it's something on my end that I will need to fix myself. BTW, I'm using the Invision Power Board version 1.1

Thanks to all,
Dean

HalfaBee
4-13-03, 07:33 AM
You need to repair the table.

If you have mysql-front try the tools->table-diagnostic functions.

Other wise run this query using some mysql client.

REPAIR TABLE ibf_topics

HalfaBee

NJEyeGuy
4-13-03, 07:38 AM
Wow, that was a fast reply!!!! Thanks so much for your help.:D
Dean

HalfaBee
4-13-03, 07:39 AM
Not a problem :)

This question keeps popping up pretty ofen.
I think I may have to make a canned respose for it soon.

HalfaBee

NJEyeGuy
4-13-03, 07:42 AM
That fixed it HalfaBee!!!! Thank you sooooooooooooo much;)
Dean