I tryed a upgrade today of the Blog 4.1.0 (Install) on my DNN 5.6.1 environment from the last Blog module version with the following error:

Start Sql execution: 04.01.00.SqlDataProvider file
Warning SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Die DF_Forum_Posts_ParseInfo-Einschränkung gehört nicht zur Blog_Blogs-Tabelle. Die Einschränkung konnte nicht gelöscht werden. Siehe vorherige Fehler. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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) /*************** TABLES ************************/ DECLARE @defname VARCHAR(100), @cmd VARCHAR(1000) SELECT @defname = sc.name FROM sys.columns st JOIN sys.default_constraints sc ON st.column_id = sc.parent_column_id WHERE st.name = 'EnableTwitterIntegration' SET @cmd = 'ALTER TABLE dbo.Blog_Blogs DROP CONSTRAINT ' + @defname EXEC(@cmd) System.Data.SqlClient.SqlException (0x80131904): Das Objekt-Objekt 'DF_Blog_Blogs_EnableTwitterIntegration' ist vom Spalte-Objekt 'EnableTwitterIntegration' abhängig. Fehler bei ALTER TABLE DROP COLUMN EnableTwitterIntegration, da mindestens ein Objekt auf diese Spalte zugreift. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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.Blog_Blogs DROP COLUMN [EnableTwitterIntegration]


This issue comes up looks like ther still exist a contraints from the forum module. If you have a solution to fix this and running the drop scripts successfully please post me your code.

Thanks
Matthias

---

Regards

Matthias

DNN MVP

www.aarsys.de

Metro7 Skin

ShoutCastStats Module for DNN