Thread: Advanced Warning System (AWS)
View Single Post
  #670  
Old 01-11-2005, 03:23 PM
rinkrat's Avatar
rinkrat rinkrat is offline
 
Join Date: Jan 2002
Location: Long Beach
Posts: 530
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Code:
Error

SQL-query : 

ALTER TABLE `warning_options` ADD COLUMN `caused_ban` char( 1 ) AFTER warned_warning_id

MySQL said:
#1054 - Unknown column 'warned_warning_id' in 'warning_options'
Here's the table:

Code:
 	 Field   	Type  	Attributes  	Null  	Default  	Extra  	Action
	 oid  	int(15) 	  	No  	  	auto_increment  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 banned_limit  	int(15) 	  	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 points_before_banned  	int(15) 	  	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 banned_usergroup_id  	int(15) 	  	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 protected_usergroups  	varchar(255) 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 version  	varchar(10) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 hierarchical  	char(3) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 automatic  	char(3) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 automaticpm  	char(3) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 autocomments  	char(3) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 automatic_warner  	int(10) 	UNSIGNED 	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 warner  	int(15) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 troll_usergroup_id  	varchar(10) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 aprotected_usergroups  	varchar(10) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 restore_groupid  	smallint(5) 	UNSIGNED 	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 incr_ban_days  	char(3) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 max_no_bans  	int(5) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 bans_mature  	int(10) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 viewoption  	char(3) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 multiple_per_post  	char(3) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 send_pm_warning  	char(3) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 send_em_warning  	char(3) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 email_on_ban  	char(3) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 historical  	char(3) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 allowoffpost  	char(3) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 warnings_per_page  	int(3) 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 collector  	int(10) 	UNSIGNED 	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01022 seconds
  • Memory Usage 1,772KB
  • 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
  • (2)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