Announcement

Collapse
No announcement yet.

SQL Bug

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

  • mxtabs
    replied
    Yes, sorry, member2 is just a copy of member

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

    Leave a comment:


  • Marco van Herwaarden
    replied
    member2.php is not a standard vBulletin file.

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

    Leave a comment:


  • mxtabs
    started a topic SQL Bug

    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
    -->
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X