Announcement

Collapse
No announcement yet.

Database Error

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

  • [Forum] Database Error

    I keep getting this database error when i edit a usergroup via admin any suggestions i am new to this so i havnt a clue please help


    Database error in vBulletin 4.1.9: Invalid SQL: UPDATE usergroup SET ### UPDATE QUERY GENERATED BY fetch_query_sql() ### `title` = 'Clan Leaders', `description` = '', `usertitle` = 'Clan Leader', `opentag` = '<span style=\"font-weight: bold; color: yellow;\">', `closetag` = '</span>', `passwordexpires` = '180', `passwordhistory` = '360', `market_permissions` = '1', `market_discount` = '0.0000', `market_maxdonate` = '0.00000', `market_undo_time` = '24', `market_undo_penalty` = '0.5000', `market_gift_minimum` = '100.85', `market_gift_maximum` = '3500.45', `market_steal_percent` = '100', `market_convert_permissions` = '1', `market_history_permissions` = '1', `market_bank_permissions` = '1', `market_interest_rate` = '0.0215', `market_min_deposit` = '10.95', `market_deposit_fee` = '0.0299', `market_min_withdrawel` = '5.95', `market_withdrawel_fee` = '0.0149', `awardpermissions` = '3', `tournamentpermissions` = '1023', `maxteams` = '5', `ladderpermissions` = '255', `forumpermissions` = '16777215', `genericpermissions` = '2147483583', `attachlimit` = '0', `pmquota` = '150', `pmpermissions` = '7', `pmsendmax` = '5', `pmthrottlequantity` = '0', `calendarpermissions` = '63', `wolpermissions` = '31', `adminpermissions` = '3', `genericpermissions2` = '1', `genericoptions` = '55', `profilepicmaxwidth` = '100', `profilepicmaxheight` = '100', `profilepicmaxsize` = '65535', `avatarmaxwidth` = '80', `avatarmaxheight` = '80', `avatarmaxsize` = '20000', `signaturepermissions` = '237567', `sigpicmaxwidth` = '500', `sigpicmaxheight` = '100', `sigpicmaxsize` = '10000', `sigmaxrawchars` = '0', `sigmaxchars` = '0', `sigmaxlines` = '0', `sigmaxsizebbcode` = '7', `sigmaximages` = '0', `albumpermissions` = '255', `albumpicmaxwidth` = '600', `albumpicmaxheight` = '600', `albummaxpics` = '100', `albummaxsize` = '0', `usercsspermissions` = '0', `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' WHERE usergroupid=6; MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list' Error Number : 1054 Request Date : Tuesday, January 17th 2012 @ 12:48:32 PM Error Date : Tuesday, January 17th 2012 @ 12:48:33 PM Script : http://www.rateoffire.co.uk/admincp/....php?do=update Referrer : http://www.rateoffire.co.uk/admincp/...&usergroupid=6 IP Address : 2.101.29.10 Username : Maxxamillion Classname : vB_Database MySQL Version : 5.1.56-log

  • #2
    this is because of your custom chat program is missing a field try installing it again

    Comment


    • #3
      i have uninstalled this chat as i found a better one but it still persists i cant seem to find what file i need to remove in my ftp

      Comment


      • #4
        if you are not sure what files to remove in the ftp download the chat program again and look also it might help to install then uninstall as some parts did not remove right

        remember when removing any plugin you must also delete all files in the ftp for that program or as you see it will cause problems

        Comment

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