[Dark_Wizard]

Originally Posted by theArchitect

I am sorry, I wasn't doubting the competency of your coding and certainly not insinuating that there was something wrong with your product. But there is clearly a problem with the way in which my board is processing this hack (I should add that I have installed this onto a fresh test board with no problems at all. It just won't work on my live board).

I have used the product manager to uninstall this hack and then re-installed it using the overwrite option. but am still getting the same error:

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 was merely wondering if you might have had a solution to get around this problem so that I could use your excellent system.

I can help if you provide the following in a PM:

• * admincp access
  * mysql access
  * url where the hack is used