When I tried to upgrade the Blog module to 4.1.0, I got the following error when it tried to run the SQL portion:







Start Sql execution: 04.01.00.SqlDataProvider file



Warning  SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Constraint 'DF_activeforums_Security_ModLock' does not belong to table 'Blog_Blogs'. Could not drop constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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) /*************** 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: The object 'DF_Blog_Blogs_EnableTwitterIntegration' is dependent on column 'EnableTwitterIntegration'. ALTER TABLE DROP COLUMN EnableTwitterIntegration failed because one or more objects access this column. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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) ALTER TABLE dbo.Blog_Blogs DROP COLUMN [EnableTwitterIntegration]







The module said that install completed successfully, and it appears to work, however I am not convinced.  Is there something I should be doing (I'm not a strong SQL guy)







Cheers



Dave

---

-----
Cheers
Dave

Thanks Will.

Hopefully all is well because there is no going back now ;)

Cheers

---

-----
Cheers
Dave