2SXC Upgrade from 9.2.0 to 9.33.0 results in error

0

I have a DNN 7.4.2 instance with 2SXC 9.2.0 installed. I went to Host > Extensions and went to install 2SXC 9.33.00 and I got the following error.

StartJob    Starting Installation
Info    Starting Installation - 2SexyContent
Info    Starting Installation - Script
Info    Begin Sql execution
Info    Creating backup of previous version - SqlDataProvider\09.03.00.SqlDataProvider
Info    Created - SqlDataProvider\09.03.00.SqlDataProvider
Info    Executing 09.03.00.SqlDataProvider
Info    Start Sql execution: 09.03.00.SqlDataProvider file
Info    End Sql execution: 09.03.00.SqlDataProvider file
Info    Creating backup of previous version - SqlDataProvider\09.07.00.SqlDataProvider
Info    Created - SqlDataProvider\09.07.00.SqlDataProvider
Info    Executing 09.07.00.SqlDataProvider
Info    Start Sql execution: 09.07.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'AppId' in table 'dbo.ToSIC_EAV_Entities' is specified more than once. 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.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:38adf45d-5e60-4bde-ad34-047618e9cd3b Error Number:2705,State:4,Class:16 -- make sure sql rolls back automatically in case of error. SET XACT_ABORT ON BEGIN TRANSACTION SexyContentUpdate; -- add AppId column, nullable at first ALTER TABLE dbo.ToSIC_EAV_Entities ADD AppId int NULL; ALTER TABLE dbo.ToSIC_EAV_Entities ADD ContentType nvarchar(250) NULL /* wrap as exec (not tested yet) to ensure it runs, even though AppId isn't ready yet */ EXEC(' UPDATE dbo.ToSIC_EAV_Entities Set dbo.ToSIC_EAV_Entities.AppId = dbo.ToSIC_EAV_AttributeSets.AppId FROM dbo.ToSIC_EAV_AttributeSets WHERE dbo.ToSIC_EAV_Entities.AttributeSetID = dbo.ToSIC_EAV_AttributeSets.AttributeSetId; ALTER TABLE dbo.ToSIC_EAV_Entities ADD CONSTRAINT FK_ToSIC_EAV_Entities_ToSIC_EAV_Apps FOREIGN KEY (AppId) REFERENCES ToSIC_EAV_Apps(AppId); ALTER TABLE dbo.ToSIC_EAV_Entities ALTER COLUMN AppId INTEGER NOT NULL '); COMMIT TRANSACTION SexyContentUpdate; --ROLLBACK TRANSACTION SexyContentUpdate;
Info    End Sql execution: 09.07.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 - 2sic_Imazen_ImageResizerPro
Info    Starting Installation - Script
Info    Begin Sql execution
Info    Finished Sql execution
Info    Component installed successfully - Script
Info    Starting Installation - Assembly
Info    Assembly already registered - bin\ImageResizer.dll
Info    Creating backup of previous version - bin\ImageResizer.dll
Info    Created - bin\ImageResizer.dll
Info    Assembly already registered - bin\ImageResizer.Plugins.DiskCache.dll
Info    Creating backup of previous version - bin\ImageResizer.Plugins.DiskCache.dll
Info    Created - bin\ImageResizer.Plugins.DiskCache.dll
Info    Component installed successfully - Assembly
Info    Starting Installation - 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    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 - 2sic_Imazen_ImageResizerPro
Info    Starting Installation - Connect.Dnn.Koi
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.Dnn.Koi.dll
Info    Creating backup of previous version - bin\Connect.Dnn.Koi.dll
Info    Created - bin\Connect.Dnn.Koi.dll
Info    Assembly already registered - 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    Deleted temporary install folder
EndJob  Installation Failed

Once I clicked "Return", I noticed that 2SXC App version changed to 9.33.0 but the Content module is still at 9.2.0. Is there a step I'm missing or should I upgrade to DNN9 first?

dotnetnuke
2sxc

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0