Bugzilla Update - "Resolution" gone
 

I recently updated an old Bugzilla system we have from 2.28 to 3.2.4 that went through fairly smoothly. However, there is one small issue that has appeared.

When a bug is filed I can no longer change the "Resolution" for an issue. The Status can be changed, but the Resolution dropdown is no longer there.
I have gone into the database and all the old bugs have their resolutions, but the dropdown is not visible for them either.

When I run a Bugzilla Sanity Check I get an error message stating "Bugs with open status and a resolution:..." then shows all the previously closed bugs.

Has anyone experienced anything similar?

If you haven't already done so, you need to go to the bugzilla portion of mozilla.org, get on the bugzilla support list there, and ask this question there.

I ended up finding the resolution by nosing through the database schema at Ravenbrook. It fixed my problem but I'll post the fix here in case anyone has a similar problem.

The problem lay that in the new version, in the "bug_status" table there is a new column called "is_open". When the old database was converted it added a "1" to each row. This needed to be changed to "0" for all bugs considered closed ("Resolved", "Verified" and "Closed"). Once this was changed, the resolution drop-down menu appeared and was populated with the list of resolutions. This also resolved the issue with the Sanity Check error messages.

For reference, the schema I used was;
http://www.ravenbrook.com/project/p4...-bug_status-id