mySQL query error

[NJEyeGuy]

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]

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]

Wow, that was a fast reply!!!! Thanks so much for your help.:D
Dean

[HalfaBee]

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]

That fixed it HalfaBee!!!! Thank you sooooooooooooo much;)
Dean