PDA

View Full Version : 1016


express
Fri 9th May '03, 8:04pm
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
Fri 9th May '03, 8:35pm
Run this query in phpMyAdmin:

REPAIR TABLE user;

express
Fri 9th May '03, 8:38pm
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
Fri 9th May '03, 8:42pm
The problem is with 4.0.12, not vB. Many PHP/MySQL apps are affected by this.