vBulletin Avatar display issue
PostPosted: 12 Oct 2013, 16:38
With avatar display turned on, avatars do not show. When I right-click on the broken avatar to open the image in a new window, I get this SQL error:
Invalid SQL:
SELECT user.*, avatar.avatarpath, customavatar.dateline AS avatardateline, customavatar.width AS avatarwidth, customavatar.height AS avatarheight,
NOT ISNULL(customavatar.userid) AS hascustomavatar, usertextfield.signature,
customprofilepic.width AS profilepicwidth, customprofilepic.height AS profilepicheight,
customprofilepic.dateline AS profilepicdateline, usergroup.adminpermissions,
NOT ISNULL(customprofilepic.userid) AS hasprofilepic,
NOT ISNULL(sigpic.userid) AS hassigpic,
sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
sigpic.userid AS profilepic, sigpic.dateline AS sigpicdateline,
usercsscache.cachedcss
FROM user AS user
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN customprofilepic AS customprofilepic ON(customprofilepic.userid = user.userid)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid)
LEFT JOIN usercsscache AS usercsscache ON (user.userid = usercsscache.userid)
WHERE user.userid = '2';
MySQL Error : Table 'chb212_forum2.usercsscache' doesn't exist
Error Number : 1146
Invalid SQL:
SELECT user.*, avatar.avatarpath, customavatar.dateline AS avatardateline, customavatar.width AS avatarwidth, customavatar.height AS avatarheight,
NOT ISNULL(customavatar.userid) AS hascustomavatar, usertextfield.signature,
customprofilepic.width AS profilepicwidth, customprofilepic.height AS profilepicheight,
customprofilepic.dateline AS profilepicdateline, usergroup.adminpermissions,
NOT ISNULL(customprofilepic.userid) AS hasprofilepic,
NOT ISNULL(sigpic.userid) AS hassigpic,
sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
sigpic.userid AS profilepic, sigpic.dateline AS sigpicdateline,
usercsscache.cachedcss
FROM user AS user
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN customprofilepic AS customprofilepic ON(customprofilepic.userid = user.userid)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid)
LEFT JOIN usercsscache AS usercsscache ON (user.userid = usercsscache.userid)
WHERE user.userid = '2';
MySQL Error : Table 'chb212_forum2.usercsscache' doesn't exist
Error Number : 1146