Code:
Database error in vBulletin 3.8.3:
Invalid SQL:
SELECT SQL_CALC_FOUND_ROWS
visitormessage.*, user.*, visitormessage.ipaddress AS messageipaddress
,IF(userlist.userid IS NOT NULL, 1, 0) AS bbuser_iscontact_of_user
,deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom
FROM visitormessage AS visitormessage
LEFT JOIN user AS user ON (visitormessage.postuserid = user.userid)
LEFT JOIN userlist AS userlist ON (userlist.userid = user.userid AND userlist.type = 'buddy' AND userlist.relationid = 3)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN deletionlog AS deletionlog ON (visitormessage.vmid = deletionlog.primaryid AND deletionlog.type = 'visitormessage')
WHERE visitormessage.userid = 3
AND (visitormessage.state IN ('visible','moderation','deleted'))
ORDER BY visitormessage.dateline DESC
LIMIT 0, 10;
MySQL Error : Table 'deletionlog' is marked as crashed and should be repaired
Error Number : 1194
Request Date : Monday, March 1st 2010 @ 05:32:51 PM
Error Date : Monday, March 1st 2010 @ 05:32:51 PM
Script : http://www.virtualsportsnet.com/forum/member.php?u=3
Referrer : http://www.virtualsportsnet.com/forum/index.php
IP Address : 1**.**.19.103
Username : Rush
Classname : vB_Database
MySQL Version : 5.0.89-community