vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Database error affecting usergroup 2 permissions (https://vborg.vbsupport.ru/showthread.php?t=187020)

iNRoC 08-02-2008 01:55 PM
Database error affecting usergroup 2 permissions
 
I need some help with this error.

It happened after I uninstalled the MGC Chatbox.

https://vborg.vbsupport.ru/external/2008/08/76.jpg

Heres the error code..

Code:
Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Registered Users',
        `description` = '',
        `usertitle` = '',
        `opentag` = '',
        `closetag` = '',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `forumpermissions` = '3928575',
        `genericpermissions` = '1579685063',
        `attachlimit` = '0',
        `pmquota` = '50',
        `pmpermissions` = '3',
        `pmsendmax` = '5',
        `calendarpermissions` = '63',
        `wolpermissions` = '1',
        `adminpermissions` = '0',
        `genericpermissions2` = '1',
        `genericoptions` = '62',
        `profilepicmaxwidth` = '100',
        `profilepicmaxheight` = '100',
        `profilepicmaxsize` = '65535',
        `avatarmaxwidth` = '80',
        `avatarmaxheight` = '80',
        `avatarmaxsize` = '20000',
        `signaturepermissions` = '137215',
        `sigpicmaxwidth` = '500',
        `sigpicmaxheight` = '100',
        `sigpicmaxsize` = '10000',
        `sigmaxrawchars` = '1000',
        `sigmaxchars` = '500',
        `sigmaxlines` = '0',
        `sigmaxsizebbcode` = '7',
        `sigmaximages` = '4',
        `albumpermissions` = '255',
        `albumpicmaxwidth` = '600',
        `albumpicmaxheight` = '600',
        `albumpicmaxsize` = '100000',
        `albummaxpics` = '100',
        `albummaxsize` = '0',
        `usercsspermissions` = '31',
        `visitormessagepermissions` = '63',
        `socialgrouppermissions` = '375',
        `mgc_cb_evo_permissions` = '0',
        `mgc_cb_evo_nbmsg_show` = '',
        `mgc_cb_evo_nbmsg_perday_show` = ''
WHERE usergroupid=2;

MySQL Error  : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number  : 1054
Request Date  : Saturday, August 2nd 2008 @ 08:54:16 AM
Error Date    : Saturday, August 2nd 2008 @ 08:54:16 AM
Script        : http://www.uwhack.com/forum/admincp/usergroup.php?do=update
Referrer      : http://www.uwhack.com/forum/admincp/usergroup.php?do=edit&usergroupid=2
IP Address    :
Username      : iNRoC
Classname    : vB_Database
MySQL Version : 5.0.45-community-log

nexialys 08-02-2008 02:04 PM
you have MGC Chatbox installed, it's clear if you read the error...

if you did not intalled OR uninstalled ALL THE FILES from this hack, the error will continue to occur...

read the documentation for that addon.

(it's actually the bitfield file from that addon that need to be removed)

Opserty 08-02-2008 02:15 PM
Did you use the search feature?

Here is what I found:
Adding New user group
Cant Edit UserGroups :(
Database Error in usergroup manager
Usergroup Addition issue
Modifing User Group Error
Weird problem
Error updating usergroups?
problem..

iNRoC 08-02-2008 02:30 PM
Ok i fixed it. I removed the mgc bitfield


All times are GMT. The time now is 09:57 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01602 seconds
  • Memory Usage 1,721KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete