- Active Forums Version: 4.3.2
- DotNetNuke Version: 5.5.1
I today upgraded my DNN Blog module from v4.0.1 to the (just released) v04.01.00. The following error emerged during the install of the v4.1 blog module and it seems to relate to Active Forums ("activeforums_Security_ModLock") was thrown in the installation
. I note that, despite this error, the installation ended with the words "installation successful". I also note that already existing blog entries created with the blog module are being built correctly after this istallation.
Does the error below reveal an incompatability between AF and the new version of the blog module?
|
|
| Info | Start Sql execution: 04.01.00.SqlDataProvider file |
| Warning | SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Constraint 'DF_activeforums_Security_ModLock' does not belong to table 'Blog_Blogs'. Could not drop constraint. See previous errors. 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) /*************** 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): 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.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.Blog_Blogs DROP COLUMN [EnableTwitterIntegration] |
| Info | End Sql execution: 04.01.00.SqlDataProvider file |