Database error when changing settings in Usergroup Manager

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • d0cpaul
    Member
    • Jul 2009
    • 32
    • 3.8.x

    Database error when changing settings in Usergroup Manager

    OK,

    I'm getting a database error every time I try to save a setting in ANY of the user groups.. Any ideas why this might be happening?

    Here is the error message I'm getting...

    Code:
    Database error in vBulletin 3.8.4:
    
    Invalid SQL:
    UPDATE vbusergroup SET
    
    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Registered Users',
        `description` = '',
        `usertitle` = '',
        `opentag` = '',
        `closetag` = '',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `forumpermissions` = '12317183',
        `genericpermissions` = '1579685575',
        `attachlimit` = '0',
        `pmquota` = '50',
        `pmpermissions` = '3',
        `pmsendmax` = '5',
        `pmthrottlequantity` = '0',
        `calendarpermissions` = '63',
        `wolpermissions` = '1',
        `adminpermissions` = '0',
        `genericpermissions2` = '1',
        `genericoptions` = '62',
        `profilepicmaxwidth` = '100',
        `profilepicmaxheight` = '100',
        `profilepicmaxsize` = '65535',
        `avatarmaxwidth` = '80',
        `avatarmaxheight` = '80',
        `avatarmaxsize` = '20000',
        `signaturepermissions` = '137215',
        `sigpicmaxwidth` = '500',
        `sigpicmaxheight` = '100',
        `sigpicmaxsize` = '10000',
        `sigmaxrawchars` = '1000',
        `sigmaxchars` = '500',
        `sigmaxlines` = '0',
        `sigmaxsizebbcode` = '7',
        `sigmaximages` = '4',
        `albumpermissions` = '255',
        `albumpicmaxwidth` = '600',
        `albumpicmaxheight` = '600',
        `albumpicmaxsize` = '100000',
        `albummaxpics` = '100',
        `albummaxsize` = '0',
        `usercsspermissions` = '63',
        `visitormessagepermissions` = '63',
        `socialgrouppermissions` = '51063',
        `maximumsocialgroups` = '5',
        `groupiconmaxsize` = '65535',
        `trgpermissions` = '0',
        `uscpermissions` = '0',
        `videodirectorypermissions` = '0',
        `radiotvpermissions` = '0'
    WHERE usergroupid=2;
    
    MySQL Error   : Unknown column 'uscpermissions' in 'field list'
    Error Number  : 1054
  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24175
    • 5.7.X

    #2
    As far as I'm aware, there's no field called uscpermissions in the default usergroup table which suggests this is from a plugin.
    Vote for:

    - Admin Settable Paid Subscription Reminder Timeframe (vB6)
    - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    😀
    😂
    🥰
    😘
    🤢
    😎
    😞
    😡
    👍
    👎