ProjectIssueFields table is not created by upgrade but is by fresh install

Topics: Installing BugNET
May 21, 2012 at 10:56 AM

Hello

I have upgraded our BugNet installation from 0.7.921.0 to 0.9.161.0.

Initially there were some issues with the upgrade e.g. the BugNet_ProjectMilestones table did not have a MilestoneCompleted column, and the site was reporting an error with too many arguments to the GetMilestonesByProjectId sproc.

Restoring the database from backup and rerunning the upgrade resolved these issues, however for completeness' sake I ran a fresh install on an empty database and compared the two - the fresh install DB contains a BugNet_ProjectIssueFields table but the upgraded DB does not.

The fresh install DB contains 42 tables compared to 41 in the upgraded DB.

Does this indicate that the upgrade has not completed successfully? The Install.aspx page reported no errors at the time.

Thanks

Daniel

Coordinator
May 22, 2012 at 3:19 PM

This table is not used and should not be in the install script.  It may have gotten there by mistake.