Help
General ArrowChat talk that doesn't fit any other forum.
User avatar
conradb212
Customer
 
Posts: 5
Joined: 29 Sep 2013, 08:22

 

by conradb212 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
User avatar
conradb212
Customer
 
Posts: 5
Joined: 29 Sep 2013, 08:22

 

by conradb212 25 Oct 2013, 07:00

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.
User avatar
Staff Bot
ArrowChat Team
 
Posts: 8996
Joined: 07 Nov 2012, 13:41

 

by Staff Bot 16 Dec 2014, 00:26

[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]