Peter, I got this error upgrading:
Error loading files from temporary folder - see below
| StartJob |
Starting Installation |
| Info |
Starting Installation - Bring2mind\DMX |
| Info |
Starting Installation - Script |
| Info |
Begin Sql execution |
| Info |
Created - 05.03.03.SqlDataProvider |
| Info |
Executing 05.03.03.SqlDataProvider |
| Info |
Start Sql execution: 05.03.03.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: The index '_dta_index_DMX_Extensions_18_434816611__K11_1_2_3_4_5_6_7_8_9_12_13_14_15_16_17' is dependent on column 'MimeType'. The index '_dta_index_DMX_Extensions_18_434816611__K11_K5_3_4_6_7_8_9_12_13_14_15_16' is dependent on column 'MimeType'. ALTER TABLE ALTER COLUMN MimeType failed because one or more objects access this column. at System.Data.SqlClient.SqlConnection.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) -- repair mime-types for Office 2007+ files ALTER TABLE dbo.DMX_Extensions ALTER COLUMN [MimeType] VARCHAR(200) System.Data.SqlClient.SqlException: String or binary data would be truncated. String or binary data would be truncated. String or binary data would be truncated. String or binary data would be truncated. String or binary data would be truncated. String or binary data would be truncated. String or binary data would be truncated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.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) UPDATE dbo.DMX_Extensions SET MimeType = 'application/vnd.openxmlformats-officedocument.wordprocessingml.document' WHERE Custom = 'docx'; UPDATE dbo.DMX_Extensions SET MimeType = 'application/vnd.openxmlformats-officedocument.wordprocessingml.template' WHERE Custom = 'dotx'; UPDATE dbo.DMX_Extensions SET MimeType = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' WHERE Custom = 'xlsx'; UPDATE dbo.DMX_Extensions SET MimeType = 'application/vnd.openxmlformats-officedocument.spreadsheetml.template' WHERE Custom = 'xltx'; UPDATE dbo.DMX_Extensions SET MimeType = 'application/vnd.openxmlformats-officedocument.presentationml.presentation' WHERE Custom = 'pptx'; UPDATE dbo.DMX_Extensions SET MimeType = 'application/vnd.openxmlformats-officedocument.presentationml.template' WHERE Custom = 'potx'; UPDATE dbo.DMX_Extensions SET MimeType = 'application/vnd.openxmlformats-officedocument.presentationml.slideshow' WHERE Custom = 'ppsx'; |
| Info |
End Sql execution: 05.03.03.SqlDataProvider file |
| Info |
Finished Sql execution |
| Failure |
Installation Failed - Script |
| Info |
Installation Failed - Bring2mind\DMX |
| Info |
Deleted temporary install folder |
| EndJob |
Installation Failed |