Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Clickfarm 77 posts 161 karma points
    Mar 22, 2016 @ 20:34
    Clickfarm
    0

    Error during installation

    I'm attempting to update Umbraco and keep running into the following error. What is the recommendation to get around this error?

    The database failed to upgrade. ERROR: The database configuration failed with the following message: The DELETE statement conflicted with the REFERENCE constraint "FKcmsContentTypeumbracoNodeid". The conflict occurred in database "WebsiteDEV", table "dbo.cmsContentType", column 'nodeId'. The statement has been terminated. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')

  • Jan Skovgaard 11280 posts 23678 karma points MVP 10x admin c-trib
    Mar 22, 2016 @ 22:23
    Jan Skovgaard
    0

    Hi Clickfarm

    Can you provide some more information? What version of Umbraco are you upgrading from? And what version are you upgrading to? What approach are you taking? Is it done manually or using nuget for instance?

    Also what database are you using? Is it CE SQL, MySQL or MSSQL?

    Have you read through the documentation about upgrading here? Both the general notes and the specific ones are worth reading https://our.umbraco.org/documentation/Getting-Started/Setup/Upgrading/

    Looking forward to hearing from you.

    /Jan

  • Clickfarm 77 posts 161 karma points
    Mar 23, 2016 @ 12:53
    Clickfarm
    0

    Hi Jan,

    We are upgrading from 7.2.1 to 7.3.0. This is on a Windows 2008R2 server with a separate MSSQL database.

    We are upgrading manually following the instructions found in the link you have provided. Below is a copy of the log file after trying to run the upgrade:

    2016-03-23 07:50:41,292 [6] INFO Umbraco.Core.CoreBootManager - Umbraco 7.3.0 application starting on SULFUR 2016-03-23 07:50:41,308 [6] INFO Umbraco.Core.PluginManager - Determining hash of code files on disk 2016-03-23 07:50:41,323 [6] INFO Umbraco.Core.PluginManager - Hash determined (took 10ms) 2016-03-23 07:50:41,448 [6] INFO Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.IApplicationStartupHandler 2016-03-23 07:50:41,464 [6] INFO Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 0 (took 8ms) 2016-03-23 07:50:41,495 [6] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter 2016-03-23 07:50:41,495 [6] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 0 (took 0ms) 2016-03-23 07:50:41,495 [6] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyValueConverter 2016-03-23 07:50:41,495 [6] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyValueConverter, found 0 (took 0ms) 2016-03-23 07:50:41,511 [6] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.Mvc.SurfaceController 2016-03-23 07:50:41,511 [6] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 0 (took 0ms) 2016-03-23 07:50:41,511 [6] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.WebApi.UmbracoApiController 2016-03-23 07:50:41,511 [6] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.WebApi.UmbracoApiController, found 0 (took 2ms) 2016-03-23 07:50:41,557 [6] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Media.IThumbnailProvider 2016-03-23 07:50:41,557 [6] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 0 (took 0ms) 2016-03-23 07:50:41,557 [6] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Media.IImageUrlProvider 2016-03-23 07:50:41,557 [6] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 0 (took 0ms) 2016-03-23 07:50:42,400 [6] INFO Umbraco.Core.CoreBootManager - Umbraco application startup complete (took 1179ms) 2016-03-23 07:50:43,164 [6] INFO Umbraco.Core.Sync.ApplicationUrlHelper - ApplicationUrl: http://dev.prosoco.com:80/umbraco (UmbracoModule request) 2016-03-23 07:50:49,326 [6] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IParameterEditor 2016-03-23 07:50:49,326 [6] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IParameterEditor, found 0 (took 0ms) 2016-03-23 07:50:54,116 [6] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Persistence.Mappers.BaseMapper 2016-03-23 07:50:54,116 [6] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Persistence.Mappers.BaseMapper, found 0 (took 0ms) 2016-03-23 07:50:54,786 [6] INFO Umbraco.Core.Security.BackOfficeSignInManager - Event Id: 0, state: Login attempt succeeded for username matt from IP address 10.10.0.1 2016-03-23 07:50:59,779 [6] INFO Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: Permissions 2016-03-23 07:50:59,810 [6] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 34ms) 2016-03-23 07:50:59,841 [6] INFO Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: Upgrade 2016-03-23 07:50:59,841 [6] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 0ms) 2016-03-23 07:50:59,857 [6] INFO Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: Version73FileCleanup 2016-03-23 07:51:02,680 [6] INFO Umbraco.Web.Install.InstallSteps.Version73FileCleanup - Cleaning up web.config file: D:\dev.Prosoco.com\Web.config 2016-03-23 07:51:02,696 [6] INFO Umbraco.Web.Install.InstallSteps.Version73FileCleanup - Cleaning up web.config file: D:\dev.Prosoco.com\AppData\25877cae-984d-4742-bdc3-4ff9d51d0b1f\Web.config 2016-03-23 07:51:02,711 [6] INFO Umbraco.Web.Install.InstallSteps.Version73FileCleanup - Cleaning up web.config file: D:\dev.Prosoco.com\Umbraco\Install\Views\Web.config 2016-03-23 07:51:02,711 [6] INFO Umbraco.Web.Install.InstallSteps.Version73FileCleanup - Cleaning up web.config file: D:\dev.Prosoco.com\Umbraco\Xslt\Web.config 2016-03-23 07:51:02,727 [6] INFO Umbraco.Web.Install.InstallSteps.Version73FileCleanup - Cleaning up web.config file: D:\dev.Prosoco.com\umbracoold\Install\Views\Web.config 2016-03-23 07:51:02,727 [6] INFO Umbraco.Web.Install.InstallSteps.Version73FileCleanup - Cleaning up web.config file: D:\dev.Prosoco.com\umbraco_old\Xslt\Web.config 2016-03-23 07:51:02,727 [6] INFO Umbraco.Web.Install.InstallSteps.Version73FileCleanup - Cleaning up web.config file: D:\dev.Prosoco.com\Views\Web.config 2016-03-23 07:51:02,727 [6] INFO Umbraco.Web.Install.InstallSteps.Version73FileCleanup - Cleaning up web.config file: D:\dev.Prosoco.com\xslt\Web.config 2016-03-23 07:51:02,727 [6] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 2858ms) 2016-03-23 07:51:03,226 [19] INFO Umbraco.Core.CoreBootManager - Umbraco 7.3.0 application starting on SULFUR 2016-03-23 07:51:03,257 [19] INFO Umbraco.Core.PluginManager - Determining hash of code files on disk 2016-03-23 07:51:03,273 [19] INFO Umbraco.Core.PluginManager - Hash determined (took 8ms) 2016-03-23 07:51:03,445 [19] INFO Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.IApplicationStartupHandler 2016-03-23 07:51:03,460 [19] INFO Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 0 (took 14ms) 2016-03-23 07:51:03,491 [19] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter 2016-03-23 07:51:03,491 [19] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 0 (took 1ms) 2016-03-23 07:51:03,491 [19] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyValueConverter 2016-03-23 07:51:03,491 [19] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyValueConverter, found 0 (took 0ms) 2016-03-23 07:51:03,523 [19] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.Mvc.SurfaceController 2016-03-23 07:51:03,523 [19] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 0 (took 0ms) 2016-03-23 07:51:03,523 [19] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.WebApi.UmbracoApiController 2016-03-23 07:51:03,523 [19] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.WebApi.UmbracoApiController, found 0 (took 2ms) 2016-03-23 07:51:03,569 [19] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Media.IThumbnailProvider 2016-03-23 07:51:03,569 [19] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 0 (took 0ms) 2016-03-23 07:51:03,569 [19] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Media.IImageUrlProvider 2016-03-23 07:51:03,569 [19] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 0 (took 0ms) 2016-03-23 07:51:04,693 [19] INFO Umbraco.Core.CoreBootManager - Umbraco application startup complete (took 1625ms) 2016-03-23 07:51:05,519 [19] INFO Umbraco.Core.Sync.ApplicationUrlHelper - ApplicationUrl: http://dev.prosoco.com:80/umbraco (UmbracoModule request) 2016-03-23 07:51:06,440 [19] INFO Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: DatabaseInstall 2016-03-23 07:51:06,455 [19] INFO Umbraco.Core.DatabaseContext - Database configuration status: Started 2016-03-23 07:51:06,455 [19] INFO Umbraco.Core.DatabaseContext - Database requires upgrade 2016-03-23 07:51:06,455 [19] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 13ms) 2016-03-23 07:51:06,689 [19] INFO Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: DatabaseUpgrade 2016-03-23 07:51:06,689 [19] INFO Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep - Running 'Upgrade' service 2016-03-23 07:51:06,689 [19] INFO Umbraco.Core.DatabaseContext - Database upgrade started 2016-03-23 07:51:06,705 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Initializing database migrations 2016-03-23 07:51:06,705 [19] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Persistence.Migrations.IMigration 2016-03-23 07:51:06,721 [19] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Persistence.Migrations.IMigration, found 0 (took 1ms) 2016-03-23 07:51:06,783 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddRelationTypeForDocumentOnDelete' to context 2016-03-23 07:51:06,799 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'CreateCacheInstructionTable' to context 2016-03-23 07:51:06,845 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'MigrateAndRemoveTemplateMasterColumn' to context 2016-03-23 07:51:07,001 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'MigrateStylesheetDataToFile' to context 2016-03-23 07:51:07,017 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveStylesheetDataAndTables' to context 2016-03-23 07:51:07,033 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveLanguageLocaleColumn' to context 2016-03-23 07:51:07,048 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateUniqueIdToHaveCorrectIndexType' to context 2016-03-23 07:51:07,064 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddPublicAccessTables' to context 2016-03-23 07:51:07,095 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'MovePublicAccessXmlDataToDb' to context 2016-03-23 07:51:07,111 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveHelpTextColumn' to context 2016-03-23 07:51:07,111 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddExternalLoginsTable' to context 2016-03-23 07:51:07,142 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUserColumns' to context 2016-03-23 07:51:07,142 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddMigrationTable' to context 2016-03-23 07:51:07,189 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUniqueIdPropertyTypeColumn' to context 2016-03-23 07:51:07,267 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddForeignKeysForLanguageAndDictionaryTables' to context 2016-03-23 07:51:07,282 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveUmbracoLoginsTable' to context 2016-03-23 07:51:07,329 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddServerRegistrationColumnsAndLock' to context 2016-03-23 07:51:07,345 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'CleanUpCorruptedPublishedFlags' to context 2016-03-23 07:51:07,360 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 1: INSERT INTO [umbracoRelationType] ([dual],[parentObjectType],[childObjectType],[name],[alias]) VALUES (0,'c66ba18e-eaf3-4cff-8a22-41b16d66a972','c66ba18e-eaf3-4cff-8a22-41b16d66a972','Relate Parent Document On Delete','relateParentDocumentOnDelete');

    2016-03-23 07:51:07,376 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 2: CREATE TABLE [umbracoCacheInstruction] ([id] INTEGER NOT NULL IDENTITY(1,1), [utcStamp] DATETIME NOT NULL, [jsonInstruction] NTEXT NOT NULL, [originated] NVARCHAR(500) NOT NULL)

    2016-03-23 07:51:07,391 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 3: ALTER TABLE [umbracoCacheInstruction] ADD CONSTRAINT [PK_umbracoCacheInstruction] PRIMARY KEY CLUSTERED ([id])

    2016-03-23 07:51:07,391 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 4: UPDATE cmsTemplate SET master = NULL WHERE [master] IS NOT NULL AND [master] NOT IN (SELECT nodeId FROM (SELECT * FROM cmsTemplate a) b)

    2016-03-23 07:51:07,391 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,407 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET parentID=@parentId WHERE id=@nodeId 2016-03-23 07:51:07,423 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET path=@buildPath WHERE id=@nodeId 2016-03-23 07:51:07,469 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 7: ALTER TABLE [cmsTemplate] DROP CONSTRAINT [FKcmsTemplatecmsTemplate]

    2016-03-23 07:51:07,485 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 8: ALTER TABLE [cmsTemplate] DROP COLUMN [master]

    2016-03-23 07:51:07,485 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 9: DELETE FROM [cmsStylesheetProperty] WHERE 1 = 1

    2016-03-23 07:51:07,485 [19] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 10: DELETE FROM [umbracoNode] WHERE [nodeObjectType] = '5555da4f-a123-42b2-4488-dcdfb25e4111'

    2016-03-23 07:51:07,547 [19] INFO Umbraco.Core.Persistence.UmbracoDatabase - at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>cDisplayClass1.0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) 2016-03-23 07:51:07,563 [19] ERROR Umbraco.Core.DatabaseContext - Database configuration failed System.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FK_cmsContentType_umbracoNode_id". The conflict occurred in database "Website_DEV", table "dbo.cmsContentType", column 'nodeId'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass1.<ExecuteNonQueryWithRetry>b__0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) at Umbraco.Core.Persistence.Migrations.MigrationRunner.ExecuteMigrations(IMigrationContext context, Database database) at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade) at Umbraco.Core.DatabaseContext.UpgradeSchemaAndData(IMigrationEntryService migrationEntryService) ClientConnectionId:8e785f1a-be69-421e-ba22-3437ebe2e548 2016-03-23 07:51:07,563 [19] INFO Umbraco.Core.DatabaseContext - The database schema validation produced the following summary: The following tables were found in the database, but are not in the current schema: UCUserSettings,Products,UFRecords,UFRecordFields,UFRecordDataString,UFRecordDataLongString,UFRecordDataInteger,UFRecordDataBit,UFRecordDataDateTime,UFUserSecurity,UFUserFormSecurity,People,umbracoUserLogins,umbracoAccess,umbracoAccessRule,umbracoCacheInstruction,umbracoExternalLogin,umbracoMigration

    The following columns were found in the database, but are not in the current schema: cmsContentVersion,LanguageLocale,cmsPropertyType,helpText,UCUserSettings,User,UCUserSettings,Key,UCUserSettings,Value,Products,Id,Products,Name,Products,Key,Products,ResourceContent,Products,GalleryImage1Id,Products,GalleryImage2Id,Products,GalleryImage3Id,Products,GalleryImage4Id,Products,GalleryImage5Id,Products,GalleryImage6Id,Products,GalleryImage7Id,Products,GalleryImage8Id,Products,GalleryImage9Id,Products,GalleryImage10Id,Products,IsFeatured,Products,RelatedProductKey1,Products,RelatedProductKey2,Products,RelatedProductKey3,Products,RelatedProductKey4,Products,RelatedProductKey5,Products,RelatedProductKey6,Products,RelatedProductKey7,Products,RelatedProductKey8,Products,ProductUrlText,Products,isWebEnabled,Products,SeoTitle,Products,SeoDescription,Products,DiscontinuedProductRedirectKey,Products,DiscontinuedProductMessage,UFRecords,Id,UFRecords,Form,UFRecords,Created,UFRecords,Updated,UFRecords,CurrentPage,UFRecords,UmbracoPageId,UFRecords,IP,UFRecords,MemberKey,UFRecords,UniqueId,UFRecords,State,UFRecords,RecordData,cmsTemplate,master,UFRecordFields,Key,UFRecordFields,FieldId,UFRecordFields,Record,UFRecordFields,Alias,UFRecordFields,DataType,UFRecordDataString,Id,UFRecordDataString,Key,UFRecordDataString,Value,UFRecordDataLongString,Id,UFRecordDataLongString,Key,UFRecordDataLongString,Value,UFRecordDataInteger,Id,UFRecordDataInteger,Key,UFRecordDataInteger,Value,UFRecordDataBit,Id,UFRecordDataBit,Key,UFRecordDataBit,Value,UFRecordDataDateTime,Id,UFRecordDataDateTime,Key,UFRecordDataDateTime,Value,UFUserSecurity,User,UFUserSecurity,ManageDataSources,UFUserSecurity,ManagePreValueSources,UFUserSecurity,ManageWorkflows,UFUserSecurity,ManageForms,UFUserFormSecurity,Id,UFUserFormSecurity,User,UFUserFormSecurity,Form,UFUserFormSecurity,HasAccess,UFUserFormSecurity,AllowInEditor,UFUserFormSecurity,SecurityType,People,Id,People,Name,People,Title,People,PictureId,People,TwitterURL,People,LinkedinURL,People,Biography,People,AuthorPictureId,People,Email,People,DisplayOrder,umbracoUserLogins,contextID,umbracoUserLogins,userID,umbracoUserLogins,timeout,cmsPropertyType,UniqueID,umbracoUser,securityStampToken,umbracoUser,failedLoginAttempts,umbracoUser,lastLockoutDate,umbracoUser,lastPasswordChangeDate,umbracoUser,lastLoginDate,umbracoServer,isMaster,umbracoAccess,id,umbracoAccess,nodeId,umbracoAccess,loginNodeId,umbracoAccess,noAccessNodeId,umbracoAccess,createDate,umbracoAccess,updateDate,umbracoAccessRule,id,umbracoAccessRule,accessId,umbracoAccessRule,ruleValue,umbracoAccessRule,ruleType,umbracoAccessRule,createDate,umbracoAccessRule,updateDate,umbracoCacheInstruction,id,umbracoCacheInstruction,utcStamp,umbracoCacheInstruction,jsonInstruction,umbracoCacheInstruction,originated,umbracoExternalLogin,id,umbracoExternalLogin,userId,umbracoExternalLogin,loginProvider,umbracoExternalLogin,providerKey,umbracoExternalLogin,createDate,umbracoMigration,id,umbracoMigration,name,umbracoMigration,createDate,umbracoMigration,version

    The following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema: FKcmsTemplatecmsTemplate,FKUFRecordDataBitUFRecordFieldsKey,FKUFRecordDataDateTimeUFRecordFieldsKey,FKUFRecordDataIntegerUFRecordFieldsKey,FKUFRecordDataLongStringUFRecordFieldsKey,FKUFRecordDataStringUFRecordFieldsKey,FKcmsDictionarycmsDictionaryid,FKcmsLanguageTextumbracoLanguageid,FKumbracoAccessumbracoNodeid,FKumbracoAccessumbracoNodeid1,FKumbracoAccessumbracoNodeid2,FKumbracoAccessRuleumbracoAccessid,PKPeople,PKProducts,PKUCUserSettings,PKUFRecordDataBit,PKUFRecordDataDateTime,PKUFRecordDataInteger,PKUFRecordDataLongString,PKUFRecordDataString,PKUFRecordFields,PKUFRecords,PKumbracoAccess,PKumbracoAccessRule,PKumbracoCacheInstruction,PKumbracoExternalLogin,PKumbracoMigration,IXumbracoNodeTrashed,IXumbracoNodeParentId,IXumbracoNodeUniqueID,IXumbracoNodeObjectType,IXcmsContentType,IXcmsContentTypeicon,IXcmsTemplatenodeId,IXcmsContent,IXcmsContentVersionContentId,IXcmsContentVersionVersionId,IXcmsDocument,IXcmsDocumentpublished,IXcmsDocumentnewest,IXcmsDataTypenodeId,IXcmsDictionaryid,IXumbracoLanguagelanguageISOCode,IXumbracoLog,IXcmsMacroPropertyAlias,IXcmsMacroPropertyAlias,IXcmsPropertyTypeUniqueID,IXcmsPropertyData,IXcmsPropertyData1,IXcmsPropertyData2,IXcmsPropertyData3,IXcmsTags,IXumbracoUseruserLogin,IXcmsTaskTypealias,IXcomputerName,IXumbracoServerisActive,IXumbracoAccessnodeId,IXumbracoAccessRule,IX_umbracoMigration

    The following indexes were found in the database, but are not in the current schema: IXdatabitrecordfield,IXdatadatetimerecordfield,IXdataintegerrecordfield,IXdatalongstringrecordfield,IXdatastringrecordfield,Id,IXumbracoUserLoginsIndex,IXcmsPropertyTypeUniqueID,IXumbracoAccessnodeId,IXumbracoAccessRule,IX_umbracoMigration

    The following unknown constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema: Id

    2016-03-23 07:51:07,594 [19] ERROR Umbraco.Web.Install.Controllers.InstallApiController - Installation step DatabaseUpgrade failed. System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: The DELETE statement conflicted with the REFERENCE constraint "FKcmsContentTypeumbracoNodeid". The conflict occurred in database "WebsiteDEV", table "dbo.cmsContentType", column 'nodeId'. The statement has been terminated. Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt') at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction) at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel) 2016-03-23 07:51:07,594 [19] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 905ms) 2016-03-23 07:51:07,594 [19] ERROR Umbraco.Web.Install.Controllers.InstallApiController - An error occurred during installation step DatabaseUpgrade System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: The DELETE statement conflicted with the REFERENCE constraint "FKcmsContentTypeumbracoNodeid". The conflict occurred in database "WebsiteDEV", table "dbo.cmsContentType", column 'nodeId'. The statement has been terminated. Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt') at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction) at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel)

Please Sign in or register to post replies

Write your reply to:

Draft