View Single Post
  #1  
Old 11-22-2008, 11:56 PM
Doctor Death Doctor Death is offline
 
Join Date: Dec 2005
Posts: 449
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Error In Group Permission Settings

I received this error message. Wonder if you can help figure out how to fix it? I cannot change any group attributes because of the errors this is generating. I belive it is caused by a mod that didnt fully uninstall.

Quote:
Database error in vBulletin 3.7.4:

Invalid SQL:
UPDATE vyxxxxxxxbh_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = '-=SOG=- Members',
`description` = 'Fully vetted -=SOG=- Team members who pay monthly dues. These people have all been voted onto the team and have stated they will abide by team policies',
`usertitle` = '',
`opentag` = '<font color=\"green\">',
`closetag` = '</font>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`radiotvpermissions` = '451',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`phpkd_pmpruneperiod` = '21',
`creditpermissions` = '68',
`credit_induction` = '30000',
`credit_referral` = '1000',
`credit_refbonus` = '1000',
`credit_paycheck` = '3000',
`credit_active` = '1000',
`credit_birthday` = '20000',
`credit_repgive` = '1000',
`credit_reputation` = '1000',
`credit_infraction` = '-1000',
`credit_thread` = '2000',
`credit_threadrate` = '2000',
`credit_post` = '2000',
`credit_ownthreadpost` = '2000',
`credit_postsize` = '1000',
`credit_ownthreadview` = '1000',
`credit_ownthreadrate` = '1000',
`credit_ownthreadreply` = '1000',
`credit_ownprofileview` = '1000',
`credit_pollmake` = '2000',
`credit_pollvote` = '2000',
`credit_attachment` = '2000',
`credit_sendpm` = '2000',
`credit_addevent` = '2000',
`credit_addprofpic` = '2000',
`credit_profile` = '2000',
`credit_donmaxuser` = '-1',
`credit_pastotpost` = '-1',
`credit_pastotuser` = '-1',
`credit_pasawuser` = '0',
`credit_pasawthread` = '0',
`credit_saveint` = '0',
`credit_maxsave` = '0',
`credit_loanint` = '0',
`credit_maxloan` = '0',
`credit_totloan` = '0',
`credit_goodgroup` = '0',
`credit_midgroup` = '0',
`credit_badgroup` = '0',
`credit_maxtickets` = '0',
`credit_lotdiscount` = '0',
`automediaembed_edit_permissions` = '126',
`automediaembed_view_permissions` = '126',
`forumpermissions` = '3797247',
`genericpermissions` = '2129641435',
`attachlimit` = '1000000',
`pmquota` = '100',
`pmpermissions` = '5',
`pmsendmax` = '15',
`calendarpermissions` = '55',
`wolpermissions` = '15',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '47',
`profilepicmaxwidth` = '300',
`profilepicmaxheight` = '300',
`profilepicmaxsize` = '25000',
`avatarmaxwidth` = '200',
`avatarmaxheight` = '200',
`avatarmaxsize` = '20000',
`signaturepermissions` = '241663',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '500',
`sigpicmaxsize` = '0',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`albumpermissions` = '239',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '0',
`albummaxsize` = '0',
`usercsspermissions` = '31',
`visitormessagepermissions` = '55',
`socialgrouppermissions` = '375',
`vbgmepermissions` = '23',
`trmperms` = '1'
WHERE usergroupid=9;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Saturday, November 22nd 2008 @ 08:47:02 PM
Error Date : Saturday, November 22nd 2008 @ 08:47:02 PM
Script : http://www.xxxxxcom/forums/admincp/u....php?do=update
Referrer : http://www.xxxxx.com/forums/admincp/...&usergroupid=9
IP Address : 70.xxx.40.132
Username : xxxxxxxxx
Classname : vb_database
MySQL Version : 4.1.22-standard
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01228 seconds
  • Memory Usage 1,791KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete