Thread: Administrative and Maintenance Tools - Advanced Warning System 3.6.7
View Single Post
  #160  
Old 12-22-2006, 12:34 AM
mrpotatohead mrpotatohead is offline
 
Join Date: Jul 2004
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for this...

...but I recevied this error when trying to install the product:

Code:
Database error in vBulletin 3.6.4:

Invalid SQL:

				INSERT INTO setting
					(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
				VALUES
					(
					'warn_hierarchical',
					'warning',
					'0',
					'1',
					'free',
					'yesno',
					2,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_automatic',
					'warning',
					'0',
					'1',
					'free',
					'yesno',
					3,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_automaticpm',
					'warning',
					'0',
					'0',
					'free',
					'yesno',
					4,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_autocomments',
					'warning',
					'0',
					'0',
					'free',
					'yesno',
					5,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_automatic_warner',
					'warning',
					'2137',
					'1',
					'free',
					'',
					6,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_warner',
					'warning',
					'0',
					'0',
					'free',
					'',
					7,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_collector',
					'warning',
					'1',
					'1',
					'free',
					'',
					8,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_banned_limit',
					'warning',
					'2147483647',
					'7',
					'free',
					'',
					9,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_points_before_banned',
					'warning',
					'10',
					'10',
					'free',
					'',
					10,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_warnings_before_banned',
					'warning',
					'3',
					'10',
					'free',
					'',
					11,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_banned_usergroup_id',
					'warning',
					'13',
					'8',
					'number',
					'',
					12,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_protected_usergroups',
					'warning',
					'65717',
					'',
					'free',
					'',
					13,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_troll_usergroup_id',
					'warning',
					'13',
					'9',
					'number',
					'',
					14,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_restore_groupid',
					'warning',
					'18',
					'2',
					'number',
					'',
					15,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_incr_ban_days',
					'warning',
					'0',
					'1',
					'free',
					'yesno',
					16,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_max_no_bans',
					'warning',
					'0',
					'3',
					'free',
					'',
					17,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_bans_mature',
					'warning',
					'0',
					'0',
					'free',
					'',
					18,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_viewoption',
					'warning',
					'All',
					'Mgm',
					'free',
					'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"All\\\" \" . iif($setting[\'value\']==\'All\',\'selected=\"selected\"\') . \">All</option>\r\n<option value=\\\"Mgm\\\" \" . iif($setting[\'value\']==\'Mgm\',\'selected=\"selected\"\') . \">Mgm</option>\r\n</select>',
					19,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_multiple_per_post',
					'warning',
					'1',
					'1',
					'free',
					'yesno',
					20,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_send_em_warning',
					'warning',
					'1',
					'1',
					'free',
					'yesno',
					21,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_send_pm_warning',
					'warning',
					'1',
					'0',
					'free',
					'yesno',
					22,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_email_on_ban',
					'warning',
					'1',
					'1',
					'free',
					'yesno',
					23,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_historical',
					'warning',
					'1',
					'1',
					'free',
					'yesno',
					24,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_allowoffpost',
					'warning',
					'1',
					'1',
					'free',
					'yesno',
					25,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_warnings_per_page',
					'warning',
					'20',
					'15',
					'free',
					'',
					26,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_textbutoption',
					'warning',
					'Text',
					'Text',
					'free',
					'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"Text\\\" \" . iif($setting[\'value\']==\'Text\',\'selected=\"selected\"\') . \">Text</option>\r\n<option value=\\\"Buttons\\\" \" . iif($setting[\'value\']==\'Buttons\',\'selected=\"selected\"\') . \">Buttons</option>\r\n</select>',
					26,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_modoption',
					'warning',
					'All',
					'Own',
					'free',
					'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"Own\\\" \" . iif($setting[\'value\']==\'Own\',\'selected=\"selected\"\') . \">Own</option>\r\n<option value=\\\"All\\\" \" . iif($setting[\'value\']==\'All\',\'selected=\"selected\"\') . \">All</option>\r\n</select>',
					28,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_sig_thresshold',
					'warning',
					'0',
					'0',
					'free',
					'',
					29,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_avatar_thresshold',
					'warning',
					'0',
					'0',
					'free',
					'',
					30,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_pic_thresshold',
					'warning',
					'0',
					'0',
					'free',
					'',
					31,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_pmcutoff',
					'warning',
					'0',
					'0',
					'free',
					'',
					32,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_admingroups',
					'warning',
					'6',
					'',
					'free',
					'',
					33,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_sigpic_thresshold',
					'warning',
					'0',
					'0',
					'free',
					'',
					33,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_smodgroups',
					'warning',
					'5',
					'',
					'free',
					'',
					34,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_aprotected_usergroups',
					'warning',
					'17',
					'',
					'free',
					'',
					34,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_modgroups',
					'warning',
					'7',
					'',
					'free',
					'',
					35,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_includepost',
					'warning',
					'1',
					'0',
					'free',
					'yesno',
					36,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_savecopy',
					'warning',
					'1',
					'0',
					'free',
					'yesno',
					37,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_savecopyalert',
					'warning',
					'1',
					'0',
					'free',
					'yesno',
					38,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_savecopyforum',
					'warning',
					'38',
					'',
					'free',
					'',
					39,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_allowalerts',
					'warning',
					'1',
					'0',
					'free',
					'yesno',
					40,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_allowalertscomment',
					'warning',
					'1',
					'0',
					'free',
					'yesno',
					41,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_alertslifetime',
					'warning',
					'0',
					'0',
					'free',
					'',
					42,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_allownotes',
					'warning',
					'1',
					'1',
					'free',
					'yesno',
					43,
					0,
					1,
					'',
					0,
					'aws'
	),
	(
					'warn_version',
					'warning',
					'3.4.11',
					'3.6.1',
					'free',
					'',
					44,
					0,
					1,
					'',
					0,
					'aws'
	);

MySQL Error  : Duplicate entry 'warn_hierarchical' for key 1
Error Number : 1062
Date         : Thursday, December 21st 2006 @ 08:33:11 PM
Script       : http://www.bigbrotherwebsite.net/for...=productimport
Referrer     : http://www.bigbrotherwebsite.net/for...?do=productadd
IP Address   : 86.149.221.27
Username     : Big Brother
Classname    : vb_database
Any ideas?!
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01129 seconds
  • Memory Usage 1,827KB
  • 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