Ok small problem, just installed, i had the previous version already installed on my previous version of vb, so i want to keep all existing warn data, so i assume i don't delete existing tables etc...
I got this error when importing the product:
Code:
Database error in vBulletin 3.5.4:
Invalid SQL:
INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'warn_hierarchical',
'warning',
'1',
'1',
'free',
'yesno',
2,
0,
1,
'aws'
),
(
'warn_automatic',
'warning',
'0',
'1',
'free',
'yesno',
3,
0,
1,
'aws'
),
(
'warn_automaticpm',
'warning',
'0',
'0',
'free',
'yesno',
4,
0,
1,
'aws'
),
(
'warn_autocomments',
'warning',
'0',
'0',
'free',
'yesno',
5,
0,
1,
'aws'
),
(
'warn_automatic_warner',
'warning',
'11223',
'1',
'free',
'',
6,
0,
1,
'aws'
),
(
'warn_warner',
'warning',
'0',
'0',
'free',
'',
7,
0,
1,
'aws'
),
(
'warn_collector',
'warning',
'1',
'1',
'free',
'',
8,
0,
1,
'aws'
),
(
'warn_banned_limit',
'warning',
'7',
'7',
'free',
'',
9,
0,
1,
'aws'
),
(
'warn_points_before_banned',
'warning',
'90',
'10',
'free',
'',
10,
0,
1,
'aws'
),
(
'warn_warnings_before_banned',
'warning',
'3',
'10',
'free',
'',
11,
0,
1,
'aws'
),
(
'warn_banned_usergroup_id',
'warning',
'8',
'8',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">(COPPA) Users Awaiting Moderation(id4)</option>\r\n<option value=\\\"6\\\" \" . iif($setting[\'value\']==\'6\',\'selected=\"selected\"\') . \">Administrators(id6)</option>\r\n<option value=\\\"7\\\" \" . iif($setting[\'value\']==\'7\',\'selected=\"selected\"\') . \">Moderators(id7)</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==\'2\',\'selected=\"selected\"\') . \">Registered Users(id2)</option>\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==\'5\',\'selected=\"selected\"\') . \">Super Moderators(id5)</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==\'1\',\'selected=\"selected\"\') . \">Unregistered / Not Logged In(id1)</option>\r\n<option value=\\\"4\\\" \" . iif($setting[\'value\']==\'4\',\'selected=\"selected\"\') . \">Users Awaiting Email Confirmation(id3)</option>\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">Banned Users(id8)</option>\r\n<option value=\\\"9\\\" \" . iif($setting[\'value\']==\'9\',\'selected=\"selected\"\') . \">Permanent_Ban(id9)</option>\r\n</select>',
12,
0,
1,
'aws'
),
(
'warn_protected_usergroups',
'warning',
'6',
'',
'free',
'',
13,
0,
1,
'aws'
),
(
'warn_troll_usergroup_id',
'warning',
'8',
'9',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">(COPPA) Users Awaiting Moderation(id4)</option>\r\n<option value=\\\"6\\\" \" . iif($setting[\'value\']==\'6\',\'selected=\"selected\"\') . \">Administrators(id6)</option>\r\n<option value=\\\"7\\\" \" . iif($setting[\'value\']==\'7\',\'selected=\"selected\"\') . \">Moderators(id7)</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==\'2\',\'selected=\"selected\"\') . \">Registered Users(id2)</option>\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==\'5\',\'selected=\"selected\"\') . \">Super Moderators(id5)</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==\'1\',\'selected=\"selected\"\') . \">Unregistered / Not Logged In(id1)</option>\r\n<option value=\\\"4\\\" \" . iif($setting[\'value\']==\'4\',\'selected=\"selected\"\') . \">Users Awaiting Email Confirmation(id3)</option>\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">Banned Users(id8)</option>\r\n<option value=\\\"9\\\" \" . iif($setting[\'value\']==\'9\',\'selected=\"selected\"\') . \">Permanent_Ban(id9)</option>\r\n</select>',
14,
0,
1,
'aws'
),
(
'warn_restore_groupid',
'warning',
'0',
'2',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">(COPPA) Users Awaiting Moderation(id4)</option>\r\n<option value=\\\"6\\\" \" . iif($setting[\'value\']==\'6\',\'selected=\"selected\"\') . \">Administrators(id6)</option>\r\n<option value=\\\"7\\\" \" . iif($setting[\'value\']==\'7\',\'selected=\"selected\"\') . \">Moderators(id7)</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==\'2\',\'selected=\"selected\"\') . \">Registered Users(id2)</option>\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==\'5\',\'selected=\"selected\"\') . \">Super Moderators(id5)</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==\'1\',\'selected=\"selected\"\') . \">Unregistered / Not Logged In(id1)</option>\r\n<option value=\\\"4\\\" \" . iif($setting[\'value\']==\'4\',\'selected=\"selected\"\') . \">Users Awaiting Email Confirmation(id3)</option>\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">Banned Users(id8)</option>\r\n<option value=\\\"9\\\" \" . iif($setting[\'value\']==\'9\',\'selected=\"selected\"\') . \">Permanent_Ban(id9)</option>\r\n</select>',
15,
0,
1,
'aws'
),
(
'warn_incr_ban_days',
'warning',
'1',
'1',
'free',
'yesno',
16,
0,
1,
'aws'
),
(
'warn_max_no_bans',
'warning',
'3',
'3',
'free',
'',
17,
0,
1,
'aws'
),
(
'warn_bans_mature',
'warning',
'0',
'0',
'free',
'',
18,
0,
1,
'aws'
),
(
'warn_viewoption',
'warning',
'Mgm',
'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,
'aws'
),
(
'warn_multiple_per_post',
'warning',
'0',
'1',
'free',
'yesno',
20,
0,
1,
'aws'
),
(
'warn_send_em_warning',
'warning',
'1',
'1',
'free',
'yesno',
21,
0,
1,
'aws'
),
(
'warn_send_pm_warning',
'warning',
'1',
'0',
'free',
'yesno',
22,
0,
1,
'aws'
),
(
'warn_email_on_ban',
'warning',
'1',
'1',
'free',
'yesno',
23,
0,
1,
'aws'
),
(
'warn_historical',
'warning',
'1',
'1',
'free',
'yesno',
24,
0,
1,
'aws'
),
(
'warn_allowoffpost',
'warning',
'1',
'1',
'free',
'yesno',
25,
0,
1,
'aws'
),
(
'warn_warnings_per_page',
'warning',
'0',
'15',
'free',
'',
26,
0,
1,
'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,
'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,
'aws'
),
(
'warn_sig_thresshold',
'warning',
'0',
'0',
'free',
'',
29,
0,
1,
'aws'
),
(
'warn_avatar_thresshold',
'warning',
'0',
'0',
'free',
'',
30,
0,
1,
'aws'
),
(
'warn_aprotected_usergroups',
'warning',
'',
'',
'free',
'',
31,
0,
1,
'aws'
),
(
'warn_pmcutoff',
'warning',
'0',
'0',
'free',
'',
32,
0,
1,
'aws'
),
(
'warn_admingroups',
'warning',
'6',
'',
'free',
'',
33,
0,
1,
'aws'
),
(
'warn_smodgroups',
'warning',
'5',
'',
'free',
'',
34,
0,
1,
'aws'
),
(
'warn_modgroups',
'warning',
'7',
'',
'free',
'',
35,
0,
1,
'aws'
),
(
'warn_includepost',
'warning',
'1',
'0',
'free',
'yesno',
36,
0,
1,
'aws'
),
(
'warn_savecopy',
'warning',
'1',
'0',
'free',
'yesno',
37,
0,
1,
'aws'
),
(
'warn_savecopyalert',
'warning',
'1',
'0',
'free',
'yesno',
38,
0,
1,
'aws'
),
(
'warn_savecopyforum',
'warning',
'166',
'',
'free',
'',
39,
0,
1,
'aws'
),
(
'warn_allowalerts',
'warning',
'1',
'0',
'free',
'yesno',
40,
0,
1,
'aws'
),
(
'warn_allowalertscomment',
'warning',
'1',
'0',
'free',
'yesno',
41,
0,
1,
'aws'
),
(
'warn_alertslifetime',
'warning',
'30',
'0',
'free',
'',
42,
0,
1,
'aws'
),
(
'warn_allownotes',
'warning',
'1',
'1',
'free',
'yesno',
43,
0,
1,
'aws'
),
(
'warn_version',
'warning',
'3.4.16',
'3.5.4',
'free',
'',
44,
0,
1,
'aws'
);
MySQL Error : Duplicate entry 'warn_hierarchical' for key 1
Error Number : 1062
Date : Saturday, August 5th 2006 @ 11:16:40 AM
Script : http://www.majorfm.com/forum/admincp/plugin.php
Referrer : http://www.majorfm.com/forum/admincp...?do=productadd
IP Address : 82.25.***.***
Username : AJ
Classname : vb_database
Please advise what do to, in done everything else but see no changes on my forum!
|
More Information