Announcement

Collapse
No announcement yet.

MySQL Database Error when updating usergroup?

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

  • MySQL Database Error when updating usergroup?

    Hi,

    I tried updating my Admin usergroup (in particular- the 'Username HTML Markup' field), and the following error is displayed when I hit "Update":

    Database error in vBulletin 3.8.7:

    Invalid SQL:
    UPDATE usergroup SET

    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Administrators',
    `description` = '',
    `usertitle` = 'Administrator',
    `opentag` = '<strong><span style=\"color: #ffff00;\">',
    `closetag` = '</span></strong>',
    `passwordexpires` = '180',
    `passwordhistory` = '360',
    `forumpermissions` = '16777215',
    `genericpermissions` = '2147483583',
    `attachlimit` = '0',
    `pmquota` = '50',
    `pmpermissions` = '7',
    `pmsendmax` = '5',
    `pmthrottlequantity` = '0',
    `calendarpermissions` = '63',
    `wolpermissions` = '31',
    `adminpermissions` = '3',
    `genericpermissions2` = '1',
    `genericoptions` = '55',
    `profilepicmaxwidth` = '100',
    `profilepicmaxheight` = '100',
    `profilepicmaxsize` = '65535',
    `avatarmaxwidth` = '80',
    `avatarmaxheight` = '80',
    `avatarmaxsize` = '20000',
    `signaturepermissions` = '237567',
    `sigpicmaxwidth` = '500',
    `sigpicmaxheight` = '100',
    `sigpicmaxsize` = '10000',
    `sigmaxrawchars` = '0',
    `sigmaxchars` = '0',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '7',
    `sigmaximages` = '0',
    `albumpermissions` = '255',
    `albumpicmaxwidth` = '600',
    `albumpicmaxheight` = '600',
    `albumpicmaxsize` = '100000',
    `albummaxpics` = '100',
    `albummaxsize` = '0',
    `usercsspermissions` = '63',
    `visitormessagepermissions` = '63',
    `socialgrouppermissions` = '65535',
    `maximumsocialgroups` = '5',
    `groupiconmaxsize` = '65535',
    `akvbghsfs_akismet_permissions` = '0'
    WHERE usergroupid=6;

    MySQL Error : Unknown column 'akvbghsfs_akismet_permissions' in 'field list'
    Error Number : 1054
    Request Date : Friday, April 25th 2014 @ 01:13:06 AM
    Error Date : Friday, April 25th 2014 @ 01:13:06 AM
    Script : http://domain.com/admincp/usergroup.php?do=update
    Referrer : http://domain.com/admincp/usergroup....&usergroupid=6
    IP Address : xx.xxx.xx.xxx
    Username : Trey
    Classname : vB_Database
    MySQL Version : 5.5.32-cll-lve

    Any idea? Thanks.

  • #2
    You are trying to update permissions from an addon. This addon was either improperly installed or improperly uninstalled. You'll need to remove the files from the addon and completely uninstall it to restore functionality.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment

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