StartJob Starting Installation Info Starting Installation - 2SexyContent Info Starting Installation - Script Info Begin Sql execution Info Created - SqlDataProvider\12.00.00.SqlDataProvider Info Executing 12.00.00.SqlDataProvider Info Start Sql execution: 12.00.00.SqlDataProvider file Info End Sql execution: 12.00.00.SqlDataProvider file Info Created - SqlDataProvider\13.00.00.SqlDataProvider Info Executing 13.00.00.SqlDataProvider Info Start Sql execution: 13.00.00.SqlDataProvider file Info End Sql execution: 13.00.00.SqlDataProvider file Info Created - SqlDataProvider\13.01.00.SqlDataProvider Info Executing 13.01.00.SqlDataProvider Info Start Sql execution: 13.01.00.SqlDataProvider file Info End Sql execution: 13.01.00.SqlDataProvider file Info Created - SqlDataProvider\13.04.00.SqlDataProvider Info Executing 13.04.00.SqlDataProvider Info Start Sql execution: 13.04.00.SqlDataProvider file Info End Sql execution: 13.04.00.SqlDataProvider file Info Created - SqlDataProvider\15.00.00.SqlDataProvider Info Executing 15.00.00.SqlDataProvider Info Start Sql execution: 15.00.00.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'IF'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 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, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDatabaseConnectionProvider.ExecuteNonQuery(String connectionString, CommandType commandType, Int32 commandTimeout, String query) at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:cccb9c63-0bab-44e2-837a-61ffa3449e6c Error Number:156,State:1,Class:15 -- 1. remove sql trigger functionality that store data in 'ToSIC_EAV_DataTimeline' table -- min Sql Server 2016 DROP TRIGGER IF EXISTS [dbo].[AutoLogAllChangesToTimeline_EntityRelationships]; DROP TRIGGER IF EXISTS [dbo].[AutoLogAllChangesToTimeline_Values]; DROP TRIGGER IF EXISTS [dbo].[AutoLogAllChangesToTimeline_ValuesDimensions]; DROP PROCEDURE IF EXISTS [dbo].[ToSIC_EAV_LogToTimeline] System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'IF'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 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, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDatabaseConnectionProvider.ExecuteNonQuery(String connectionString, CommandType commandType, Int32 commandTimeout, String query) at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:cccb9c63-0bab-44e2-837a-61ffa3449e6c Error Number:156,State:1,Class:15 -- 2. first install case (execute when [ToSIC_EAV_DataTimeline] is empty) -- there is equivalnt sql code from c# that is executed only as part of module upgrade after dnn restarts -- ToSic.Sxc.Dnn.Core/Dnn/Install/DnnEnvironmentInstaller.cs#L121-L121 IF NOT EXISTS (SELECT * FROM [dbo].[ToSIC_EAV_DataTimeline]) BEGIN -- add CJson column to 'ToSIC_EAV_DataTimeline' IF NOT EXISTS (SELECT * FROM sys.columns WHERE Name = 'CJson' AND Object_ID = OBJECT_ID('ToSIC_EAV_DataTimeline')) BEGIN ALTER TABLE [dbo].[ToSIC_EAV_DataTimeline] ADD [CJson] varbinary(max) NULL; END -- drop NewData column from 'ToSIC_EAV_DataTimeline' ALTER TABLE [dbo].[ToSIC_EAV_DataTimeline] DROP COLUMN IF EXISTS [NewData]; END System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'IF'. Incorrect syntax near the keyword 'IF'. Incorrect syntax near the keyword 'IF'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 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, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDatabaseConnectionProvider.ExecuteNonQuery(String connectionString, CommandType commandType, Int32 commandTimeout, String query) at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:cccb9c63-0bab-44e2-837a-61ffa3449e6c Error Number:156,State:1,Class:15 -- 3. remove columns not in use ALTER TABLE [dbo].[ToSIC_EAV_AttributeGroups] DROP COLUMN IF EXISTS [SortOrder]; ALTER TABLE [dbo].[ToSIC_EAV_Entities] DROP COLUMN IF EXISTS [SortOrder]; ALTER TABLE [dbo].[ToSIC_EAV_AttributeSets] DROP COLUMN IF EXISTS [Description]; Info End Sql execution: 15.00.00.SqlDataProvider file Info Finished Sql execution Failure Installation Failed - Script Info Installation Failed - 2SexyContent Info Starting Installation - 2SexyContent-App Info Starting Installation - Script Info Begin Sql execution Info Creating backup of previous version - SqlDataProvider\require-2sxc-9.SqlDataProvider Info Created - SqlDataProvider\require-2sxc-9.SqlDataProvider Info Executing require-2sxc-9.SqlDataProvider Info Start Sql execution: require-2sxc-9.SqlDataProvider file Info End Sql execution: require-2sxc-9.SqlDataProvider file Info Finished Sql execution Info Component installed successfully - Script Info Starting Installation - Module Info Module registered successfully - 2sxc-app Info Component installed successfully - Module Info Starting Installation - File Info Creating backup of previous version - icon-app.png Info Created - icon-app.png Info Component installed successfully - File Info Starting Installation - Config Info Creating backup of previous version - web.config Info Config file updated - web.config Info Component installed successfully - Config Info Config file changes committed - web.config Failure Package Installation aborted Info Installation Failed - 2SexyContent-App Info Starting Installation - ToSic.Imageflow.Dnn Info Starting Installation - Assembly Info Assembly registered - bin\ToSic.Imageflow.Dnn.dll Info Created - bin\ToSic.Imageflow.Dnn.dll Info Component installed successfully - Assembly Info Starting Installation - Config Info Creating backup of previous version - web.config Info Config file updated - web.config Info Component installed successfully - Config Info Starting Installation - ResourceFile Info Expanding Resource file Info Created - bin/runtimes/win-x86/native/imageflow.dll.pending Info Created - bin/runtimes/win-x64/native/imageflow.dll.pending Info Created - bin/Imageflow/Microsoft.Extensions.Configuration.Abstractions.dll Info Created - bin/Imageflow/Microsoft.Extensions.DependencyInjection.Abstractions.dll Info Created - bin/Imageflow/Microsoft.Extensions.DependencyInjection.dll Info Created - bin/Imageflow/Microsoft.Extensions.FileProviders.Abstractions.dll Info Created - bin/Imageflow/Microsoft.Extensions.Hosting.Abstractions.dll Info Created - bin/Imageflow/Microsoft.Extensions.Logging.Abstractions.dll Info Created - bin/Imageflow/Microsoft.Extensions.Primitives.dll Info Created - bin/Imageflow/Microsoft.IO.RecyclableMemoryStream.dll Info Created - bin/Imageflow/System.Buffers.dll Info Created - bin/Imageflow/System.Memory.dll Info Created - bin/Imageflow/System.Numerics.Vectors.dll Info Created - bin/Imageflow/System.Runtime.CompilerServices.Unsafe.dll Info Created - bin/Imageflow.Net.dll Info Created - bin/Imazen.Common.dll Info Created - bin/Imazen.HybridCache.dll Info Resource Files created Info Component installed successfully - ResourceFile Info Starting Installation - Module Info Module registered successfully - Imageflow Info Component installed successfully - Module Info Starting Installation - File Info Folder Created - D:\Websites\www-dev\Resources\Libraries\ToSic\Imageflow\ Info Created - icon.png Info Created - License.txt Info Created - ReleaseNotes.txt Info Component installed successfully - File Info Config file changes committed - web.config Failure Package Installation aborted Info Installation Failed - ToSic.Imageflow.Dnn Info Starting Installation - Connect.Dnn.Koi Info Starting Installation - ResourceFile Info Expanding Resource file Info Created - install/Connect_Dnn_Koi_01.03.00_Install/koi/License.txt Info Created - install/Connect_Dnn_Koi_01.03.00_Install/koi/ReleaseNotes.txt Info Creating backup of previous version - icon.png Info Created - icon.png Info Creating backup of previous version - License.txt Info Created - License.txt Info Creating backup of previous version - ReleaseNotes.txt Info Created - ReleaseNotes.txt Info Resource Files created Info Component installed successfully - ResourceFile Info Starting Installation - Assembly Info Assembly updated - bin\Connect.Dnn.Koi.dll Info Creating backup of previous version - bin\Connect.Dnn.Koi.dll Info Created - bin\Connect.Dnn.Koi.dll Info Assembly updated - bin\Connect.Koi.dll Info Creating backup of previous version - bin\Connect.Koi.dll Info Created - bin\Connect.Koi.dll Info Component installed successfully - Assembly Failure Package Installation aborted Info Installation Failed - Connect.Dnn.Koi Info Starting Installation - ToSic.RazorBlade Info Starting Installation - ResourceFile Info Expanding Resource file Info Creating backup of previous version - icon.png Info Created - icon.png Info Creating backup of previous version - License.txt Info Created - License.txt Info Creating backup of previous version - ReleaseNotes.txt Info Created - ReleaseNotes.txt Info Resource Files created Info Component installed successfully - ResourceFile Info Starting Installation - Assembly Info Assembly updated - bin\ToSic.Razor.dll Info Creating backup of previous version - bin\ToSic.Razor.dll Info Created - bin\ToSic.Razor.dll Info Assembly updated - bin\ToSic.Razor.Dnn.dll Info Creating backup of previous version - bin\ToSic.Razor.Dnn.dll Info Created - bin\ToSic.Razor.Dnn.dll Info Component installed successfully - Assembly Failure Package Installation aborted Info Installation Failed - ToSic.RazorBlade Info Starting Installation - Connect.Razor Info Starting Installation - ResourceFile Info Expanding Resource file Info Creating backup of previous version - icon.png Info Created - icon.png Info Creating backup of previous version - License.txt Info Created - License.txt Info Creating backup of previous version - ReleaseNotes.txt Info Created - ReleaseNotes.txt Info Resource Files created Info Component installed successfully - ResourceFile Info Starting Installation - Assembly Info Assembly already registered - bin\Connect.Razor.dll Info Creating backup of previous version - bin\Connect.Razor.dll Info Created - bin\Connect.Razor.dll Info Assembly already registered - bin\Connect.Razor.Dnn.dll Info Creating backup of previous version - bin\Connect.Razor.Dnn.dll Info Created - bin\Connect.Razor.Dnn.dll Info Component installed successfully - Assembly Failure Package Installation aborted Info Installation Failed - Connect.Razor Info Deleted temporary install folder EndJob Installation Failed