Announcement

Collapse
No announcement yet.

Database error in vBulletin 3.7.0 Beta 5: invalid sql

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

  • Database error in vBulletin 3.7.0 Beta 5: invalid sql

    hello,
    I hope someone can help out. I'm getting a db error whenever I try to update someone's admin permissions.

    any ideas? I have no idea about how to fix such things.




    Database error in vBulletin 3.7.0 Beta 5:

    Invalid SQL:
    UPDATE administrator SET
    ### Bitfield: administrator.adminpermissions ###
    adminpermissions = IF(adminpermissions & 4, adminpermissions, adminpermissions + 4),
    adminpermissions = IF(adminpermissions & 8, adminpermissions, adminpermissions + 8),
    adminpermissions = IF(adminpermissions & 16, adminpermissions, adminpermissions + 16),
    adminpermissions = IF(adminpermissions & 32, adminpermissions, adminpermissions + 32),
    adminpermissions = IF(adminpermissions & 64, adminpermissions, adminpermissions + 64),
    adminpermissions = IF(adminpermissions & 128, adminpermissions, adminpermissions + 128),
    adminpermissions = IF(adminpermissions & 256, adminpermissions, adminpermissions + 256),
    adminpermissions = IF(adminpermissions & 512, adminpermissions, adminpermissions + 512),
    adminpermissions = IF(adminpermissions & 1024, adminpermissions, adminpermissions + 1024),
    adminpermissions = IF(adminpermissions & 2048, adminpermissions, adminpermissions + 2048),
    adminpermissions = IF(adminpermissions & 4096, adminpermissions, adminpermissions + 4096),
    adminpermissions = IF(adminpermissions & 8192, adminpermissions, adminpermissions + 8192),
    adminpermissions = IF(adminpermissions & 16384, adminpermissions, adminpermissions + 16384),
    adminpermissions = IF(adminpermissions & 65536, adminpermissions, adminpermissions + 65536),
    ### Bitfield: administrator.vbgadminperms ###
    vbgadminperms = IF(vbgadminperms & 1, vbgadminperms, vbgadminperms + 1),
    ### Bitfield: administrator.garsadminperms ###
    garsadminperms = IF(garsadminperms & 1, garsadminperms, garsadminperms + 1),
    cssprefs = '',
    dismissednews = ''
    WHERE userid = 86;

    MySQL Error : Unknown column 'vbgadminperms' in 'field list'
    Error Number : 1054
    Date : Tuesday, March 11th 2008 @ 11:20:31 PM
    Script : http://www.unrealaddicts.com/forums/....php?do=update
    Referrer : http://www.unrealaddicts.com/forums/...p?do=edit&u=86
    IP Address : *****************
    Username :
    Classname : vB_Database
    MySQL Version : 4.1.22-standard-log

  • #2
    There is no 'vbgadminperms' field in the default vB database. This is from an add-on you installed. You will need to either remove the ad-on that is calling for that field, or ask for help over at www.vbulletin.org.
    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


    • #3
      thanks

      umm...
      you don't happen to know what add-on vbga would be would you do you? I'll ask at vb org anyway...but figure no harm in askin.

      Comment

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