upgrade support error

[precharge]

Getting this error after upgrading with the support tickets (vbsupport). not sure if it's a bug with vbulletin or not.


Database error in vBulletin 3.6.1:

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 vbs_ticket_post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
WHERE post.postid IN (0,154)

ORDER BY post.dateline;

MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054

[Steve Machol]

This error means that you did not upload all the 3.6.1 files or you have an add-on that is asking for a field that does not exist in 3.6.1.

Reupload all the original vB 3.6.1 non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Then if you still have this problem, disable your plugins.