Thread: Toplist
View Single Post
  #302  
Old 12-15-2005, 12:03 AM
Nova2k Nova2k is offline
 
Join Date: Apr 2005
Location: England
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi,

This is my first time install of this hack, when i run the XML file i get the following error.
Code:
Database error in vBulletin 3.5.2:

Invalid SQL:

				INSERT INTO setting
				(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
				VALUES
				(
					'toplist_enabled',
					'toplist_options',
					'1',
					'1',
					'free',
					'yesno',
					10,
					0,
					1,
					'toplist'
	),
	(
					'disabled_message',
					'toplist_options',
					'The Toplist is Currently Disabled. Please Come Back Later.',
					'The Toplist is Currently Disabled. Please Come Back Later.',
					'free',
					'textarea',
					20,
					0,
					1,
					'toplist'
	),
	(
					'toplist_ranking_method',
					'toplist_options',
					'0',
					'0',
					'number',
					'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"0\\\" \" . iif($setting[\'value\']==0,\'selected=\"selected\"\') . \">In Hits</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==1,\'selected=\"selected\"\') . \">Out Hits</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==2,\'selected=\"selected\"\') . \">Rating</option>\r\n</select>',
					30,
					0,
					1,
					'toplist'
	),
	(
					'toplist_count_out_from_guests',
					'toplist_options',
					'0',
					'0',
					'free',
					'yesno',
					40,
					0,
					1,
					'toplist'
	),
	(
					'toplist_limit_out_clicks',
					'toplist_options',
					'1',
					'1',
					'free',
					'yesno',
					50,
					0,
					1,
					'toplist'
	),
	(
					'toplist_out_click_limit',
					'toplist_options',
					'1',
					'1',
					'free',
					'',
					60,
					0,
					1,
					'toplist'
	),
	(
					'toplist_limit_in_clicks',
					'toplist_options',
					'1',
					'1',
					'free',
					'yesno',
					70,
					0,
					1,
					'toplist'
	),
	(
					'toplist_in_click_limit',
					'toplist_options',
					'1',
					'1',
					'free',
					'',
					80,
					0,
					1,
					'toplist'
	),
	(
					'toplist_allowed_user_groups',
					'toplist_options',
					'2,5,6,7',
					'2,5,6,7',
					'free',
					'',
					90,
					0,
					1,
					'toplist'
	),
	(
					'toplist_allow_member_edit',
					'toplist_options',
					'1',
					'1',
					'free',
					'yesno',
					100,
					0,
					1,
					'toplist'
	),
	(
					'toplist_allowed_to_moderate',
					'toplist_options',
					'5,6,7',
					'5,6,7',
					'free',
					'',
					110,
					0,
					1,
					'toplist'
	),
	(
					'',
					'toplist_options',
					'1',
					'1',
					'free',
					'yesno',
					120,
					0,
					1,
					'toplist'
	),
	(
					'toplist_open_in_new_window',
					'toplist_options',
					'1',
					'1',
					'free',
					'yesno',
					120,
					0,
					1,
					'toplist'
	),
	(
					'toplist_disable_html',
					'toplist_options',
					'1',
					'1',
					'free',
					'yesno',
					130,
					0,
					1,
					'toplist'
	),
	(
					'toplist_moderate_sites',
					'toplist_options',
					'0',
					'0',
					'free',
					'yesno',
					140,
					0,
					1,
					'toplist'
	),
	(
					'toplist_email_new_validation',
					'toplist_options',
					'0',
					'0',
					'free',
					'yesno',
					150,
					0,
					1,
					'toplist'
	),
	(
					'toplist_email_users',
					'toplist_options',
					'1',
					'1',
					'free',
					'',
					160,
					0,
					1,
					'toplist'
	),
	(
					'toplist_pm_new_validation',
					'toplist_options',
					'0',
					'0',
					'free',
					'yesno',
					170,
					0,
					1,
					'toplist'
	),
	(
					'toplist_pm_from_user',
					'toplist_options',
					'1',
					'1',
					'free',
					'',
					180,
					0,
					1,
					'toplist'
	),
	(
					'toplist_pm_users',
					'toplist_options',
					'1',
					'1',
					'free',
					'',
					190,
					0,
					1,
					'toplist'
	),
	(
					'sites_per_page',
					'toplist_options',
					'15',
					'15',
					'free',
					'',
					200,
					0,
					1,
					'toplist'
	),
	(
					'toplist_in_redirect_url',
					'toplist_options',
					'',
					'',
					'free',
					'',
					210,
					0,
					1,
					'toplist'
	),
	(
					'toplist_number_of_sites',
					'toplist_options',
					'1',
					'1',
					'free',
					'',
					220,
					0,
					1,
					'toplist'
	),
	(
					'toplist_max_height',
					'toplist_options',
					'31',
					'31',
					'free',
					'',
					230,
					0,
					1,
					'toplist'
	),
	(
					'toplist_max_width',
					'toplist_options',
					'88',
					'88',
					'free',
					'',
					240,
					0,
					1,
					'toplist'
	),
	(
					'toplist_popup_height',
					'toplist_options',
					'220',
					'220',
					'free',
					'',
					250,
					0,
					1,
					'toplist'
	),
	(
					'toplist_popup_width',
					'toplist_options',
					'250',
					'250',
					'free',
					'',
					260,
					0,
					1,
					'toplist'
	);

MySQL Error  : Duplicate entry '' for key 1
Error Number : 1062
Date         : Wednesday, December 14th 2005 @ 08:01:19 PM
Script       : http://www.robscorner.com/forum/admincp/plugin.php
Referrer     : http://www.robscorner.com/forum/admincp/plugin.php?do=productadd
IP Address   : *********
Username     : ByteDevil
Classname    : vb_database
I have checked the database and there is no Topsite tables of any topsite data in the database before the install.

Thanks for this great hack cant wait to get it working.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01397 seconds
  • Memory Usage 1,799KB
  • 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