Announcement

Collapse
No announcement yet.

Mysql errors after changing usergroup permissions

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

  • [Forum] Mysql errors after changing usergroup permissions

    I am unable to change permissions as i get this error.

    I removed the plugin Mcg chatbox when i upgraded but it still appears in permissions..

    how can i fix this



    [IMG]file:///C:/Users/mark/AppData/Local/Temp/moz-screenshot.png[/IMG]

    Database error in vBulletin 4.0.1:

    Invalid SQL:
    UPDATE usergroup SET

    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Registered Users',
    `description` = '',
    `usertitle` = '',
    `opentag` = '',
    `closetag` = '',
    `passwordexpires` = '0',
    `passwordhistory` = '0',
    `downloads2permissions` = '34815',
    `downloads2extrapermissions` = '0',
    `excludecatlist` = '',
    `downloadsmaxuploadtotal` = '-1',
    `downloadsmaxdailydl` = '-1',
    `downloadsmaxdailyfiles` = '-1',
    `downloaddelaygrp` = '60',
    `gcbos_permissions` = '0',
    `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',
    `forumpermissions` = '12317183',
    `genericpermissions` = '1579687623',
    `attachlimit` = '0',
    `pmquota` = '100',
    `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` = '139263',
    `sigpicmaxwidth` = '500',
    `sigpicmaxheight` = '100',
    `sigpicmaxsize` = '10000',
    `sigmaxrawchars` = '1000',
    `sigmaxchars` = '500',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '7',
    `sigmaximages` = '4',
    `albumpermissions` = '255',
    `albumpicmaxwidth` = '600',
    `albumpicmaxheight` = '600',
    `albummaxpics` = '100',
    `albummaxsize` = '0',
    `usercsspermissions` = '63',
    `visitormessagepermissions` = '63',
    `socialgrouppermissions` = '251767',
    `maximumsocialgroups` = '5',
    `groupiconmaxsize` = '65535'
    WHERE usergroupid=2;

    MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
    Error Number : 1054
    Request Date : Saturday, January 16th 2010 @ 11:11:05 AM
    Error Date : Saturday, January 16th 2010 @ 11:11:05 AM
    Script : http://wpgoldmine.com/Forum/admincp/....php?do=update
    Referrer : http://wpgoldmine.com/Forum/admincp/...&usergroupid=2
    IP Address : 83.59.238.213
    Username : Mark
    Classname : vB_Database
    MySQL Version : 5.0.85-community


  • #2
    You will need to ask for help in the modification thread.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment

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