Error in table handler? vb admin cp

[Kathy]

Just installed/replaced hard drive on my server. No VB database errors until I just tried to track my latest registrations that were "email confirmation needed" usergroup. (Email wasn't working for a while and I wanted to re-email them)

I got this error in the admin cp:

Warning: MySQL: Unable to save result set in /home/httpd/vhosts/hystersisters.com/httpdocs/vb2/admin/db_mysql.php on line 87

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: SELECT user.userid,username,usergroupid,birthday,specialevent,email,parentemail,coppauser,homepag e,icq,aim,yahoo,signature,usertitle,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastpost) AS lastpost,posts,ipaddress,userfield.* FROM user,userfield WHERE 1=1 AND usergroupid=3 AND joindate>UNIX_TIMESTAMP('2003-02-20') AND userfield.userid=user.userid ORDER BY username LIMIT 0,300
mysql error: Got error 134 from table handler

mysql error number: 1030

Date: Wednesday 05th of March 2003 10:32:42 AM
Script: http://www.hystersisters.com/vb2/vb2/admin/user.php
Referer: http://hystersisters.com/vb2/admin/u...tion=modify&s=

Any idea what we've missed that needs fixing?

Thanks!

[Steve Machol]

Error code 134: Record was already deleted (or record file crashed)

Run these queries in phpMyAdmin:

REPAIR TABLE user;
REPAIR TABLE userfield;

[Kathy]

Thank you Steve