0017700: Implement admin tool to fix issues with broken categories - MantisBT

ID	Project	Category	View Status	Date Submitted	Last Update

0017700	mantisbt	bugtracker	public	2014-09-23 07:38	2014-11-20 16:54

Reporter	dregad	Assigned To	vboctor
Priority	low	Severity	feature	Reproducibility	N/A
Status	closed	Resolution	won't fix
OS	Windows	OS Version	7

Summary	0017700: Implement admin tool to fix issues with broken categories
Description	As mentioned in 0015420:0041297, it would be good to provide administrators with a means to fix issues caused by missing categories without having to rely on direct SQL manipulation of MantisBT schema. The tool should be able to do what is described in the Admin Guide's troubleshooting section [1]. [1] http://mantisbt.org/docs/master-1.2.x/en/administration_guide/admin.troubleshooting.html#ADMIN.TROUBLESHOOTING.ERRORS.1502
Tags	No tags attached.

vboctor 2014-10-24 23:32 manager ~0041651	I'm closing this as won't fix in favor of the fix that I have in the pull request below. If we don't agree that is enough to address the issue, we can re-open this issue: https://github.com/mantisbt/mantisbt/pull/519

dregad 2014-11-04 06:44 developer ~0041759	In terms of the the process to fix broken issues following resolution of 0015420: I confirmed that this can be done from the view issues page, selecting issues with a @xxx@ category and use the "Update Category" group action, effectively replacing the need of a specific admin tool. The only (usability) issue is that it is currently not possible to filter these invalid categories as they do not appear in the selection list; advanced filters are not useful either, because we can't do "negative" filters. So the only option/workaround is to use sorting on Category column. Not great in terms of user friendliness, but I guess it's acceptable.