Big Problem

[RichM]

It says:
Database error in vBulletin 2.3.0:

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

mysql error number: 1016

Date: Sunday 18th of May 2003 08:06:16 PM
Script:
Referer:

Why is this?

[Cary]

You've got a corrupted table. Run the following query in phpMyAdmin:

REPAIR TABLE thread;

If you don't have phpMyAdmin upload repair.php from your 'extras' folder in the vBulletin zip file then run it.

[RichM]

This is what it says when i try to do that in phpmyadmin, i do not understand repair.php either.

Can't open file: 'thread.MYI'. (errno: 145)

Error

SQL-query :

SHOW FIELDS FROM `thread` FROM `hf_habboforum`

MySQL said:


Can't open file: 'thread.MYI'. (errno: 145)
Back

[RichM]

http://www.habboforum.com/repair.php Makes no sense at all, i have restarted MySQL on the server, still no luck.

[Cary]

Is the problem fixed now? I just ran repair.php for you...

[RichM]

It is ok now. Thanks for giving me the idea.

[Floris]

In phpmyadmin, you can check the checkbox in front of the corrupt table, below all the tables is a drop down box, select optimize there and then repair when it is done.
Make sure you have first closed your forum down when you play with optimize and repair.