Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 07-11-2008, 03:54 PM
pooffck1 pooffck1 is offline
 
Join Date: Apr 2008
Posts: 77
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Very seirous database error

Ok so i unstalled the evo chatbox

Every time i save something on usergroup it gives me this message

AND BANNED MEMBERS ARE UNBANNED ( i cant do anything please help!!!!

Code:
Database error in vBulletin 3.7.1:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = '<!-- Order=\"1\" -->Owner',
	`description` = '',
	`usertitle` = 'Administrator',
	`opentag` = '<img src=\"http://icons.primail.ch/stars/bstar07.gif\"/><b><font color=\"#0000FF\">',
	`closetag` = '</font></b>',
	`passwordexpires` = '180',
	`passwordhistory` = '360',
	`forumpermissions` = '8388607',
	`genericpermissions` = '2147483647',
	`attachlimit` = '0',
	`pmquota` = '50',
	`pmpermissions` = '7',
	`pmsendmax` = '5',
	`calendarpermissions` = '63',
	`wolpermissions` = '31',
	`adminpermissions` = '3',
	`genericpermissions2` = '1',
	`genericoptions` = '63',
	`profilepicmaxwidth` = '100',
	`profilepicmaxheight` = '100',
	`profilepicmaxsize` = '65535',
	`avatarmaxwidth` = '100',
	`avatarmaxheight` = '100',
	`avatarmaxsize` = '200000',
	`signaturepermissions` = '245759',
	`sigpicmaxwidth` = '500',
	`sigpicmaxheight` = '100',
	`sigpicmaxsize` = '10000',
	`sigmaxrawchars` = '0',
	`sigmaxchars` = '0',
	`sigmaxlines` = '0',
	`sigmaxsizebbcode` = '7',
	`sigmaximages` = '0',
	`albumpermissions` = '255',
	`albumpicmaxwidth` = '600',
	`albumpicmaxheight` = '600',
	`albumpicmaxsize` = '100000',
	`albummaxpics` = '100',
	`albummaxsize` = '0',
	`usercsspermissions` = '31',
	`visitormessagepermissions` = '63',
	`socialgrouppermissions` = '511',
	`creditpermissions` = '4094',
	`credit_induction` = '100',
	`credit_referral` = '100',
	`credit_refbonus` = '0.05',
	`credit_paycheck` = '0',
	`credit_active` = '20',
	`credit_birthday` = '100',
	`credit_repgive` = '0.1',
	`credit_reputation` = '2',
	`credit_infraction` = '-10',
	`credit_thread` = '10',
	`credit_threadrate` = '1',
	`credit_post` = '5',
	`credit_ownthreadpost` = '3',
	`credit_postsize` = '0.05',
	`credit_ownthreadview` = '0.05',
	`credit_ownthreadrate` = '1',
	`credit_ownthreadreply` = '2',
	`credit_ownprofileview` = '0.05',
	`credit_pollmake` = '5',
	`credit_pollvote` = '1',
	`credit_attachment` = '3',
	`credit_sendpm` = '-2',
	`credit_addevent` = '3',
	`credit_addprofpic` = '3',
	`credit_profile` = '0',
	`credit_donmaxuser` = '-1',
	`credit_pastotpost` = '0',
	`credit_pastotuser` = '0',
	`credit_pasawuser` = '0',
	`credit_pasawthread` = '0',
	`credit_saveint` = '0.035',
	`credit_maxsave` = '10000',
	`credit_loanint` = '0.195',
	`credit_maxloan` = '1000',
	`credit_totloan` = '5',
	`credit_goodgroup` = '0',
	`credit_midgroup` = '0',
	`credit_badgroup` = '0',
	`credit_maxtickets` = '10',
	`credit_lotdiscount` = '0',
	`mgc_cb_evo_permissions` = '0',
	`mgc_cb_evo_nbmsg_show` = '',
	`mgc_cb_evo_nbmsg_perday_show` = '',
	`vbblog_general_permissions` = '126',
	`vbblog_entry_permissions` = '24188',
	`vbblog_comment_permissions` = '990',
	`split_useronline_permissions` = '1'
WHERE usergroupid=6;

MySQL Error   : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number  : 1054
Request Date  : Friday, July 11th 2008 @ 09:52:11 AM
Error Date    : Friday, July 11th 2008 @ 09:52:11 AM
Script        : http://blah-blah.com/forum/admincp/usergroup.php?do=update
Referrer      : http://blah-blah.com/forum/admincp/usergroup.php?do=edit&usergroupid=6
IP Address    : ........................................ (REMOVED)
Username      : Allmighty
Classname     : vB_Database
MySQL Version : 5.0.24a-standard-log
Reply With Quote
  #2  
Old 07-11-2008, 04:09 PM
Internetcafe Internetcafe is offline
 
Join Date: May 2008
Location: London
Posts: 130
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Disable the MGC Chatbox hack you have installed and see if that solves the problem. If it does, then you have done something wrong during installation.

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

You obviously didn't uninstall the chatbox correctly ..
Reply With Quote
  #3  
Old 07-11-2008, 04:13 PM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

  1. Go to this page (this forum): https://vborg.vbsupport.ru/forumdisplay.php?f=15
  2. Click the "Search this Forums" button (top right of threads areas)
  3. Enter "mgc_cb_evo_permissions" (the column causing your database error)
  4. Hit search.
  5. See the results.
May the search be with you
Reply With Quote
  #4  
Old 07-11-2008, 04:20 PM
pooffck1 pooffck1 is offline
 
Join Date: Apr 2008
Posts: 77
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Opserty View Post
  1. Go to this page (this forum): https://vborg.vbsupport.ru/forumdisplay.php?f=15
  2. Click the "Search this Forums" button (top right of threads areas)
  3. Enter "mgc_cb_evo_permissions" (the column causing your database error)
  4. Hit search.
  5. See the results.
May the search be with you
Thanks it told me to delete some bitfield file from includes >> xml and it solved it.

Thanks alot
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:28 PM.


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.03469 seconds
  • Memory Usage 2,193KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete