SYMPTOMS
You see errors at random and not all the tables in your database seem to be available, you might see test similar to the following in places:-
Invalid query_last: Duplicate entry
[MySQL][ODBC 3.51 Driver][mysqld-4.0.12-nt]Can't open file: 'vtp_members.MYI'. (errno: 145)
CAUSE
A database table has been damaged or corrupted.
SOLUTION
1. There are two possible solutions. First go BCP/System Optimiser and set "Run table repairs" to Yes then click the Run button.
This can take some time, especially if you have a busy site so please wait until the screen says it is safe to continue.
2. If the above does not work you need to run a repair on just the table that has the problem, this is done by login into your phpMyAdmin, and then selecting the damaged table by placing a check mark against it and choosing Repair from the dropdown list (see image below).
Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)