Originally Posted by theArchitect
This is not working for me.
I have now upgraded to Gold and I removed every trace of vBug from my system, and deleted the MySQL tables.
When I install it I get the same error message
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
But now, when I try and go to the vbugs.php page instead of it being blank I get this error
Code:
Database error in vBulletin 3.5.0:
Invalid SQL:
SELECT DISTINCT vbug_severity.title AS svtitle, vbug_type.title AS ttitle, vbug_version.title AS vtitle, vbug_status.title AS stitle, vbug.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname
FROM vbug AS vbug
LEFT JOIN vbug_status AS vbug_status ON (vbug.vbug_statusid = vbug_status.vbug_statusid)
LEFT JOIN user AS admin ON (vbug.adminid = admin.userid)
LEFT JOIN user AS user ON (vbug.userid = user.userid)
LEFT JOIN user AS lastreply ON (vbug.lastreplyuid = lastreply.userid)
LEFT JOIN vbug_type AS vbug_type ON (vbug.vbug_typeid = vbug_type.vbug_typeid)
LEFT JOIN vbug_version AS vbug_version ON (vbug.vbug_versionid = vbug_version.vbug_versionid)
LEFT JOIN vbug_severity AS vbug_severity ON (vbug.vbug_severityid = vbug_severity.vbug_severityid)
WHERE 1
ORDER BY lastedit desc
LIMIT 0,;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 13
Error Number : 1064
Any thoughts would be apprecaited as I would like to have this hack on my board.
|
More Information