Announcement

Collapse
No announcement yet.

Database error when making changes in Usergroup

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

  • [Forum] Database error when making changes in Usergroup

    I just finished to upgrade my board from 3.8.4 to vB 4 Suite.

    Before making the upgrade i did a database backup & full backup from Cpanel.

    I uninstalled all the mods

    Everything went fine, i even installed a new style and is working fine.

    But when i was changing the "Username HTML Markup" to change color, got this database error:

    Code:
    Database error in vBulletin 4.0.0:
    
    Invalid SQL:
    UPDATE usergroup SET
    
    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Registered Users',
        `description` = '',
        `usertitle` = 'Guest',
        `opentag` = '<span style=\"color: gray;\">',
        `closetag` = '</span>',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `ms_wic_addon_vba_permissions` = '0',
        `forumpermissions` = '12255487',
        `genericpermissions` = '1344804419',
        `attachlimit` = '0',
        `pmquota` = '50',
        `pmpermissions` = '3',
        `pmsendmax` = '5',
        `pmthrottlequantity` = '0',
        `calendarpermissions` = '17',
        `wolpermissions` = '1',
        `adminpermissions` = '0',
        `genericpermissions2` = '1',
        `genericoptions` = '62',
        `profilepicmaxwidth` = '100',
        `profilepicmaxheight` = '100',
        `profilepicmaxsize` = '65535',
        `avatarmaxwidth` = '80',
        `avatarmaxheight` = '80',
        `avatarmaxsize` = '20000',
        `signaturepermissions` = '169983',
        `sigpicmaxwidth` = '500',
        `sigpicmaxheight` = '100',
        `sigpicmaxsize` = '10000',
        `sigmaxrawchars` = '1000',
        `sigmaxchars` = '500',
        `sigmaxlines` = '0',
        `sigmaxsizebbcode` = '7',
        `sigmaximages` = '4',
        `albumpermissions` = '198',
        `albumpicmaxwidth` = '600',
        `albumpicmaxheight` = '600',
        `albummaxpics` = '100',
        `albummaxsize` = '0',
        `usercsspermissions` = '7',
        `visitormessagepermissions` = '63',
        `socialgrouppermissions` = '131136',
        `maximumsocialgroups` = '5',
        `groupiconmaxsize` = '65535',
        `ms_wic_addon_permissions` = '0',
        `vbblog_general_permissions` = '519166',
        `vbblog_customblocks` = '5',
        `vbblog_custompages` = '5',
        `vbblog_entry_permissions` = '8191',
        `vbblog_comment_permissions` = '974'
    WHERE usergroupid=2;
    
    MySQL Error   : Unknown column 'ms_wic_addon_vba_permissions' in 'field list'
    Error Number  : 1054
    Request Date  : Wednesday, December 23rd 2009 @ 05:04:52 AM
    Error Date    : Wednesday, December 23rd 2009 @ 05:04:53 AM
    Script        : http://www.m3xital.com/forum/admincp/usergroup.php?do=update
    Referrer      : http://www.m3xital.com/forum/admincp/usergroup.php?do=edit&usergroupid=2
    IP Address    : xxxxxxxx
    Username      :xxxxxxx
    Classname     : vB_Database
    MySQL Version : 5.0.85-community
    It's happening if i try to make changes to any of the usergroups.

  • #2
    MySQL Error : Unknown column 'ms_wic_addon_vba_permissions' in 'field list'

    Disable vBAdvanced and see if you still get the error.
    Vote for:

    - *Admin Settable Paid Subscription Reminder Timeframe*
    -
    *PM - Add ability to reply to originator only*
    - Add Admin ability to auto-subscribe users to specific channel(s)
    - "Quick Route" Interface...

    Comment


    • #3
      Originally posted by Trevor Hannant View Post
      MySQL Error : Unknown column 'ms_wic_addon_vba_permissions' in 'field list'

      Disable vBAdvanced and see if you still get the error.
      Thanks for your quick answer, but I have unistalled vBadvanced before upgrading to vB 4 Suite, so I don't have it anymore in the Plugins & Products.



      Comment


      • #4
        Problem solved, thanks to Lynne.

        I deleted all files from old modifications in includes/xml.

        Comment

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