Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 11-30-2011, 04:46 AM
idhk idhk is offline
 
Join Date: Nov 2011
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database Error ONLY when changing group names

Hey guys if this is posted and answered already i could not find it.

When ever i go to change a usergroup name (example) registered users to Members i get a database error, I havent done any major template edits yet, or havent added any major plug-ins im assuming something failed during install not sure what i should, if anything Re-upload

any help is welcomed, thanks in advance

http://screensnapr.com/v/QyBVAf.png
http://snpr.cm/Fnbojz.png
http://snpr.cm/l4jGhD.png

thats what i get everytime, and it happens if i change any usergroups name thanks
Reply With Quote
  #2  
Old 11-30-2011, 04:50 AM
HMBeaty's Avatar
HMBeaty HMBeaty is offline
 
Join Date: Sep 2005
Posts: 4,141
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

We need to see the whole error. Can you paste it here? However, from what I CAN see in the error, it looks like it's caused from a modification.
Reply With Quote
  #3  
Old 11-30-2011, 04:56 AM
iDHKHCM iDHKHCM is offline
 
Join Date: Aug 2011
Posts: 74
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

we disabled all plugins and it still does it

Code:
Database error in vBulletin 4.1.8:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Administrators',
	`description` = '',
	`usertitle` = 'Administrator',
	`opentag` = '',
	`closetag` = '',
	`passwordexpires` = '180',
	`passwordhistory` = '360',
	`mgc_cb_evo_permissions` = '0',
	`mgc_cb_evo_refreshrate` = '',
	`mgc_cb_evo_nbmsg_show` = '',
	`mgc_cb_evo_nbmsg_perday_show` = '',
	`mgc_cb_evo_nbthreads_perday_show` = '',
	`mgc_cb_evo_max_chats_perday` = '',
	`forumpermissions` = '16777215',
	`genericpermissions` = '2147483583',
	`attachlimit` = '0',
	`pmquota` = '50',
	`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` = '191',
	`visitormessagepermissions` = '63',
	`socialgrouppermissions` = '262143',
	`maximumsocialgroups` = '5',
	`groupiconmaxsize` = '65535'
WHERE usergroupid=6;

MySQL Error   : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, November 29th 2011 @ 11:56:31 PM
Error Date    : Tuesday, November 29th 2011 @ 11:56:31 PM
Script        : http://highclassmods.com/ExpressMedia/admincp/usergroup.php?do=update
Referrer      : http://highclassmods.com/ExpressMedia/admincp/usergroup.php?do=edit&usergroupid=6
IP Address    : 98.82.70.150
Username      : DeadlyMoDz25
Classname     : vB_Database
MySQL Version : 5.1.56-log
Reply With Quote
  #4  
Old 11-30-2011, 05:01 AM
HMBeaty's Avatar
HMBeaty HMBeaty is offline
 
Join Date: Sep 2005
Posts: 4,141
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well here you go....
Quote:
MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
mgc_cb_evo_permissions is I'm guessing from the mgc chatbox modification, disable/uninstall that, including the files, and your error should go away
Reply With Quote
  #5  
Old 11-30-2011, 05:09 AM
idhk idhk is offline
 
Join Date: Nov 2011
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by HMBeaty View Post
Well here you go....

mgc_cb_evo_permissions is I'm guessing from the mgc chatbox modification, disable/uninstall that, including the files, and your error should go away
WOW you are fast! thanks for your help. Also Lynne to https://www.vbulletin.com/forum/show...database-error

I guess someone else had the issue. but yeah dang chatbox. it was in the includes-xml i almost we almost unistalled everything from admincp lol thanks again
Reply With Quote
Благодарность от:
HMBeaty
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 08:10 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04089 seconds
  • Memory Usage 2,208KB
  • 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
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (1)post_thanks_box_bit
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)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_postinfo_query
  • fetch_postinfo
  • 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
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete