1016

[express]

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1482'
mysql error: Can't open file: 'user.MYI'. (errno: 145)

mysql error number: 1016

Date: Friday 09th of May 2003 06:51:23 PM



Any ideas

[Steve Machol]

Run this query in phpMyAdmin:

REPAIR TABLE user;

[express]

We have been running repair for 2 weeks .
MySql 4.0.12 We finally had all the table corruption we could stand. We have been reading these forums for over 2 weeks making all the changes that were suggested. Finally we have given up and downgraded to version 3.23.56 .
Does anyone know when we might get a stable release out for version 4.0.12?

[Steve Machol]

The problem is with 4.0.12, not vB. Many PHP/MySQL apps are affected by this.