Bug mysql error

[saifo]

hi

There is a solution for this problem?


Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT
pointslog.*,
user.*
, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb

FROM dbtech_vbactivity_pointslog AS pointslog
LEFT JOIN user AS user ON (user.userid = pointslog.userid)

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

WHERE
user.dbtech_vbactivity_excluded_tmp = '0'
ORDER BY dateline DESC
LIMIT 0, 20;

MySQL Error : Incorrect key file for table '/tmp/#sql_4bcc_0.MYI'; try to repair it
Error Number : 126
Request Date : Sunday, July 22nd 2012 @ 06:41:49 PM
Error Date : Sunday, July 22nd 2012 @ 06:42:00 PM
Script : http://www.domain.net/vb/vbactivity.php?do=activity
Referrer : http://www.domain.net/vb/vbactivity.php?do=leaderboards
IP Address : 452.357.162.2
Username : user
Classname : vB_Database
MySQL Version : 5.1.63-cll

 

[Fillip H.]

Please run the Repair / Optimize Tables tool in vBulletin AdminCP under the Maintenance group

If that doesn't work, you'll need to contact your host. This is a database-level error, nothing to do with vBActivity in and of itself.