Announcement

Collapse
No announcement yet.

Database error

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

  • Database error

    hi all,
    im getting the following error when trying to modify usergroup perms (in this case administrators).
    i have uninstalled the mgc cyb chatbox plugin but its left something behind in my database..
    be very grateful to know what i should do to sort this out, im at a loss..!!
    many thanks,
    nik

    Database error in vBulletin 3.7.4:

    Invalid SQL:
    UPDATE vb_usergroup SET

    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Administrators',
    `description` = '',
    `usertitle` = 'Administrator',
    `opentag` = '<span style=\"font: helvetica; font-weight: bold;color: #FF0000;\">',
    `closetag` = '</span>',
    `passwordexpires` = '180',
    `passwordhistory` = '360',
    `mgc_cb_evo_permissions` = '0',
    `mgc_cb_evo_refreshrate` = '30',
    `mgc_cb_evo_nbmsg_show` = '',
    `mgc_cb_evo_nbmsg_perday_show` = '',
    `mgc_cb_evo_max_chats_perday` = '0',
    `forumpermissions` = '8388607',
    `genericpermissions` = '2113929151',
    `attachlimit` = '0',
    `pmquota` = '1000',
    `pmpermissions` = '7',
    `pmsendmax` = '100',
    `calendarpermissions` = '63',
    `wolpermissions` = '31',
    `adminpermissions` = '3',
    `genericpermissions2` = '1',
    `genericoptions` = '63',
    `profilepicmaxwidth` = '300',
    `profilepicmaxheight` = '300',
    `profilepicmaxsize` = '200000',
    `avatarmaxwidth` = '120',
    `avatarmaxheight` = '120',
    `avatarmaxsize` = '1000000',
    `signaturepermissions` = '237567',
    `sigpicmaxwidth` = '500',
    `sigpicmaxheight` = '100',
    `sigpicmaxsize` = '20000',
    `sigmaxrawchars` = '0',
    `sigmaxchars` = '0',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '7',
    `sigmaximages` = '0',
    `albumpermissions` = '255',
    `albumpicmaxwidth` = '1200',
    `albumpicmaxheight` = '1200',
    `albumpicmaxsize` = '500000',
    `albummaxpics` = '100',
    `albummaxsize` = '0',
    `usercsspermissions` = '31',
    `visitormessagepermissions` = '63',
    `socialgrouppermissions` = '511',
    `ecdownloadpermissions` = '16383',
    `ecexcludecatlist` = '',
    `ecdownloadsmaxuploadtotal` = '-1',
    `ecdownloadsmaxdailydl` = '-1',
    `ecdownloadsmaxdailyfiles` = '-1',
    `ecdownloaddelaygrp` = '-1',
    `videodirectorypermissions` = '255'
    WHERE usergroupid=6;

    MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
    Error Number : 1054
    Request Date : Tuesday, February 24th 2009 @ 12:34:19 PM
    Error Date : Tuesday, February 24th 2009 @ 12:34:19 PM
    Script : http://???/admincp/usergroup.php?do=update
    Referrer : http://???/admincp/usergroup.php?do=edit&usergroupid=6
    IP Address : ???
    Username : ???
    Classname : vb_database
    MySQL Version : 5.0.67-community

  • #2
    There is no 'mgc_cb_evo_permissions' field in the default vB. That is from an add-on that you have not completely removed.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      thanks for the quick response..
      i guessed that was the problem but any ideas how i fix it..?

      Comment


      • #4
        You need to completely remove the add-on that is causing this. For further help you should post over at www.vbulletin.org.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          oh jeez..i was such an idiot, of course..problem solved..feel free to delete this thread..

          Comment

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