StartJob Starting Installation
Info Starting Installation - Bring2mind\DMX
Info Starting Installation - Script
Info Begin Sql execution
Info Creating backup of previous version - 05.03.00.SqlDataProvider
Info Created - 05.03.00.SqlDataProvider
Info Executing 05.03.00.SqlDataProvider
Info Start Sql execution: 05.03.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'EditControl' in table 'dbo.DMX_Extensions' is specified more than once. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Inline editor changes ******/ ALTER TABLE dbo.DMX_Extensions ADD [EditControl] NVARCHAR (255) NULL, [ViewControl] NVARCHAR (255) NULL
Info End Sql execution: 05.03.00.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - Bring2mind\DMX
Info Deleted temporary install folder
EndJob Installation Failed


Return

Any ideas on how I can fix this error? I try to unistall the current version and I was not able to do so.

From what I can see this was an upgrade. If you experience any problems during an upgrade you need to roll back. This is because DNN has no inbuilt roll-back feature. I presume that you had a failed upgrade and tried again. The error describes how in the database a column which is being added to a table was already there. This is only possible if the upgrade had already run. Since there is no way of telling what ran successfully and what didn't I can't possibly give any indications on how to get out of this. This is not a quirk of DMX but a general DNN issue on failed installs/upgrades. Did you back up your installation (notably database) before the upgrade?

Peter

Hi Peter,

Thank you very much. I was able to do fix my installation.

I learned my lesson and I always backup my database and full root directory before any upgrade.