I just downloaded the forum module, attempted to install it on a 5.4.2 dnn release and get the following errors: Info Start Sql execution: 04.05.00.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 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(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) DECLARE @default_constraint_name SYSNAME, @sql NVARCHAR(3750) IF EXISTS ( SELECT name FROM dbo.sysobjects WHERE parent_obj = OBJECT_ID(N'dbo.Forum_Users') AND type = 'D' AND id = ( SELECT cdefault FROM syscolumns WHERE name = N'EmailFormat' ) ) BEGIN SELECT @default_constraint_name = name FROM dbo.sysobjects WHERE parent_obj = OBJECT_ID(N'dbo.Forum_Users') AND type = 'D' AND id = ( SELECT cdefault FROM syscolumns WHERE name = N'EmailFormat' ) SET @sql = N'ALTER TABLE dbo.Forum_Users DROP Constraint ' + @default_constraint_name EXEC sp_executesql @sql END System.Data.SqlClient.SqlException: Column already has a DEFAULT bound to it. Could not create 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(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.Forum_Users ADD CONSTRAINT DF_Forum_Users_EmailFormat DEFAULT (1) FOR EmailFormat Info End Sql execution: 04.05.00.SqlDataProvider file Info Finished Sql execution Failure Installation Failed - Script Info Installation Failed - DNN_Forum Info Deleted temporary install folder EndJob Installation Failed

Just tried to upgrade my Forum 4.5.3 running on DNN 5.4.4 and got the following:

Package Installation Report See below for the results of the package installation

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 Creating backup of previous version - 04.06.01.SqlDataProvider 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: The index 'dbo.Forum_PostsTreeSortOrder' is dependent on column 'TreeSortOrder'. ALTER TABLE DROP COLUMN TreeSortOrder 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(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) IF EXISTS (SELECT * FROM SYS.COLUMNS WHERE NAME = N'TreeSortOrder' AND OBJECT_ID = OBJECT_ID(N'dbo.Forum_Posts')) BEGIN ALTER TABLE dbo.Forum_Posts DROP COLUMN [TreeSortOrder] END System.Data.SqlClient.SqlException: The index 'dbo.Forum_PostsThreadIDFlatSortOrder' is dependent on column 'FlatSortOrder'. ALTER TABLE DROP COLUMN FlatSortOrder 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(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) IF EXISTS (SELECT * FROM SYS.COLUMNS WHERE NAME = N'FlatSortOrder' AND OBJECT_ID = OBJECT_ID(N'dbo.Forum_Posts')) BEGIN ALTER TABLE dbo.Forum_Posts DROP COLUMN [FlatSortOrder] END System.Data.SqlClient.SqlException: The index 'dbo.Forum_UsersUserIDAlias' is dependent on column 'Alias'. ALTER TABLE DROP COLUMN Alias 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(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) IF EXISTS (SELECT * FROM SYS.COLUMNS WHERE NAME = N'Alias' AND OBJECT_ID = OBJECT_ID(N'dbo.Forum_Users')) BEGIN ALTER TABLE dbo.Forum_Users DROP COLUMN [Alias] 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 Installation Failed