Status
Not open for further replies.

Jem

Customer
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.
 
Thanks Fillip H.. It does look to be an issue with the server itself and not the mod. It just happened to be a DB script that was running at the time. So far everything looks good just by stopping mysqld and clearing out the tmp directory.
 
Status
Not open for further replies.

Legacy vBActivity & Awards

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
1,726
Customer rating
0.00 star(s) 0 ratings
Back
Top