View Single Post
  #1  
Old 06-20-2008, 06:14 AM
gwon gwon is offline
 
Join Date: Mar 2004
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default SQL Error after removing an addon

I installed an addin using the plugin system on vb. Didn't like it and removed it. Ever since, whenever I try to make most changes in the admin panel (noticed it first when trying to edit usergroups) I get the following sql error

Code:
Database error in vBulletin 3.7.1:

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_nbmsg_show` = '',
	`mgc_cb_evo_nbmsg_perday_show` = '',
	`vbimghost` = '3',
	`vbimghost_upslots` = '3',
	`vbimghost_files` = '100',
	`icashpermissions` = '7',
	`forumpermissions` = '8388607',
	`genericpermissions` = '2147483583',
	`attachlimit` = '0',
	`pmquota` = '50',
	`pmpermissions` = '7',
	`pmsendmax` = '5',
	`calendarpermissions` = '63',
	`wolpermissions` = '31',
	`adminpermissions` = '3',
	`genericpermissions2` = '1',
	`genericoptions` = '55',
	`profilepicmaxwidth` = '100',
	`profilepicmaxheight` = '100',
	`profilepicmaxsize` = '65535',
	`avatarmaxwidth` = '100',
	`avatarmaxheight` = '100',
	`avatarmaxsize` = '500000',
	`signaturepermissions` = '237567',
	`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'
WHERE usergroupid=6;

MySQL Error   : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number  : 1054
Request Date  : Friday, June 20th 2008 @ 03:12:19 AM
Error Date    : Friday, June 20th 2008 @ 03:12:19 AM
Script        : http://www.brainstewed.org/forums/admincp/usergroup.php?do=update
Referrer      : http://www.brainstewed.org/forums/admincp/usergroup.php?do=edit&usergroupid=6
IP Address    : 212.21.97.189
Username      : Craig
Classname     : vB_Database
MySQL Version : 5.0.51a-community
This bit: mgc_cb_evo_permissions, leads me to the plugin, I seem to remember the name was something like that. So I'm assuming that it's calling parts of the database that aren't there...or something along those lines.

Does anyone have any idea how I can get it to stop chucking through these requests and causing the errors?

Any help much appreciated.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01095 seconds
  • Memory Usage 1,768KB
  • 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_code
  • (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