[JamieLee2k]

Database error in vBulletin 3.6.4:

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,27)

ORDER BY post.dateline;

MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054
Date : Sunday, January 28th 2007 @ 01:39:19 PM
Script : http://www.xleagues.net/forum/vbsupp...wthread&tid=19
Referrer : http://www.xleagues.net/forum/vbsupport.php
IP Address : xx.xx.xx.xx
Username : JamieLee2k
Classname : vb_database

This was fine before and now something changed it