Announcement

Collapse
No announcement yet.

Cant save Usergroup settings after upgrade to vB3.7.0 RC2

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

  • Cant save Usergroup settings after upgrade to vB3.7.0 RC2

    Ive upgraded and in the process I got rid of some of the plug ins I had installed, one of them was the chat. Unfortunately even though it has been deleted the settings table is there at the bottom of the usergroup, even though it is blank, and when I save I get the following database error:

    Code:
    Database error in vBulletin 3.7.0 Release Candidate 2:
    
    Invalid SQL:
    UPDATE vbusergroup SET
    
    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Registered Users',
        `description` = '',
        `usertitle` = '',
        `opentag` = '',
        `closetag` = '',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `vbtube` = '0',
        `forumpermissions` = '3928575',
        `genericpermissions` = '1516770503',
        `attachlimit` = '0',
        `pmquota` = '50',
        `pmpermissions` = '3',
        `pmsendmax` = '5',
        `calendarpermissions` = '63',
        `wolpermissions` = '1',
        `adminpermissions` = '0',
        `genericpermissions2` = '1',
        `genericoptions` = '62',
        `profilepicmaxwidth` = '360',
        `profilepicmaxheight` = '560',
        `profilepicmaxsize` = '65535',
        `avatarmaxwidth` = '80',
        `avatarmaxheight` = '80',
        `avatarmaxsize` = '20000',
        `signaturepermissions` = '137215',
        `sigpicmaxwidth` = '500',
        `sigpicmaxheight` = '100',
        `sigpicmaxsize` = '2000',
        `sigmaxrawchars` = '1000',
        `sigmaxchars` = '500',
        `sigmaxlines` = '0',
        `sigmaxsizebbcode` = '7',
        `sigmaximages` = '4',
        `albumpermissions` = '255',
        `albumpicmaxwidth` = '600',
        `albumpicmaxheight` = '600',
        `albumpicmaxsize` = '100000',
        `albummaxpics` = '100',
        `albummaxsize` = '0',
        `usercsspermissions` = '31',
        `visitormessagepermissions` = '63',
        `socialgrouppermissions` = '375',
        `mgccustomusergroupperms` = '64',
        `nbmsgshowchatbox` = ''
    WHERE usergroupid=2;
    
    MySQL Error   : Unknown column 'mgccustomusergroupperms' in 'field list'
    Error Number  : 1054
    Date          : Friday, April 4th 2008 @ 12:17:50 PM
    Script        : http://www.**************.com/forums/admincp/usergroup.php?do=update
    Referrer      : http://www.**************.com/forums/admincp/usergroup.php?do=edit&usergroupid=2
    IP Address    : **************
    Username      : **************
    Classname     : vb_database
    MySQL Version : 4.1.22-standard

  • #2
    This is caused by a custom addon for additional permissions. You need to contact the author of that addon or delete its XML file from includes/XML.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment


    • #3
      Originally posted by Wayne Luke View Post
      or delete its XML file from includes/XML.
      Perfect thats all I wanted to know is how to get rid of it.

      Comment

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