Hi,
I've just encoutered this error with one of my table :
mysql> SELECT * FROM inscrit;
ERROR 1030: Got error 127 from table handler
mysql> SELECT COUNT(*) FROM inscrit;
+----------+
| COUNT(*) |
+----------+
| 30856 |
+----------+
1 row in set (0.00 sec)
REPAIR TABLE doesn't see any error, myisamchk -o hasn't any effect...
I transfered the inscrit.* database file on my other server with the previous
MySQL 4.0.0 source compiled, and there is no more error with SELECT * FROM
inscrit...
I uploaded the table in /pub/mysql/secret/inscri.tar.gz
Regards,
Jocelyn Fournier
Presence-PC