Code:
Database error in vBulletin 3.6.0:
Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
level,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM vbvbs_ticket_post AS post
LEFT JOIN vbuser AS user ON(user.userid = post.userid)
LEFT JOIN vbuserfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN vbusertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN vbavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vbcustomavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN vbreputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
WHERE post.postid IN (0,2)
ORDER BY post.dateline;
MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054
Date : Sunday, August 20th 2006 @ 02:43:12 PM
Script : http://xxxxx.com/forums/vbsupport.php?do=viewthread&tid=2
Referrer : http://xxxxx.com/forums/vbsupport.php?do=newthread
IP Address : xxxxx
Username : xxxx
Classname : vB_Database
any idea's?