BugNET

Open source issue tracking & project management

Forums

HomeHomeSupportSupportUpgrading BugNE...Upgrading BugNE...0.7.921 to 0.7.942 SQL errors 0.7.921 to 0.7.942 SQL errors
Previous
 
Next
New Post
8/20/2009 6:54 AM
 

I downloaded the 0.7.942 installer just a short while ago and ran it against my .0.7.921installation and recieved the same errors. As you can see it says the upgrade is complete, but one it is done I cannot access the host settings in the administration area.

Any ideas on what I can do  to fix this?

Upgrading BugNET
Upgrade Status Report
 
Upgrading To Version: 0.7.942.0

Running Upgrade Script: 0.7.942.0.SqlDataProvider - 00:00:00.0156255
Error!

Error in file:C:\inetpub\BugNET\Install\dbscripts\0.7.942.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'.


Error!

Error in file:C:\inetpub\BugNET\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Bug_Project". The conflict occurred in database "BugNET", table "dbo.Project", column 'ProjectID'.


Error!

Error in file:C:\inetpub\BugNET\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Bug_ProjectID". The conflict occurred in database "BugNET", table "dbo.Project", column 'ProjectID'.


Error!

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


Error!

Error in file:C:\inetpub\BugNET\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_UserRoles_aspnet_Users". The conflict occurred in database "BugNET", table "dbo.aspnet_Users", column 'UserId'.


Error!

Error in file:C:\inetpub\BugNET\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_BugAttachment_aspnet_Users". The conflict occurred in database "BugNET", table "dbo.aspnet_Users", column 'UserId'.


Error!

Error in file:C:\inetpub\BugNET\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_BugTimeEntry_aspnet_Users". The conflict occurred in database "BugNET", table "dbo.aspnet_Users", column 'UserId'.


Error!

Error in file:C:\inetpub\BugNET\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_BugNotification_aspnet_Users". The conflict occurred in database "BugNET", table "dbo.aspnet_Users", column 'UserId'.


Error!

Error in file:C:\inetpub\BugNET\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_BugHistory_aspnet_Users". The conflict occurred in database "BugNET", table "dbo.aspnet_Users", column 'UserId'.


Error!

Error in file:C:\inetpub\BugNET\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_BugComment_aspnet_Users". The conflict occurred in database "BugNET", table "dbo.aspnet_Users", column 'UserId'.

Upgrade Complete
 
New Post
8/21/2009 2:15 PM
 

I have been able to correct this issue in my instance. I manually ran some data cleanup scripts to remove all the orphaned data in the different tables (we had deleted some users and projects). Once that was complete I was able to run the upgrade successfully.

 
Previous
 
Next
HomeHomeSupportSupportUpgrading BugNE...Upgrading BugNE...0.7.921 to 0.7.942 SQL errors 0.7.921 to 0.7.942 SQL errors


Forum Policy

These Discussion Forums are dedicated to the discussion of the BugNET issue tracker.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising.
2. No Flaming or Trolling.
3. No Profanity, Racism, or Prejudice.
4. Site Moderators have the final word on approving/removing a thread or post or comment.
5. English language posting only, please.