SQL Bug

[mxtabs]

Yes, sorry, member2 is just a copy of member

http://www.musicianforums.com/forums...r.php?u=201148

[Marco van Herwaarden]

member2.php is not a standard vBulletin file.

Do you also get this error on a standard vB page?

[mxtabs]

3.6.1

<!--
Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, level, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON (user.reputationlevelid = reputationlevel.reputationlevelid) 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 (user.userid = customprofilepic.userid)

WHERE user.userid = 201148;

MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054
Date : Friday, September 15th 2006 @ 12:15:00 PM
Script : http://www.musicianforums.com/forums...2.php?u=201148
Referrer : http://www.sputnikmusic.com/profile.php?memberid=201148
IP Address : 128.84.27.15
Username : Unregistered
Classname : vB_Database
-->