0.7.921 to 0.7.942 SQL errors - Upgrading problems

BugNET Forums

Forum

Support

Upgrading probl...

0.7.921 to 0.7.942 SQL errors

6/23/2009 1:29 AM

dmcgiv

Joined: 4/8/2008

Posts: 7

0.7.921 to 0.7.942 SQL errors

Hi,

I've just attempted to upgrade to the final version of 0.7.942 from 0.7.921 but on the install.aspx page I got the errors below. Any help getting this sorted would be appreciated.

Damien

Upgrade Status Report

Upgrading To Version: 0.7.942.0

Running Upgrade Script: 0.7.942.0.SqlDataProvider - 00:00:00.0156001

Error!

Error in file:D:\apps\issue_tracker\BugNET-0.7.942-Install\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:There is already an object named 'FK_Bug_Component' in the database. Could not create constraint. See previous errors.

Error!

Error in file:D:\apps\issue_tracker\BugNET-0.7.942-Install\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 "aurion_issuetracting_bugnet", table "dbo.Version", column 'VersionID'.

Error!

Error in file:D:\apps\issue_tracker\BugNET-0.7.942-Install\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:There is already an object named 'FK_Bug_Priority' in the database. Could not create constraint. See previous errors.

Error!

Error in file:D:\apps\issue_tracker\BugNET-0.7.942-Install\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:There is already an object named 'FK_Bug_Project' in the database. Could not create constraint. See previous errors.

Error!

Error in file:D:\apps\issue_tracker\BugNET-0.7.942-Install\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:There is already an object named 'FK_Bug_Resolution' in the database. Could not create constraint. See previous errors.

Error!

Error in file:D:\apps\issue_tracker\BugNET-0.7.942-Install\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:There is already an object named 'FK_Bug_Status' in the database. Could not create constraint. See previous errors.

Error!

Error in file:D:\apps\issue_tracker\BugNET-0.7.942-Install\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:There is already an object named 'FK_Bug_Type' in the database. Could not create constraint. See previous errors.

Error!

Error in file:D:\apps\issue_tracker\BugNET-0.7.942-Install\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 "aurion_issuetracting_bugnet", table "dbo.aspnet_Users", column 'UserId'.

Upgrade Complete

6/23/2009 4:30 AM

carlowahlstedt

Joined: 1/30/2009

Posts: 33

Re: 0.7.921 to 0.7.942 SQL errors

Looks like you may not have the latest version of the script. I helped Davin test this and these are the same errors I had that he fixed. Make sure your script matches the latest one.

http://bugnet.svn.sourceforge.net/viewvc/bugnet/trunk/BugNET/src/BugNET_WAP/Install/dbscripts/Latest.SqlDataProvider.sql?view=log

6/25/2009 6:10 AM

stickleprojects

Joined: 11/19/2008

Posts: 8

Re: 0.7.921 to 0.7.942 SQL errors

Hi, so the "final" release has patches.. is there a definitive "final" build?

6/25/2009 7:43 AM

admin

bugnetproject.com
Joined: 3/2/2006

Posts: 1007

Re: 0.7.921 to 0.7.942 SQL errors

The final release includes the latest sql script. It is possible that an error occurred cleaning up the data but the script has been tested on a number of installations with no problems.

Davin Dubeau
BugNET - Core Developer
twitter.com/bugnetproject

6/28/2009 2:06 PM

LisaM

Joined: 6/4/2008

Posts: 15

Re: 0.7.921 to 0.7.942 SQL errors

I just downloaded latest release today too and am getting similar list of errors. The link just gives me blank page... no sql script. Help

Page 1 of 4

Forum

Support

Upgrading probl...

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.