hi
while upgrading from forums 4.5.3 to 5.0.0 i encountered the following error:
Error loading files from temporary folder - see below
StartJob Starting Installation
Info Starting Installation - DNN_Forum
Info Starting Installation - Script
Info Begin Sql execution
Info Created - 04.06.01.SqlDataProvider
Info Executing 04.06.01.SqlDataProvider
Info Start Sql execution: 04.06.01.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): The statistics '_dta_stat_296388125_10_12_11' is dependent on column 'PostLevel'. The statistics '_dta_stat_296388125_10_12_1_11' is dependent on column 'PostLevel'. ALTER TABLE DROP COLUMN PostLevel 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() 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 SYS.COLUMNS WHERE NAME = N'PostLevel' AND OBJECT_ID = OBJECT_ID(N'dbo.Forum_Posts')) BEGIN ALTER TABLE dbo.Forum_Posts DROP COLUMN [PostLevel] END System.Data.SqlClient.SqlException (0x80131904): The statistics '_dta_stat_296388125_16_1_22' is dependent on column 'FileAttachmentURL'. The statistics '_dta_stat_296388125_1_22_10_13' is dependent on column 'FileAttachmentURL'. The statistics '_dta_stat_296388125_1_22_10_12' is dependent on column 'FileAttachmentURL'. The statistics '_dta_stat_296388125_10_13_16_1_22' is dependent on column 'FileAttachmentURL'. The statistics '_dta_stat_296388125_1_10_12_16_22' is dependent on column 'FileAttachmentURL'. ALTER TABLE DROP COLUMN FileAttachmentURL 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() 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 SYS.COLUMNS WHERE NAME = N'FileAttachmentURL' AND OBJECT_ID = OBJECT_ID(N'dbo.Forum_Posts')) BEGIN ALTER TABLE dbo.Forum_Posts DROP COLUMN [FileAttachmentURL] END
Info End Sql execution: 04.06.01.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - DNN_Forum
Info Deleted temporary install folder
EndJob Ins
While upgrading to DNN 5.6 there was a minor error in SQL Provider as well but install completed successfully. Can someone suggest what could be the course of action?
Cheers