Thread: Chat Modifications - Cyb - ChatBox
View Single Post
  #162  
Old 10-21-2007, 04:49 PM
P.Jackson P.Jackson is offline
 
Join Date: Sep 2003
Location: Newcastle,Uk
Posts: 170
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I get this error when i import the xml file
Code:
Database error in vBulletin 3.6.8:

Invalid SQL:

                INSERT INTO setting
                    (varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
                VALUES
                    (
                    'cybchatbox_enable_product',
                    'cybcboptions',
                    '1',
                    '1',
                    'boolean',
                    'yesno',
                    1,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_box_style',
                    'cybcboptions',
                    '1',
                    '1',
                    'free',
                    'select:piped\r\n1|tcat\r\n2|thead',
                    5,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_messages_main',
                    'cybcboptions',
                    '30',
                    '30',
                    'number',
                    '',
                    10,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_archive_perpage',
                    'cybcboptions',
                    '25',
                    '25',
                    'number',
                    '',
                    15,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_reverse_messages',
                    'cybcboptions',
                    '0',
                    '0',
                    'boolean',
                    'yesno',
                    20,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_auto_refresh_messages',
                    'cybcboptions',
                    '10',
                    '10',
                    'number',
                    '',
                    25,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_auto_refresh_guests',
                    'cybcboptions',
                    '0',
                    '0',
                    'boolean',
                    'yesno',
                    30,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_smiliestotal',
                    'cybcboptions',
                    '1',
                    '1',
                    'number',
                    '',
                    35,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_smiliesinit',
                    'cybcboptions',
                    '10',
                    '10',
                    'number',
                    '',
                    40,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_smiliesperrow',
                    'cybcboptions',
                    '5',
                    '5',
                    'free',
                    'select:piped\r\n1|1\r\n3|3\r\n5|5\r\n7|7\r\n9|9\r\n11|11\r\n13|13\r\n15|15',
                    45,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_smiliesclip',
                    'cybcboptions',
                    '30',
                    '30',
                    'number',
                    '',
                    50,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_clickable_links',
                    'cybcboptions',
                    '1',
                    '1',
                    'boolean',
                    'yesno',
                    55,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_viewers_timecut',
                    'cybcboptions',
                    '10',
                    '10',
                    'number',
                    '',
                    60,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_auto_refresh_users',
                    'cybcboptions',
                    '30',
                    '30',
                    'number',
                    '',
                    65,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_script_locs',
                    'cybcboptions',
                    'index',
                    'index',
                    'free',
                    '',
                    70,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_page_loc',
                    'cybcboptions',
                    '1',
                    '1',
                    'free',
                    'select:piped\r\n0|Disabled\r\n1|Below NavBar\r\n2|Above Footer',
                    75,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_excluded_groups',
                    'cybcboptions',
                    '1,8',
                    '1,8',
                    'free',
                    '',
                    80,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_excluded_users',
                    'cybcboptions',
                    '',
                    '',
                    '',
                    'textarea',
                    85,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_topx_results',
                    'cybcboptions',
                    '5',
                    '5',
                    'number',
                    '',
                    90,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_stats_lastxhours',
                    'cybcboptions',
                    '12',
                    '12',
                    'number',
                    '',
                    95,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_newmess_dur',
                    'cybcboptions',
                    '10',
                    '10',
                    'number',
                    '',
                    100,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_height',
                    'cybcboptions',
                    '100',
                    '100',
                    'number',
                    '',
                    105,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_height_full',
                    'cybcboptions',
                    '400',
                    '400',
                    'number',
                    '',
                    110,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_dateformat',
                    'cybcboptions',
                    'd-m',
                    'd-m',
                    'free',
                    '',
                    115,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_timeformat',
                    'cybcboptions',
                    'H:i',
                    'H:i',
                    'free',
                    '',
                    120,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_icon_new',
                    'cybcboptions',
                    'images/statusicon/post_new.gif',
                    'images/statusicon/post_new.gif',
                    'free',
                    '',
                    125,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_icon_old',
                    'cybcboptions',
                    'images/statusicon/post_old.gif',
                    'images/statusicon/post_old.gif',
                    'free',
                    '',
                    130,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_mecolor',
                    'cybcboptions',
                    'Red',
                    'Red',
                    'free',
                    '',
                    135,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_belownote',
                    'cybcboptions',
                    '1',
                    '1',
                    'number',
                    'yesno',
                    140,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_belownote',
                    'cybcboptions',
                    '1',
                    '1',
                    'number',
                    'yesno',
                    145,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_auto_prune',
                    'cybcboptions',
                    '',
                    '',
                    'free',
                    '',
                    150,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_collapsed_always',
                    'cybcboptions',
                    '0',
                    '0',
                    'boolean',
                    'yesno',
                    155,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    ),
    (
                    'cybchatbox_autoinsertlink',
                    'cybcboptions',
                    '1',
                    '1',
                    'boolean',
                    'yesno',
                    160,
                    0,
                    1,
                    '',
                    0,
                    'cybchatbox'
    );

MySQL Error  : Duplicate entry 'cybchatbox_belownote' for key 1
Error Number : 1062
Date         : Sunday, October 21st 2007 @ 06:47:31 PM
Script       : http://www.clan-killers.com/forum/admincp/plugin.php?do=productimport
Referrer     : http://www.clan-killers.com/forum/admincp/plugin.php?do=productadd
IP Address   : xxxxxxx
Username     : xxxxxxx
Classname    : vb_database
Could you tell me whats wrong here or what do i need to do ?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01123 seconds
  • Memory Usage 1,843KB
  • 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