yaskevic
07-12-2010, 04:45 PM
When I try to send a community newsletter, I see the below error. Please help me. Thanks in advance.
Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT user.userid, user.username, user.avatarrevision, user.joindate ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width_thumb AS avwidth,customavatar.height_thumb AS avheight
FROM user AS user
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
ORDER BY user.joindate DESC
LIMIT 10;
MySQL Error : Unknown column 'customavatar.width_thumb' in 'field list'
Error Number : 1054
Date : Monday, July 12th 2010 @ 12:23:26 PM
Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT user.userid, user.username, user.avatarrevision, user.joindate ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width_thumb AS avwidth,customavatar.height_thumb AS avheight
FROM user AS user
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
ORDER BY user.joindate DESC
LIMIT 10;
MySQL Error : Unknown column 'customavatar.width_thumb' in 'field list'
Error Number : 1054
Date : Monday, July 12th 2010 @ 12:23:26 PM