[Dark_Wizard]

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

 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

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.

This has been tested on 3 boards that were RC3 and upgraded with no issues. Also to uninstall this you should have gone through the Plugin System -> Manage Products....my suggestion is to install and then uninstall then install again and see what happens.