Announcement

Collapse
No announcement yet.

Error on View Banned Users

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

  • Error on View Banned Users

    HTML Code:
    Database error in vBulletin 3.5.3:
    
    Invalid SQL:
    
            SELECT user.userid, user.username, user.usergroupid AS busergroupid,
            userban.usergroupid AS ousergroupid,
            IF(userban.displaygroupid = 0, userban.usergroupid, userban.displaygroupid) AS odisplaygroupid,
            bandate, liftdate, reason,
            adminuser.userid AS adminid, adminuser.username AS adminname
            FROM user AS user
            LEFT JOIN userban AS userban ON(userban.userid = user.userid)
            LEFT JOIN user AS adminuser ON(adminuser.userid = userban.adminid)
            WHERE user.usergroupid IN(11)
            ORDER BY userban.liftdate ASC, user.username;
    
    MySQL Error  : Column: 'reason' in field list is ambiguous
    Error Number : 1052
    Date         : Monday, January 16th 2006 @ 11:25:16 PM
    Script       : http://www.fnk.ca/board/modcp/banning.php?do=modify
    Referrer     : http://www.fnk.ca/board/admincp/index.php?do=nav
    IP Address   : 24.85.94.216
    Username     : sNyx™
    Classname    : vb_database
    MSN: [email protected] | MAIL: [email protected] | FOLIO: mholman.com

  • #2
    another

    HTML Code:
    MySQL Error  : Column: 'reason' in field list is ambiguous
    Error Number : 1052
    Date         : Monday, January 16th 2006 @ 11:28:30 PM
    Script       : http://www.fnk.ca/board/modcp/banning.php
    Referrer     : http://www.fnk.ca/board/modcp/banning.php
    IP Address   : 24.86.13.74
    Username     : MC Hammered
    Classname    : vb_database
    MSN: [email protected] | MAIL: [email protected] | FOLIO: mholman.com

    Comment


    • #3
      This error means that you have installed a hack or plugin that modified the database and created an extra 'reason' field that conflicts with the default vB database. You need to find out which mod is responsible for this and remove it.
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment


      • #4
        okay I axed a pair of unused rason tables, now I get this
        HTML Code:
        MySQL Error  : Unknown column 'reason' in 'field list'
        Error Number : 1054
        Where aboots would I be looking for the field list, my search keeps loading blank for me
        MSN: [email protected] | MAIL: [email protected] | FOLIO: mholman.com

        Comment


        • #5
          You've made modifications to the php file ./root/modcp/banning.php, you should remove the modifications or upload a unmodified version of the file.

          Comment


          • #6
            I have fresh copies of all vbulletin files, I don't understand what could be the issue. I have checked my db many times.
            MSN: [email protected] | MAIL: [email protected] | FOLIO: mholman.com

            Comment


            • #7
              Please reread post #3. One of your hacks modified the db to cause this problem. You need to find out which hack this is and remove the changes it made.

              As per post #4 it looks like you may have removed a valid 'reason' field. You should not have removed any reason field you find. Only remove the one added by your hack.
              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
              Change CKEditor Colors to Match Style (for 4.1.4 and above)

              Steve Machol Photography


              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


              Comment


              • #8
                hunting down hacks made to my db from vb 2x & vb3.0 would be near impossible. also I only removed one reason feild, the rest I restored.
                MSN: [email protected] | MAIL: [email protected] | FOLIO: mholman.com

                Comment


                • #9
                  You'll need to do some more hunting. This error is either from a hack still installed in your vB files, or from a missing 'reason' field that should be there. If you had provided the complete error I could tell you more.
                  Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                  Change CKEditor Colors to Match Style (for 4.1.4 and above)

                  Steve Machol Photography


                  Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                  Comment

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