Announcement

Collapse
No announcement yet.

Error Editing Usergroups Invalid SQL: UPDATE usergroup SET

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

  • [Forum] Error Editing Usergroups Invalid SQL: UPDATE usergroup SET

    Is there anyway to fix this issue? I can't update or edit existing usergroups in the admin panel. Thanks

    Code:
    Database error in vBulletin 4.2.0:
    
    Invalid SQL:
    UPDATE usergroup SET
    
    
    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    	`title` = 'Moderators',
    	`description` = '',
    	`usertitle` = 'Moderator',
    	`opentag` = '<b><u><font color=\"#47A118\">',
    	`closetag` = '</font></u></b>',
    	`passwordexpires` = '0',
    	`passwordhistory` = '0',
    	`forumpermissions` = '83886079',
    	`genericpermissions` = '1609506543',
    	`attachlimit` = '0',
    	`pmquota` = '1500',
    	`pmpermissions` = '7',
    	`pmsendmax` = '15',
    	`pmthrottlequantity` = '0',
    	`calendarpermissions` = '63',
    	`wolpermissions` = '15',
    	`adminpermissions` = '1',
    	`genericpermissions2` = '7',
    	`genericoptions` = '63',
    	`profilepicmaxwidth` = '175',
    	`profilepicmaxheight` = '175',
    	`profilepicmaxsize` = '65535',
    	`avatarmaxwidth` = '100',
    	`avatarmaxheight` = '100',
    	`avatarmaxsize` = '20000',
    	`signaturepermissions` = '507903',
    	`sigpicmaxwidth` = '500',
    	`sigpicmaxheight` = '100',
    	`sigpicmaxsize` = '10000',
    	`sigmaxrawchars` = '1000',
    	`sigmaxchars` = '500',
    	`sigmaxlines` = '0',
    	`sigmaxsizebbcode` = '7',
    	`sigmaximages` = '4',
    	`sigmaxvideos` = '1',
    	`albumpermissions` = '255',
    	`albumpicmaxwidth` = '650',
    	`albumpicmaxheight` = '650',
    	`albummaxpics` = '100',
    	`albummaxsize` = '0',
    	`usercsspermissions` = '191',
    	`visitormessagepermissions` = '63',
    	`socialgrouppermissions` = '262143',
    	`maximumsocialgroups` = '5',
    	`groupiconmaxsize` = '65535',
    	`mgc_cb_evo_permissions` = '0',
    	`mgc_cb_evo_refreshrate` = '30',
    	`mgc_cb_evo_nbmsg_show` = '',
    	`mgc_cb_evo_nbmsg_perday_show` = '',
    	`mgc_cb_evo_nbthreads_perday_show` = '0',
    	`mgc_cb_evo_max_chats_perday` = '0',
    	`vbblog_general_permissions` = '524286',
    	`vbblog_customblocks` = '10',
    	`vbblog_custompages` = '10',
    	`vbblog_entry_permissions` = '57343',
    	`vbblog_comment_permissions` = '3038'
    WHERE usergroupid=7;
    
    
    MySQL Error   : Unknown column 'mgc_cb_evo_permissions' in 'field list'
    Error Number  : 1054
    Request Date  : Tuesday, September 4th 2012 @ 11:16:43 PM
    Error Date    : Tuesday, September 4th 2012 @ 11:16:44 PM
    Script        : http://www.njstangers.org/forum/admincp/usergroup.php?do=update
    Referrer      : http://www.njstangers.org/forum/admincp/usergroup.php?do=edit&usergroupid=7
    IP Address    : 67.85.154.56
    Username      : Stangman Jonathan
    Classname     : vB_Database
    MySQL Version : 5.0.95-community-log
    - - - Updated - - -

    had to delete any references to: mgc_cb_evo in the my files for anyone else who this may help.

  • #2
    That was caused by a plugin.

    Sent from my iPhone using Forum Runner.

    Comment


    • #3
      Looks like a chat box mod is causing this. If you removed this mod already then you didn't delete all the files- it is required you delete the files you uploaded when installing a mod after uninstalling- in particular the files in the /includes/xml/ directory.

      Comment


      • #4
        Is there any solution to this problem other than deleting mgc chatbox

        Comment


        • #5
          No, as this issue is caused by the addon you are using. You need to ask the author of it at www.vbulletin.org. You can get along with it by disabling the mod but that will not fix the bug in first place.
          No private support, only PM me when I ask for it. Support in the forums only.

          Comment

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