Upgrade from 1.5.265 to 1.6.339

Topics: Installing BugNET
Oct 12, 2015 at 8:13 AM
Hi,

I had some issues when upgrading from 1.5.265 to 1.6.339. The install script reported a timeout expired error occured while executing the 1.6.327.0.SqlDataProvider.sql.

I tried to manually execute the queries on sqlServer. It reported some errors (see below) but now the application seems to work properly.

I executed first the 1.6.327.0.SqlDataProvider.sql, then BugNet.Schema.SqlDataProvider.sql, and finaly 1.6.339.0.SqlDataProvider.sql.

Did I miss something in the update procedure?

Best regards.


1.6.327.0.SqlDataProvider.sql

Msg 2601, Level 14, State 1, Line 1
Cannot insert duplicate key row in object 'dbo.BugNet_Languages' with unique index 'IX_BugNet_Languages'. The duplicate key value is (zh-CN).



BugNet.Schema.SqlDataProvider.sql log:

Msg 2627, Level 14, State 1, Line 688

Violation of PRIMARY KEY constraint 'PK_BugNet_HostSettings'. Cannot insert duplicate key in object 'dbo.BugNet_HostSettings'. The duplicate key value is (GoogleClientId).

The statement has been terminated.

Msg 2627, Level 14, State 1, Line 689

Violation of PRIMARY KEY constraint 'PK_BugNet_HostSettings'. Cannot insert duplicate key in object 'dbo.BugNet_HostSettings'. The duplicate key value is (GoogleClientSecret).

The statement has been terminated.

Altering [dbo].[BugNet_DefaultValuesVisibility]...

Msg 2705, Level 16, State 4, Line 696

Column names in each table must be unique. Column name 'StatusEditVisibility' in table 'dbo.BugNet_DefaultValuesVisibility' is specified more than once.

Altering [dbo].[BugNet_DefaultValView]...




1.6.339.0.SqlDataProvider.sql log:

Altering [dbo].[BugNet_ProjectIssueTypes_CanDeleteIssueType]...
Msg 208, Level 16, State 6, Procedure BugNet_ProjectIssueTypes_CanDeleteIssueType, Line 1030
Invalid object name 'dbo.BugNet_ProjectIssueTypes_CanDeleteIssueType'.
Altering [dbo].[BugNet_ProjectPriorities_CanDeletePriority]...
Msg 208, Level 16, State 6, Procedure BugNet_ProjectPriorities_CanDeletePriority, Line 1059
Invalid object name 'dbo.BugNet_ProjectPriorities_CanDeletePriority'.
Altering [dbo].[BugNet_ProjectResolutions_CanDeleteResolution]...
Msg 208, Level 16, State 6, Procedure BugNet_ProjectResolutions_CanDeleteResolution, Line 1088
Invalid object name 'dbo.BugNet_ProjectResolutions_CanDeleteResolution'.
Altering [dbo].[BugNet_ProjectStatus_CanDeleteStatus]...
Msg 208, Level 16, State 6, Procedure BugNet_ProjectStatus_CanDeleteStatus, Line 1117
Invalid object name 'dbo.BugNet_ProjectStatus_CanDeleteStatus'.