BugNET

Davin has asked me (and probably others) to test his Release Candidate of 0.7.932 which will be the final release for 0.7 branch.

Our system has several differences over the traditional BugNET installation.
1. We have customized our status fields and removed autonumbering off a few of these types of tables.
2. We have merged users in the system (using a script I released on the forum). I could have left something out.

I did experience some FK (foreign key) problems with upgrading my database with over 1000 real life issues in it.

Davin is aware of my problem and him and I are co-ordinating. (I did not muck up the production database)

The latest Tweet from BugNET says...

Mar 12, 2009 9:09 PM - just testing the database migration scripts...some work to do dealing with potential orphaned records from previous releases

Anybody else do something different to their BugNET and wanna test?

---

Follow me on twitter: @stewartmoss http://www.twitter.com/stewartmoss
Follow BugNETProject on twitter: @bugnetproject http://www.twitter.com/bugnetproject

I have tryed to update my BugNET installation (in a test invorenment) and recieved the error below.

The only thing I have changed at the database is the following:
I have added a intiger field to the 'version' table used to indicate wheter that version is released (value 1) or not.
This value can be set through a webpage, which then also sends a e-mail to the user informing them there is an update.

Now the atual error message:

Upgrading To Version: 0.7.932.0

Running Upgrade Script: 0.7.921.0.SqlDataProvider - 00:00:00.0312500
Error!

Error in file:F:\BugNET\Install\dbscripts\0.7.921.0.SqlDataProvider.sql
Message:'FK_Bug_Component' is not a constraint. Could not drop constraint. See previous errors.


Error!

Error in file:F:\BugNET\Install\dbscripts\0.7.921.0.SqlDataProvider.sql
Message:Cannot drop the procedure 'dbo.chObjOwner', because it does not exist or you do not have permission.


Running Upgrade Script: 0.7.932.0.SqlDataProvider - 00:00:01
Error!

Error in file:F:\BugNET\Install\dbscripts\0.7.932.0.SqlDataProvider.sql
Message:The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Bug_Component". The conflict occurred in database "BugNet", table "dbo.Component", column 'ComponentID'.


Error!

Error in file:F:\BugNET\Install\dbscripts\0.7.932.0.SqlDataProvider.sql
Message:The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Bug_FixedInVersionId". The conflict occurred in database "BugNet", table "dbo.Version", column 'VersionID'.

Upgrade Complete

The biggest challenge of this migration is to handle users that have been deleted where their userid is tagged through out the database.

I think the main approach to solving this issue will be to create a new dummy user and change all the user ids for records to this user.  This may include history records, notifications, bugs etc.

---

Davin Dubeau