Announcement

Collapse
No announcement yet.

SQL Bug

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL Bug

    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
    -->

  • #2
    member2.php is not a standard vBulletin file.

    Do you also get this error on a standard vB page?
    Want to take your board beyond the standard vBulletin features?
    Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

    Comment


    • #3
      Yes, sorry, member2 is just a copy of member

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

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X