Out of the blue began receiving the following MySQL error:
Database error in vBulletin 4.1.10:
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
, user.dbtech_vbshop_purchase
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_5522_1.MYI'; try to repair it
Error Number : 126
Request Date : Tuesday, February 21st 2012 @ 10:28:39 PM
Error Date : Tuesday, February 21st 2012 @ 10:32:54 PM
Script : Activity Feed - TTNB
Referrer : Awards - TTNB
IP Address : xxxxxxxxxxxxx
Username : xxxxxxxxxx
Classname : vB_Database_MySQLi
I did a Repair/Optimize tables, found no errors, no crashed tables, etc...
I did a check table on dbtech_vbactivity_pointslog and there were no errors (ttnb_production.dbtech_vbactivity_pointslog check status OK)
Any assistance would be appreciated.
Database error in vBulletin 4.1.10:
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
, user.dbtech_vbshop_purchase
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_5522_1.MYI'; try to repair it
Error Number : 126
Request Date : Tuesday, February 21st 2012 @ 10:28:39 PM
Error Date : Tuesday, February 21st 2012 @ 10:32:54 PM
Script : Activity Feed - TTNB
Referrer : Awards - TTNB
IP Address : xxxxxxxxxxxxx
Username : xxxxxxxxxx
Classname : vB_Database_MySQLi
I did a Repair/Optimize tables, found no errors, no crashed tables, etc...
I did a check table on dbtech_vbactivity_pointslog and there were no errors (ttnb_production.dbtech_vbactivity_pointslog check status OK)
Any assistance would be appreciated.