BugNET

Open source issue tracking & project management
Welcome to BugNET Register | Login |
  Search

BugNET Forums

 
ForumForumDevelopmentDevelopmentGeneral develop...General develop...Testing on 0.7.932 (0.7 Final) Release CandidateTesting on 0.7.932 (0.7 Final) Release Candidate
Previous Previous
 
Next Next
New Post
 5/6/2009 7:15 PM
 
User is offline admin
1st Level Poster

admin's Avatar

bugnetproject.com
Joined: 3/2/2006
Posts: 1007
 Modified By admin on 5/6/2009 7:21:07 PM

There is a new release candidate that I would like anyone that has the time to try.  This install upgrades the live BugNET site successfully but I need more broad testing.  Please post back your upgrade findings.  Note that this upgrade doesn't handle custom modifications to the application.

BugNET-0.7.936-Install.zip

Upgrade Notes:

  • Upgrade will delete all issues for projects that have been deleted.
  • If a milestone doesn't exist milestone is set to the latest milestone for that project.
  • If fixed in version doesn't exist , the fixed in version is set to null.
  • All user tagged records that no longer exist will be set to the admin user. (edit the latest db script to change this value to another user)
  • If category has been deleted the category is set to the latest for that project.
  • All notification subscriptions are deleted for users that do not exist.

Davin Dubeau
BugNET - Core Developer
twitter.com/bugnetproject

New Post
 5/7/2009 3:30 AM
 
User is offline smoss
4th Level Poster

www.orbitsolutions.co.za
Joined: 3/14/2007
Posts: 235

I took our copy and staged it on my machine. And performed an upgrade via "/install/install.aspx"

Here are the errors:

Upgrading To Version: 0.7.936.0


Running Upgrade Script: 0.7.936.0.SqlDataProvider - 00:00:00.0625000
Error!

Error in file:C:\Inetpub\wwwroot\BugNET-0.7.936-Install\BugNET\Install\dbscripts\0.7.936.0.SqlDataProvider.sql
Message:The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_UserProjects_Project". The conflict occurred in database "BUGNET", table "dbo.Project", column 'ProjectID'.


Error!

Error in file:C:\Inetpub\wwwroot\BugNET-0.7.936-Install\BugNET\Install\dbscripts\0.7.936.0.SqlDataProvider.sql
Message:The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Bug_aspnet_Users". The conflict occurred in database "BUGNET", table "dbo.aspnet_Users", column 'UserId'.


Error!

Error in file:C:\Inetpub\wwwroot\BugNET-0.7.936-Install\BugNET\Install\dbscripts\0.7.936.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\wwwroot\BugNET-0.7.936-Install\BugNET\Install\dbscripts\0.7.936.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\wwwroot\BugNET-0.7.936-Install\BugNET\Install\dbscripts\0.7.936.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\wwwroot\BugNET-0.7.936-Install\BugNET\Install\dbscripts\0.7.936.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\wwwroot\BugNET-0.7.936-Install\BugNET\Install\dbscripts\0.7.936.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\wwwroot\BugNET-0.7.936-Install\BugNET\Install\dbscripts\0.7.936.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'.

Follow me on twitter: @stewartmoss http://www.twitter.com/stewartmoss
New Post
 5/7/2009 5:14 AM
 
User is offline admin
1st Level Poster

admin's Avatar

bugnetproject.com
Joined: 3/2/2006
Posts: 1007

Can you try running the upgrade sript - 0.7.936.0.SqlDataProvider.sql directly against your database and see what output you get.

Davin Dubeau
BugNET - Core Developer
twitter.com/bugnetproject

New Post
 5/7/2009 9:20 AM
 
User is offline smoss
4th Level Poster

www.orbitsolutions.co.za
Joined: 3/14/2007
Posts: 235

K will do so at work tommorrow.  I will email you the results so keep a look out for my email.

Later

Stewart

Follow me on twitter: @stewartmoss http://www.twitter.com/stewartmoss
New Post
 5/8/2009 1:27 AM
 
User is offline BC
No Ranking

Joined: 11/8/2006
Posts: 51

I was able to update without any script errors,

but now i can't login anymore
 Page 2 of 3
Previous123Next 
Previous Previous
 
Next Next
ForumForumDevelopmentDevelopmentGeneral develop...General develop...Testing on 0.7.932 (0.7 Final) Release CandidateTesting on 0.7.932 (0.7 Final) Release Candidate

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.
Copyright 2010 BugNET   Terms Of Use  Privacy Statement  Page generated in 0.156251 seconds.