.7 beta to .7.820 - Upgrading problems

BugNET Forums

Forum Support Upgrading probl... .7 beta to .7.820

3/26/2007 3:30 AM

	glanotte
4 posts

.7 beta to .7.820

got this error during install

Error!

Error in file:e:\inetpub\wwwroot\bugnet\Install\dbscripts\0.7.820.0.SqlDataProvider.sql
Message:Column already has a DEFAULT bound to it. Could not create constraint. See previous errors.

It then says the install is complete, when I attempt to go to the site... error, here is the info:

AllowAttachments

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: AllowAttachments

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[IndexOutOfRangeException: AllowAttachments] System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +1358343 System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +102 System.Data.SqlClient.SqlDataReader.get_Item(String name) +12 BugNET.DataAccessLayer.GenericDataAccessLayer.GetPublicProjects() +603 [ApplicationException: An error has occured in accessing the database] BugNET.DataAccessLayer.GenericDataAccessLayer.GetPublicProjects() +776 BugNET._Default.Page_Load(Object sender, EventArgs e) +112 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34 System.Web.UI.Control.OnLoad(EventArgs e) +99 BugNET.UserInterfaceLayer.BasePage.OnLoad(EventArgs e) +9 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

have fun, I feel your pain

3/26/2007 3:42 AM

	glanotte
4 posts

Re: .7 beta to .7.820

Ran the sql directly against the db, here is the output:

Dropping foreign keys from [dbo].[ProjectRoles]

Dropping foreign keys from [dbo].[BugAttachment]

Dropping foreign keys from [dbo].[ProjectCustomFieldSelection]

Dropping foreign keys from [dbo].[BugTimeEntry]

Dropping foreign keys from [dbo].[Bug]

Dropping foreign keys from [dbo].[Version]

Dropping foreign keys from [dbo].[RelatedBug]

Dropping foreign keys from [dbo].[RolePermission]

Dropping foreign keys from [dbo].[BugComment]

Dropping foreign keys from [dbo].[ProjectCustomFields]

Dropping foreign keys from [dbo].[BugNotification]

Dropping foreign keys from [dbo].[ProjectMailBox]

Dropping foreign keys from [dbo].[ProjectCustomFieldValues]

Dropping foreign keys from [dbo].[BugHistory]

Dropping constraints from [dbo].[RolePermission]

Dropping constraints from [dbo].[ProjectRoles]

Dropping [dbo].[BugNet_Role_RemoveRoleFromProject]

Dropping [dbo].[BugNet_Role_AddRoleToProject]

Dropping [dbo].[ProjectRoles]

Creating [dbo].[UserRoles]

Creating primary key [PK_UserRoles] on [dbo].[UserRoles]

Creating [dbo].[Roles]

Creating primary key [PK_Roles] on [dbo].[Roles]

Creating [dbo].[BugNet_Role_CreateNewRole]

Rebuilding [dbo].[RolePermission]

Caution: Changing any part of an object name could break scripts and stored procedures.

Creating primary key [PK_RolePermission] on [dbo].[RolePermission]

Creating [dbo].[BugNet_Role_DeleteRole]

Creating [dbo].[BugNet_Role_GetRoleById]

Altering [dbo].[BugNet_Permission_GetRolePermission]

Creating [dbo].[BugNet_Role_UpdateRole]

Altering [dbo].[BugNet_Permission_DeleteRolePermission]

Creating [dbo].[BugNet_Role_RoleHasPermission]

Creating [dbo].[BugNet_Role_GetAllRoles]

Altering [dbo].[BugNet_CustomField_DeleteCustomField]

Altering [dbo].[BugNet_Permission_AddRolePermission]

Creating [dbo].[BugNet_Role_RoleExists]

Altering [dbo].[BugNet_Role_GetRolesByProject]

Altering [dbo].[Bug]

Creating [dbo].[BugNet_Role_GetProjectRolesByUser]

Altering [dbo].[BugNet_Role_GetRolesByUser]

Altering [dbo].[BugNet_Permission_GetPermissionsByRole]

Altering [dbo].[Project]

Creating [dbo].[BugNet_Role_IsUserInRole]

Creating [dbo].[BugNet_Role_RemoveUserFromRole]

Creating [dbo].[BugNet_Role_AddUserToRole]

Altering [dbo].[BugNet_Bug_GetRoadMap]

Altering [dbo].[BugNet_Attachment_CreateNewAttachment]

Altering [dbo].[BugNet_BugNotification_CreateNewBugNotification]

Altering [dbo].[BugsView]

Altering [dbo].[BugNet_Project_GetAllProjects]

Altering [dbo].[BugNet_Project_GetProjectById]

Altering [dbo].[BugNet_Project_GetPublicProjects]

Altering [dbo].[BugNet_Project_GetProjectByCode]

Altering [dbo].[BugNet_Project_UpdateProject]

Altering [dbo].[BugNet_Project_GetProjectsByUserName]

Altering [dbo].[BugNet_Project_CreateNewProject]

Adding constraints to [dbo].[Bug]

Msg 1781, Level 16, State 1, Line 1

Column already has a DEFAULT bound to it.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

(1 row(s) affected)

Adding foreign keys to [dbo].[Bug]

Msg 2714, Level 16, State 4, Line 1

There is already an object named 'FK_Bug_Project' in the database.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

