[zero-g]

i have this same problem. has it been resolved? or know of solution?

Originally Posted by P.Jackson

I get this error when i import the xml file

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 ?