Thread: Toplist
View Single Post
  #762  
Old 06-08-2006, 08:01 PM
chriszep chriszep is offline
 
Join Date: Dec 2005
Posts: 47
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have no chance
I deleted everything in my sql base
but when I upload the product

Quote:
Database error in vBulletin 3.5.3:

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<option value=\\\"3\\\" \" . iif($setting[\'value\']==3,\'selected=\"selected\"\') . \">Views</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_open_in_new_window',
'toplist_options',
'1',
'1',
'free',
'yesno',
90,
0,
1,
'toplist'
),
(
'toplist_disable_html',
'toplist_options',
'1',
'1',
'free',
'yesno',
100,
0,
1,
'toplist'
),
(
'toplist_moderate_sites',
'toplist_options',
'0',
'0',
'free',
'yesno',
110,
0,
1,
'toplist'
),
(
'',
'toplist_options',
'1',
'1',
'free',
'yesno',
120,
0,
1,
'toplist'
),
(
'toplist_email_new_validation',
'toplist_options',
'0',
'0',
'free',
'yesno',
120,
0,
1,
'toplist'
),
(
'toplist_email_users',
'toplist_options',
'1',
'1',
'free',
'',
130,
0,
1,
'toplist'
),
(
'toplist_pm_new_validation',
'toplist_options',
'0',
'0',
'free',
'yesno',
140,
0,
1,
'toplist'
),
(
'toplist_pm_from_user',
'toplist_options',
'1',
'1',
'free',
'',
150,
0,
1,
'toplist'
),
(
'toplist_pm_users',
'toplist_options',
'1',
'1',
'free',
'',
160,
0,
1,
'toplist'
),
(
'sites_per_page',
'toplist_options',
'15',
'15',
'free',
'',
170,
0,
1,
'toplist'
),
(
'toplist_in_redirect_url',
'toplist_options',
'',
'',
'free',
'',
180,
0,
1,
'toplist'
),
(
'toplist_number_of_sites',
'toplist_options',
'1',
'1',
'free',
'',
190,
0,
1,
'toplist'
),
(
'toplist_max_height',
'toplist_options',
'31',
'31',
'free',
'',
200,
0,
1,
'toplist'
),
(
'toplist_max_width',
'toplist_options',
'88',
'88',
'free',
'',
210,
0,
1,
'toplist'
),
(
'toplist_popup_height',
'toplist_options',
'220',
'220',
'free',
'',
220,
0,
1,
'toplist'
),
(
'toplist_popup_width',
'toplist_options',
'250',
'250',
'free',
'',
230,
0,
1,
'toplist'
),
(
'toplist_show_forumhome_images',
'toplist_options',
'0',
'0',
'free',
'yesno',
240,
0,
1,
'toplist'
),
(
'toplist_forumhome_marquee_direction',
'toplist_options',
'left',
'left',
'free',
'',
250,
0,
1,
'toplist'
),
(
'toplist_forumhome_marquee_scrollamount',
'toplist_options',
'5',
'5',
'free',
'',
260,
0,
1,
'toplist'
),
(
'toplist_forumhome_number_of_images',
'toplist_options',
'0',
'0',
'free',
'',
270,
0,
1,
'toplist'
),
(
'toplist_max_image_size',
'toplist_options',
'5000',
'5000',
'free',
'',
280,
0,
1,
'toplist'
),
(
'toplist_number_of_in_hits_until_banner_shows',
'toplist_options',
'0',
'0',
'free',
'',
290,
0,
1,
'toplist'
),
(
'toplist_show_user_banners',
'toplist_options',
'1',
'1',
'free',
'yesno',
300,
0,
1,
'toplist'
),
(
'toplist_check_if_code_exists',
'toplist_options',
'0',
'0',
'free',
'yesno',
310,
0,
1,
'toplist'
),
(
'toplist_use_custom_in_rank_image',
'toplist_options',
'0',
'0',
'free',
'yesno',
320,
0,
1,
'toplist'
),
(
'toplist_custom_in_rank_image_extension',
'toplist_options',
'gif',
'gif',
'free',
'',
330,
0,
1,
'toplist'
),
(
'toplist_count_site_page_views',
'toplist_options',
'0',
'0',
'free',
'yesno',
340,
0,
1,
'toplist'
);

MySQL Error : Duplicate entry '' for key 1
Error Number : 1062
Date : Thursday, June 8th 2006 @ 10:59:38 PM
Script : http://www.xxxxxxxxxxxxxxx/forums/admincp/plugin.php
Referrer : http://www.xxxxxxxxxxxxxx.com/forums...?do=productadd
IP Address : 8xxxxxxxxxxxxx2
Username : xxxxxxxxxxxxxx
Classname : vb_database
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01029 seconds
  • Memory Usage 1,816KB
  • 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_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