StartJob Starting Installation
Info Starting Installation - Bring2mind\DMX
Info Starting Installation - Script
Info Begin Sql execution
Info Creating backup of previous version - 05.03.08.SqlDataProvider
Info Created - 05.03.08.SqlDataProvider
Info Executing 05.03.08.SqlDataProvider
Info Start Sql execution: 05.03.08.SqlDataProvider file
Info End Sql execution: 05.03.08.SqlDataProvider file
Info Creating backup of previous version - 05.03.09.SqlDataProvider
Info Created - 05.03.09.SqlDataProvider
Info Executing 05.03.09.SqlDataProvider
Info Start Sql execution: 05.03.09.SqlDataProvider file
Info End Sql execution: 05.03.09.SqlDataProvider file
Info Creating backup of previous version - 05.04.00.SqlDataProvider
Info Created - 05.04.00.SqlDataProvider
Info Executing 05.04.00.SqlDataProvider
Info Start Sql execution: 05.04.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 'Thumbnail' in table 'dbo.DMX_Entries' 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() 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) ALTER TABLE dbo.DMX_Entries ADD [Thumbnail] VARCHAR (200), [Hidden] BIT System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_DMX_Extensions'. Cannot insert duplicate key in object 'dbo.DMX_Extensions'. The statement has been terminated. 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() 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) INSERT INTO dbo.DMX_Extensions ([AccessRights], [Addon], [ControlToLoad], [Custom], [EntryTypes], [ExtensionKey], [IsPrivate], [PortalId], [ResourceFile]) SELECT '-1;', 'Core', 'Bring2mind.DNN.Modules.DMX.Services.Thumbnails.ThumbnailController, BRING2MIND.DNN.MODULES.DMX.CORE', '0', 'File.Jpg;File.Png;File.Tiff;File.Gif;File.Bmp;', 'EntryProcessor.Thumbnail.Core', 0, p.PortalId, 'DesktopModules/Bring2mind/DMX/App_LocalResources/SharedResources' FROM dbo.Portals p
Info End Sql execution: 05.04.00.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - Bring2mind\DMX
Info Deleted temporary install folder
EndJob Installation Failed

Hi Brandon,

SQL is complaining there was already a column "Thumbnail" in the DMX_Entries table. Any idea how it got there?

Peter

No idea. I don't mess with the back end tables. If it is there then DMX install put it there.

No idea. I don't mess with the back end tables. If it is there then DMX install put it there.

Then did you try to install this first and it failed somehow and you tried again? The fact is that that field is not mentioned in any prior script than 5.4.0. The error clearly states it was already there, suggesting that the script had run before.
Note: if for some reason an install fails you need to roll-back the database. DNN does not do this for you.

Peter

I ran it from install folder with several other updates. I will try again in a few days.

Ok I ran this again by itself and got this error upgrading from 5.3.7 to 6.0.1:
StartJob Starting Installation
Info Starting Installation - Bring2mind\DMX
Info Starting Installation - Script
Info Begin Sql execution
Info Created - 05.03.08.SqlDataProvider
Info Executing 05.03.08.SqlDataProvider
Info Start Sql execution: 05.03.08.SqlDataProvider file
Info End Sql execution: 05.03.08.SqlDataProvider file
Info Created - 05.03.09.SqlDataProvider
Info Executing 05.03.09.SqlDataProvider
Info Start Sql execution: 05.03.09.SqlDataProvider file
Info End Sql execution: 05.03.09.SqlDataProvider file
Info Created - 05.04.00.SqlDataProvider
Info Executing 05.04.00.SqlDataProvider
Info Start Sql execution: 05.04.00.SqlDataProvider file
Info End Sql execution: 05.04.00.SqlDataProvider file
Info Created - 06.00.00.SqlDataProvider
Info Executing 06.00.00.SqlDataProvider
Info Start Sql execution: 06.00.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): The index '_dta_index_DMX_Entries_17_1178487277__K17_K9_K11_K19_K20_K8_K14_1_2_3_4_5_6_7_10_13_15_16_21_22_23_24_25_26_27_28_29_30_31_32_' is dependent on column 'Description'. The index '_dta_index_DMX_Entries_7_1178487277__K19_K11_K17_K8_K9_1_2_3_4_5_6_7_10_13_14_15_16_20_21_22_23_24_25_26_27_28_29_30_31_32_33_' is dependent on column 'Description'. The index '_dta_index_DMX_Entries_7_1178487277__K17_K11_K8_K9_1_2_3_4_5_6_7_10_13_14_15_16_19_20_21_22_23_24_25_26_27_28_29_30_31_32_33_34' is dependent on column 'Description'. ALTER TABLE DROP COLUMN Description failed because one or more objects access this column. 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() 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) IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DMX_Entries' AND COLUMN_NAME = 'Description') BEGIN EXEC('UPDATE dbo.DMX_Entries SET [Title]=[Description]'); EXEC('ALTER TABLE dbo.DMX_Entries DROP COLUMN [Description]'); END IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.DMX_DirectAccessKeys') AND OBJECTPROPERTY(id, N'IsTable') = 1) CREATE TABLE dbo.DMX_DirectAccessKeys ( [PortalId] INT NOT NULL, [Downloads] INT, [Email] NVARCHAR (100), [EntryId] INT, [Expires] DATETIME, [Key] NVARCHAR (100) NOT NULL, [UserId] INT ) ON [PRIMARY] System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "dbo.DMX_DirectAccessKeys" because it does not exist or you do not have permissions. 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() 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) IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_DMX_DirectAccessKeys') AND OBJECTPROPERTY(id, N'IsPrimaryKey') = 1) ALTER TABLE dbo.DMX_DirectAccessKeys ADD CONSTRAINT PK_DMX_DirectAccessKeys PRIMARY KEY CLUSTERED ( [PortalId], [Key] ) ON [PRIMARY] System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "dbo.DMX_DirectAccessKeys" because it does not exist or you do not have permissions. 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() 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) IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'FK_DMX_DirectAccessKeys_Entries') AND OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE dbo.DMX_DirectAccessKeys ADD CONSTRAINT FK_DMX_DirectAccessKeys_Entries FOREIGN KEY ( EntryId ) REFERENCES dbo.DMX_Entries ( EntryId ) ON DELETE CASCADE NOT FOR REPLICATION
Info End Sql execution: 06.00.00.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - Bring2mind\DMX
Info Deleted temporary install folder
EndJob Installation Failed

I am going to try again after killing the indexes.

That did the trick.

Those indexes were probably added by a tuning tool you once used to optimize your DNN installation. I've seen that before.

Peter