I have installed umbraco workflow for the first time today. In my development environment it was working great in our existing project. However when I tried deploying it to our staging environment, straight after login the whole backoffice fails to load, and the actual website is not served at all. The logs show that the migration failed because 'DFWorkflowSettingsAllowAttachments' is dependent on column 'AllowAttachments' Our server is running IIS Express. I use "dotnet publish -c Release" to create the folder that IIS Express Manager runs on. We use a SQL local database.

Logs:

{"@t":"2023-07-20T20:36:59.8219898Z","@mt":"Acquiring MainDom.","SourceContext":"Umbraco.Cms.Core.Runtime.MainDom","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:36:59.8306918Z","@mt":"Acquired MainDom.","SourceContext":"Umbraco.Cms.Core.Runtime.MainDom","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:00.1710813Z","@mt":"Profiler is VoidProfiler, not profiling (must run debug mode to profile).","SourceContext":"Umbraco.Cms.Web.Common.Profiler.InitializeWebProfiling","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:00.2127784Z","@mt":"No last synced Id found, this generally means this is a new server/install. A cold boot will be triggered.","@l":"Warning","SourceContext":"Umbraco.Cms.Infrastructure.Sync.SyncBootStateAccessor","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"WARN "} {"@t":"2023-07-20T20:37:01.0279714Z","@mt":"uSync: Startup Complete {elapsed}ms","elapsed":4,"SourceContext":"uSync.BackOffice.Notifications.uSyncApplicationStartingHandler","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:01.0619173Z","@mt":"Starting '{MigrationName}'...","MigrationName":"Workflow","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:01.0619918Z","@mt":"At {OrigState}","OrigState":"WorkflowTwoZeroZero","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:01.0638542Z","@mt":"Execute {MigrationType}","MigrationType":"WorkflowElevenZeroZero","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:01.1218426Z","@mt":"Create table:\n {Sql}","Sql":"CREATE TABLE [WorkflowContentReviewConfig] ([Id] INTEGER NOT NULL IDENTITY(1,1),\n[NodeId] INTEGER NULL,\n[ContentTypeId] INTEGER NULL,\n[Period] INTEGER NULL,\n[GroupIds] NVARCHAR(255) NULL,\n[Exclude] BIT NULL,\n[Variant] NVARCHAR(255) NULL)","SourceContext":"Umbraco.Cms.Persistence.SqlServer.Services.SqlServerSyntaxProvider","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:01.1380112Z","@mt":"Create Primary Key:\n {Sql}","Sql":"ALTER TABLE [WorkflowContentReviewConfig] ADD CONSTRAINT [PKWorkflowContentReviewConfig] PRIMARY KEY CLUSTERED ([Id])","SourceContext":"Umbraco.Cms.Persistence.SqlServer.Services.SqlServerSyntaxProvider","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:01.1559072Z","@mt":"Create table:\n {Sql}","Sql":"CREATE TABLE [WorkflowContentReviewNodes] ([Id] INTEGER NOT NULL IDENTITY(1,1),\n[NodeId] INTEGER NULL,\n[ReviewedOn] DATETIME NULL,\n[DueOn] DATETIME NULL,\n[ReviewedBy] INTEGER NULL,\n[Variant] NVARCHAR(255) NULL)","SourceContext":"Umbraco.Cms.Persistence.SqlServer.Services.SqlServerSyntaxProvider","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:01.1582362Z","@mt":"Create Primary Key:\n {Sql}","Sql":"ALTER TABLE [WorkflowContentReviewNodes] ADD CONSTRAINT [PKWorkflowContentReviewNodes] PRIMARY KEY CLUSTERED ([Id])","SourceContext":"Umbraco.Cms.Persistence.SqlServer.Services.SqlServerSyntaxProvider","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:01.2161296Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":0,"Sql":"ALTER TABLE [WorkflowTaskInstance] ADD [AssignTo] INTEGER NULL","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:01.2511413Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":1,"Sql":"ALTER TABLE [WorkflowSettings] DROP COLUMN [SendNotifications];","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:01.2772584Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":2,"Sql":"ALTER TABLE [WorkflowSettings] DROP COLUMN [DefaultApprover];","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:01.3142820Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":3,"Sql":"ALTER TABLE [WorkflowSettings] DROP COLUMN [Email];","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:01.3395004Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":4,"Sql":"ALTER TABLE [WorkflowSettings] DROP COLUMN [EditUrl];","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:01.3633828Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":5,"Sql":"ALTER TABLE [WorkflowSettings] DROP COLUMN [SiteUrl];","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:01.3882736Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":6,"Sql":"ALTER TABLE [WorkflowSettings] DROP COLUMN [ExcludeNodes];","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:01.4120500Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":7,"Sql":"ALTER TABLE [WorkflowSettings] DROP COLUMN [LockIfActive];","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:01.4458655Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":8,"Sql":"ALTER TABLE [WorkflowSettings] DROP COLUMN [AllowAttachments];","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":6788,"ProcessName":"w3wp","ThreadId":1,"ApplicationId":"ca9fc473d55483e5823594f66dced7349f366336","MachineName":"EC2AMAZ-6932OSN","Log4NetLevel":"INFO "} {"@t":"2023-07-20T20:37:01.4552326Z","@mt":"Exception ({InstanceId}).","@l":"Error","@x":"Microsoft.Data.SqlClient.SqlException (0x80131904): The object 'DFWorkflowSettingsAllowAttachments' is dependent on column 'AllowAttachments'.\r\nALTER TABLE DROP COLUMN AllowAttachments failed because one or more objects access this column.\r\n at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean isAsync, Int32 timeout, Boolean asyncWrite)\r\n at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName)\r\n at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in C:\\projects\\dotnet\\src\\MiniProfiler.Shared\\Data\\ProfiledDbCommand.cs:line 261\r\n at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.<ExecuteNonQuery>b__32_0()\r\n at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.<>c__DisplayClass38_01.