Database error in vBulletin 3.8.4:
Invalid SQL:
INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder,
advanced, volatile, validationcode, blacklist, product)
VALUES
(
'forumhomedepth',
'forumlist',
'2',
'2',
'integer',
'',
10,
0,
1,
'',
0,
'vbulletin'
),
(
'forumdisplaydepth',
'forumlist',
'2',
'2',
'integer',
'',
15,
0,
1,
'',
0,
'vbulletin'
),
(
'subforumdepth',
'forumlist',
'4',
'0',
'integer',
'',
20,
0,
1,
'',
0,
'vbulletin'
),
(
'showforumdescription',
'forumlist',
'1',
'1',
'boolean',
'yesno',
25,
0,
1,
'',
0,
'vbulletin'
),
(
'showprivateforums',
'forumlist',
'0',
'0',
'free',
'select:piped\r\n0|no\r\n1|yes_hide_post_counts\r\n2|yes_display_post_counts',
30,
0,
1,
'',
0,
'vbulletin'
),
(
'showlocks',
'forumlist',
'0',
'',
'boolean',
'yesno',
40,
0,
1,
'',
0,
'vbulletin'
),
(
'lastthreadchars',
'forumlist',
'30',
'30',
'integer',
'',
50,
0,
1,
'',
0,
'vbulletin'
),
(
'showmoderatorcolumn',
'forumlist',
'0',
'',
'boolean',
'yesno',
70,
0,
1,
'',
0,
'vbulletin'
),
(
'showprefixlastpost',
'forumlist',
'2',
'2',
'number',
'radio:piped\r\n0|no\r\n1|yes_plain_text_version\r\n2|yes_rich_text_version',
80,
0,
1,
'',
0,
'vbulletin'
);
MySQL Error : Duplicate entry 'subforumdepth' for key 1
Error Number : 1062
Request Date : Wednesday, August 12th 2009 @ 08:51:08 PM
Error Date : Wednesday, August 12th 2009 @ 08:51:08 PM
Script : http://www.mylionz.com/forums2/install/finalupgrade.php?step=1
Referrer : http://www.mylionz.com/forums2/install/finalupgrade.php
IP Address : 41.237.209.53
Username :
Classname : vB_Database
MySQL Version : 4.1.22-standard