Page 1 of 1

vBulletin Avatar display issue

PostPosted: 12 Oct 2013, 16:38
by conradb212
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

PostPosted: 25 Oct 2013, 07:00
by conradb212
Any chance I could get an opinion as to what might be wrong? I just got an email saying my tech support time will soon expire, and I'd like to get this avatar problem resolved.

Topic Closed

PostPosted: 16 Dec 2014, 00:26
by Staff Bot
[b]This thread has been locked because the last post is greater than six months old. There is a good chance that the information in this thread is outdated. Please open a new topic if you wish to discuss this further.[/b]