Just got this error from SQL database...

[robin_ge]

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT COUNT(*) AS threads FROM thread
mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016
-----------------------------------------

Anyone knows what this error means?
I have contacted the technical support and haven't got reply yet.

[HalfaBee]

You need to to "REPAIR TABLE thread" in phpmyadmin or mysql-front.
Mysql-front has tools->Table-Diagnostics have a go with these.

HalfaBee

[robin_ge]

Thanks a lot!! HalfaBee!! I just fixed it.
After the fixing the tables, there is one called "mydbsname.session" that is still can't be fixed. It says "The handler for the table doesn't support repair". Could you tell me how to fix this? Thank you!!

[HalfaBee]

That one is beyond me.
You may have to email support@powweb.com to get this fixed.

HalfaBee

[robin_ge]

Thank you all the same!

[robin_ge]

Hi! HalfaBee! Just got the reply from Technical Support and they said they don't give support to SQL users. Too bad.

I just checked the table property in MySQL-Front, I noticed that the type of the table I'm having trouble fixing is different from all other tables and it's "HEAP". But others are all "MyISAM". Do you think if this could be the problem? I'm thinking of changing its type to "MyISAM", do you think it is safe to do that? Thanks a lot!!

[HalfaBee]

I am not quite sure how HEAP tables work, but they basically look temporary.
It was probably done for speed reasons but I wouldn't be too worried about that.

HalfaBee

Mysql manual
HEAP Tables

HEAP tables use a hashed index and are stored in memory. This makes them very fast, but if MySQL crashes you will lose all data stored in them. HEAP is very useful for temporary tables!

The MySQL internal HEAP tables use 100% dynamic hashing without overflow areas. There is no extra space needed for free lists. HEAP tables also don't have problems with delete + inserts, which normally is common with hashed tables:

[robin_ge]

I see. Thanks again, HalfaBee!!