I am attempting to update an Xperience by Kentico project from 29.0 to 30 (or even 29.1 for that matter) and each time I am getting the same database update error.
Kentico.Web.Mvc.IStartupConfigureAction[0] Startup action 'Kentico.Web.Mvc.DbUpdateService'. System.Exception: [DataConnection.HandleError]:
Query:
IF NOT EXISTS (SELECT 1 FROM CMS_ScheduledTask WHERE TaskGUID = '99c68980-6627-4e05-8008-fd4a4377e56a')
BEGIN
INSERT [CMS_ScheduledTask] ([TaskName], [TaskDisplayName], [TaskAssemblyName], [TaskClass], [TaskInterval], [TaskData], [TaskLastRunTime], [TaskNextRunTime], [TaskLastResult], [TaskDeleteAfterLastRun], [TaskServerName], [TaskGUID], [TaskLastModified], [TaskExecutions], [TaskResourceID], [TaskRunInSeparateThread], [TaskLastExecutionReset], [TaskCondition], [TaskUserID], [TaskType], [TaskObjectType], [TaskObjectID], [TaskExecutingServerName], [TaskEnabled], [TaskIsRunning])
VALUES ('Content.PublishScheduledContentItems', 'Publish scheduled content items', 'CMS.ContentEngine', 'CMS.ContentEngine.Internal.ScheduledContentItemPublisherTask', 'minute;3/11/2024 9:00:17 PM;1;00:00:00;00:00:00;Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday', '', getDate(), getDate(), 0, 0, NULL, '99c68980-6627-4e05-8008-fd4a4377e56a', getDate(), 0, NULL, 0, getDate(), NULL, NULL, NULL, NULL, NULL, '', 1, 0)
END
Caused exception:
Invalid column name 'TaskResourceID'.
Invalid column name 'TaskRunInSeparateThread'.
Invalid column name 'TaskLastExecutionReset'.
Invalid column name 'TaskCondition'.
---> Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'TaskResourceID'.
Invalid column name 'TaskRunInSeparateThread'.
Invalid column name 'TaskLastExecutionReset'.
Invalid column name 'TaskCondition'.
Any help would be appreciated.