Thread: Advanced Warning System (AWS)
View Single Post
  #671  
Old 01-11-2005, 04:24 PM
sv1cec sv1cec is offline
 
Join Date: May 2004
Location: Athens, Greece
Posts: 2,091
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by rinkrat
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
Sorry, wrong input on my behalf. Here is the proper query:

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

Then use the modification I told you before in the functions_warning.php and try to issue a warning.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01166 seconds
  • Memory Usage 1,780KB
  • 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)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