[webgroup]

I got this error today, any help fixing it will be appreciated:

Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT user.*,usertextfield.*,userfield.*, user.userid, options, fbuser.fbuid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

,avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight

, IF((options & 512 AND user.userid <> 0), 0, lastactivity) AS lastvisittime



FROM vbnewuser AS user
LEFT JOIN vbnewfbuser AS fbuser ON(user.userid = fbuser.userid)
LEFT JOIN vbnewusertextfield AS usertextfield ON(usertextfield.userid=user.userid)
LEFT JOIN vbnewuserfield AS userfield ON(userfield.userid=user.userid)

LEFT JOIN vbnewavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vbnewcustomavatar AS customavatar ON(customavatar.userid = user.userid)



WHERE 1=1
AND (user.usergroupid IN (-1,6,26,18,23,25,7,22,2,20,5,21))

ORDER BY user.username asc
LIMIT 138100, 100;

MySQL Error : Incorrect key file for table '/tmp/#sql_2e8e_1.MYI'; try to repair it
Error Number : 126
Request Date : Saturday, June 13th 2009 @ 12:12:45 AM
Error Date : Saturday, June 13th 2009 @ 12:13:03 AM