(1 row(s) affected)

Adding foreign keys to [dbo].[Component]

Adding foreign keys to [dbo].[ProjectMailBox]

Msg 2714, Level 16, State 4, Line 1

There is already an object named 'FK_ProjectMailBox_Project' in the database.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

(1 row(s) affected)

Adding foreign keys to [dbo].[RolePermission]

Msg 2714, Level 16, State 4, Line 1

There is already an object named 'FK_RolePermission_Permission' in the database.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

(1 row(s) affected)

Adding foreign keys to [dbo].[Version]

Msg 2714, Level 16, State 4, Line 1

There is already an object named 'FK_Version_Project' in the database.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

(1 row(s) affected)

Adding foreign keys to [dbo].[BugAttachment]

Msg 2714, Level 16, State 4, Line 1

There is already an object named 'FK_BugAttachment_Bug' in the database.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

(1 row(s) affected)

Adding foreign keys to [dbo].[ProjectCustomFieldSelection]

Msg 2714, Level 16, State 4, Line 1

There is already an object named 'FK_ProjectCustomFieldSelection_ProjectCustomFields' in the database.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

(1 row(s) affected)

Adding foreign keys to [dbo].[BugTimeEntry]

Msg 2714, Level 16, State 4, Line 1

There is already an object named 'FK_BugTimeEntry_Bug' in the database.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

(1 row(s) affected)

Migrating Components

Adding foreign keys to [dbo].[Bug]

Msg 2714, Level 16, State 4, Line 1

There is already an object named 'FK_Bug_Priority' in the database.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

(1 row(s) affected)

Adding foreign keys to [dbo].[RolePermission]

Msg 1767, Level 16, State 0, Line 1

Foreign key 'FK_RolePermission_Roles' references invalid table 'dbo.Roles'.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

(1 row(s) affected)

Adding foreign keys to [dbo].[BugComment]

Msg 2714, Level 16, State 4, Line 1

There is already an object named 'FK_BugComment_Bug' in the database.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

(1 row(s) affected)

Adding foreign keys to [dbo].[UserRoles]

Msg 4902, Level 16, State 1, Line 1

Cannot find the object "dbo.UserRoles" because it does not exist or you do not have permissions.

(1 row(s) affected)

Adding foreign keys to [dbo].[ProjectCustomFields]

Msg 2714, Level 16, State 4, Line 1

There is already an object named 'FK_ProjectCustomFields_Project' in the database.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

(1 row(s) affected)

Adding foreign keys to [dbo].[BugNotification]

Msg 2714, Level 16, State 4, Line 1

There is already an object named 'FK_BugNotification_Bug' in the database.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

(1 row(s) affected)

Adding foreign keys to [dbo].[RelatedBug]

Msg 2714, Level 16, State 4, Line 1

There is already an object named 'FK_RelatedBug_Bug' in the database.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

(1 row(s) affected)

Adding foreign keys to [dbo].[ProjectCustomFieldValues]

Msg 2714, Level 16, State 4, Line 1

There is already an object named 'FK_ProjectCustomFieldValues_Bug' in the database.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

(1 row(s) affected)

Adding foreign keys to [dbo].[BugHistory]

Msg 2714, Level 16, State 4, Line 1

There is already an object named 'FK_BugHistory_Bug' in the database.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

(1 row(s) affected)

Adding foreign keys to [dbo].[Roles]

Msg 4902, Level 16, State 1, Line 1

Cannot find the object "dbo.Roles" because it does not exist or you do not have permissions.

(1 row(s) affected)

Migrating Adding Roles for Existing Projects

Msg 2812, Level 16, State 62, Line 1

Could not find stored procedure 'BugNet_Role_CreateNewRole'.

Msg 2812, Level 16, State 62, Line 15

Could not find stored procedure 'BugNet_Role_CreateNewRole'.

(1 row(s) affected)

Adding permissions for roles

Msg 208, Level 16, State 1, Line 8

Invalid object name 'Roles'.

(1 row(s) affected)

Updating Host Settings

(1 row(s) affected)

Adding Administrator to Super Users Role

Msg 2812, Level 16, State 62, Line 2

Could not find stored procedure 'dbo.BugNet_Role_AddUserToRole'.

Msg 3903, Level 16, State 1, Line 1

The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

(1 row(s) affected)

The database update succeeded

3/26/2007 4:09 AM

	sborcher
6 posts

Re: .7 beta to .7.820

Hi all,

same problem here!

Stephan

3/26/2007 7:04 AM

	admin
641 posts
bugnetproject.com

Re: .7 beta to .7.820

This is strange.

You can try taking out the statement which adds the default value to the bug table.

PRINT N'Adding constraints to [dbo].[Bug]'
 GO
 ALTER TABLE [dbo].[Bug] ADD CONSTRAINT [DF_Bug_DueDate] DEFAULT ('1/1/1900 12:00:00 AM') FOR [DueDate]
 GO
 IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
 GO
 IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
 GO

I am not sure why the the rest of the script is erroring on the foreign keys because they get dropped first in the script.

Davin Dubeau
BugNET - Core Developer

3/26/2007 9:12 AM

	janzzai
2 posts

Re: .7 beta to .7.820

same problem here too...

Page 1 of 6

...6

Forum

Support

Upgrading probl...

.7 beta to .7.820

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.