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 when I try to edit or add new usergroup (https://vborg.vbsupport.ru/showthread.php?t=193199)

MysCha 10-09-2008 09:08 PM

u never install MGC Plugin ?

i can define what ur plugin with mgc
but, i think u have install a MGC MODS in ur forum
please remember again. Because ur error message tell about it.

nb : ur error message cant lie

Christon 10-09-2008 09:18 PM

Quote:

Originally Posted by veenuisthebest (Post 1641427)
Do you have these files in /yoursite/forum/includes/xml/

bitfield_mgc_cb_evo.xml
cpnav_mgc_cb_evo.xml

If yes, delete them !

Where I find these veenuisthebest?, I search,but no find nothing.

--------------- Added [DATE]1223590827[/DATE] at [TIME]1223590827[/TIME] ---------------

Quote:

Originally Posted by MysCha (Post 1641428)
u never install MGC Plugin ?

i can define what ur plugin with mgc
but, i think u have install a MGC MODS in ur forum
please remember again. Because ur error message tell about it.

nb : ur error message cant lie

No MysCha, i never install MGC plugin.

MysCha 10-09-2008 09:24 PM

or u can manualy drop a field on sql

open ur phpmyadmin
and search sql where u install ur forum

and search this prefix vb_usergroup
open the structure
then u can find anything field called " MGC "
check list and drop them

`title` = 'Moderators',
`description` = '',
`usertitle` = 'Moderator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',

`forumpermissions` = '3928575',
`genericpermissions` = '1609504463',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '15',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`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` = '511'
WHERE usergroupid=7;

* drop the red bold

Christon 10-09-2008 09:32 PM

Quote:

Originally Posted by MysCha (Post 1641437)
or u can manualy drop a field on sql

open ur phpmyadmin
and search sql where u install ur forum

and search this prefix vb_usergroup
open the structure
then u can find anything field called " MGC "
check list and drop them

MysCha, forgives much trouble, but if you could teach me look like this, I would appreciate.

MysCha 10-09-2008 09:36 PM

u must try my guide
if not, ur forum cant run normaly coz u cant edit permission for ur usergroup

Christon 10-09-2008 09:44 PM

Quote:

Originally Posted by MysCha (Post 1641444)
u must try my guide
if not, ur forum cant run normaly coz u cant edit permission for ur usergroup

you can send me your guide MysCha.

MysCha 10-09-2008 09:45 PM

^^
read this https://vborg.vbsupport.ru/showpost....7&postcount=13

veenuisthebest 10-09-2008 09:58 PM

well.. the problem isn't that complicated :D

Error is Unknown column 'mgc_cb_evo_permissions' in 'field list'

clearly means that the columns are ALREADY dropped, but the SQL query is still looking for that column.

This is happening due to the existence of those two .XML files in /xml/ folder on your server.
Remove them, and you're done.

Christon 10-15-2008 03:21 PM

Quote:

Originally Posted by veenuisthebest (Post 1641460)
well.. the problem isn't that complicated :D

Error is Unknown column 'mgc_cb_evo_permissions' in 'field list'

clearly means that the columns are ALREADY dropped, but the SQL query is still looking for that column.

This is happening due to the existence of those two .XML files in /xml/ folder on your server.
Remove them, and you're done.

I made the procedure, but the problem is still friends.

--------------- Added [DATE]1224106352[/DATE] at [TIME]1224106352[/TIME] ---------------

help please friends.


All times are GMT. The time now is 01:18 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.01061 seconds
  • Memory Usage 1,739KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete