BugNET Forums

Forum Support Upgrading probl... 0.7.820 to 0.7.832

4/25/2007 11:48 PM

	icebits
3 posts

0.7.820 to 0.7.832

Error in file:D:\BugNET\Install\dbscripts\0.7.820.0.SqlDataProvider.sql
Message:Cannot find the object "dbo.ProjectRoles" because it does not exist or you do not have permissions.

4/26/2007 6:26 AM

	admin
641 posts
bugnetproject.com

Re: 0.7.820 to 0.7.832

The upgrade should not be running this script. Only the 0.7.832.0 one, what are you doing to arrive at this error?

Davin Dubeau
BugNET - Core Developer

4/26/2007 8:30 AM

	hooper
3 posts

Re: 0.7.820 to 0.7.832

I got the same error when I upgraded.

There was no 0.7.832.0.SqlDataProvider.sql file in the install dbscripts folder only a 0.7.820.0.SqlDataProvider.sql file. So I figured there were no database changes in the new version and just launched the web site.

Was there database chnages?

Thanks

Rick Hubka

4/26/2007 4:16 PM

	admin
641 posts
bugnetproject.com

Re: 0.7.820 to 0.7.832

hooper wrote

I got the same error when I upgraded.

There was no 0.7.832.0.SqlDataProvider.sql file in the install dbscripts folder only a 0.7.820.0.SqlDataProvider.sql file. So I figured there were no database changes in the new version and just launched the web site.

Was there database chnages?

Thanks

Rick Hubka

There was a database script for the version release. It updates the version number in the database. This functionality will be rolled into the installation engine for the next version though.

Davin Dubeau
BugNET - Core Developer

7/4/2007 4:32 AM

	rizvan
6 posts

Re: 0.7.820 to 0.7.832

Installing BugNET

Version: 0.7.832.0

Installation Status Report

Installing Version: 0.7.832.0
Installing Membership Provider... - 00:00:00.0155788
Installing BugNET Database... - 00:00:01.5111436
Installing BugNET Default Data... - 00:00:02.4458716
Error!

Error in file:C:\Site\BugNET\Install\dbscripts\BugNET.Data.SqlDataProvider.sql
Message:Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_Permission'. Cannot insert duplicate key in object 'Permission'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'HostSettings'. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. Add Default Roles & Permissions

Creating Administrator Account... - 00:00:02.7730264

I try to upgrade the 0.7.820 to 0.7.832 the above error occur

Page 1 of 1

Forum

Support

Upgrading probl...

0.7.820 to 0.7.832

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.