I am getting this error when I install the product.
Code:
Database error in vBulletin 3.5.0 Release Candidate 3:
Invalid SQL:
INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'vbug_bugsperpage',
'vbug',
'15',
'15',
'number',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==5,\'selected=\"selected\"\') . \">5</option>\r\n<option value=\\\"10\\\" \" . iif($setting[\'value\']==10,\'selected=\"selected\"\') . \">10</option>\r\n<option value=\\\"15\\\" \" . iif($setting[\'value\']==15,\'selected=\"selected\"\') . \">15</option>\r\n<option value=\\\"20\\\" \" . iif($setting[\'value\']==20,\'selected=\"selected\"\') . \">20</option>\r\n</select>',
10,
0,
1,
'vBug'
),
(
'vbug_status',
'vbug',
'1',
'1',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\" . eval(\'$states = $vbulletin->db->query_read(\"SELECT vbug_statusid, title FROM \" . TABLE_PREFIX . \"vbug_status\");\r\nwhile ($state = $vbulletin->db->fetch_array($states))\r\n{\r\n $options .= \"<option value=\\\"$state[vbug_statusid]\\\" \" . iif($setting[\\\'value\\\']==$state[\\\'vbug_statusid\\\'],\\\'selected=\"selected\"\\\') . \">$state[title]</option>\";\r\n}\r\nreturn $options;\') . \"</select>',
20,
0,
1,
'vBug'
),
(
'vbug_bug_moderate',
'vbug',
'0',
'0',
'boolean',
'yesno',
30,
0,
1,
'vBug'
),
(
'vbug_versionname',
'vbug',
'vBug',
'vBug',
'',
'',
40,
0,
1,
'vBug'
),
(
'vbug_admin_legend',
'vbug',
'1',
'1',
'boolean',
'yesno',
50,
0,
1,
'vBug'
);
MySQL Error : Duplicate entry 'vbug_status' for key 1
Error Number : 1062
I intially thought that it was because I use to run the bug tracker under 3.0 so I went in and removed all of the vbug tables from the DB and then tried the install again and got the same error.