Hi

I am on DNN 5.5, trying to install DNN-forums5 and got this, under "running 04.07.00.sqlDataProvider"

כישלון

System.Data.SqlClient.SqlException: Invalid column name 'EnableModNotification'. 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) CREATE PROCEDURE dbo.[Forum_User_Update] ( @UserId INT, @UserAvatar INT, @Avatar NVARCHAR(255), @AdditionalAvatars NVARCHAR(255), @Signature NVARCHAR(1024), @IsTrusted BIT, @EnableOnlineStatus BIT, @ThreadsPerPage INT, @PostsPerPage INT, @EnableModNotification BIT, @EnablePublicEmail BIT, @EmailFormat INT, @PortalID INT, @LockTrust BIT, @EnableProfileWeb BIT, @EnableDefaultPostNotify BIT, @EnableSelfNotifications BIT, @IsBanned BIT, @LiftBanDate DATETIME, @StartBanDate DATETIME ) AS UPDATE dbo.Forum_Users SET [UserAvatar] = @UserAvatar, [Avatar] = @Avatar, [AdditionalAvatars] = @AdditionalAvatars, [Signature] = @Signature, [IsTrusted] = @IsTrusted, [EnableOnlineStatus] = @EnableOnlineStatus, [ThreadsPerPage] = @ThreadsPerPage, [PostsPerPage] = @PostsPerPage, [EnableModNotification] = @EnableModNotification, [EnablePublicEmail] = @EnablePublicEmail, [EmailFormat] = @EmailFormat, [LockTrust] = @LockTrust, [EnableProfileWeb] = @EnableProfileWeb, [EnableDefaultPostNotify] = @EnableDefaultPostNotify, [EnableSelfNotifications] = @EnableSelfNotifications, [IsBanned] = @IsBanned, [LiftBanDate] = @LiftBanDate, [StartBanDate] = @StartBanDate WHERE [UserID] = @UserID AND [PortalID] = @PortalID System.Data.SqlClient.SqlException: Invalid column name 'EnableModNotification'. 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) CREATE PROCEDURE dbo.[Forum_User_Get] ( @UserID INT, @PortalID INT ) AS SELECT U.UserID, [Signature], UserAvatar, Avatar, AdditionalAvatars, PostCount, LastActivity, IsTrusted, EnableOnlineStatus, ThreadsPerPage, PostsPerPage, ViewDescending, EnableModNotification, EmailFormat, PortalID, EnablePublicEmail, TrackingDuration, LockTrust, IsBanned, LiftBanDate, EnableSelfNotifications, EnableProfileWeb, EnableDefaultPostNotify, StartBanDate, DisplayName, Username, Email, IsSuperUser FROM dbo.Forum_Users FU INNER JOIN dbo.Users U ON FU.UserID = U.UserID WHERE U.[UserId] = @UserID AND [PortalID] = @PortalID System.Data.SqlClient.SqlException: Invalid column name 'EnableRSS'. Invalid column name 'EmailAddress'. Invalid column name 'EmailFriendlyFrom'. Invalid column name 'NotifyByDefault'. Invalid column name 'EmailStatusChange'. Invalid column name 'EmailServer'. Invalid column name 'EmailUser'. Invalid column name 'EmailPass'. Invalid column name 'EmailEnableSSL'. Invalid column name 'EmailAuth'. 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) CREATE PROCEDURE dbo.[Forum_Forum_Add] ( @GroupID INT, @IsActive BIT, @ParentID INT, @Name NVARCHAR(255), @Description NVARCHAR(2048), @IsModerated BIT, @ForumType INT, @PublicView BIT, @CreatedByUser INT, @PublicPosting BIT, @EnableForumsThreadStatus BIT, @EnableForumsRating BIT, @ForumLink NVARCHAR(255), @ForumBehavior INT, @AllowPolls BIT, @EnableRSS BIT, @EmailAddress NVARCHAR(100), @EmailFriendlyFrom NVARCHAR(50), @NotifyByDefault BIT, @EmailStatusChange BIT, @EmailServer NVARCHAR(150), @EmailUser NVARCHAR(100), @EmailPass NVARCHAR(50), @EmailEnableSSL BIT, @EmailAuth INT, @EmailPort INT, @EnableSitemap BIT, @SitemapPriority FLOAT ) AS DECLARE @SortOrder INT SET @SortOrder = ISNULL(( SELECT MAX(SortOrder) + 1 FROM dbo.Forum_Forums WHERE GroupID = @GroupID ), 0) INSERT INTO dbo.Forum_Forums ( GroupID, IsActive, ParentID, Name, [Description], CreatedDate, CreatedByUser, UpdatedByUser, UpdatedDate, IsModerated, SortOrder, ForumType, PublicView, PublicPosting, EnableForumsThreadStatus, EnableForumsRating, ForumLink, ForumBehavior, AllowPolls, EnableRSS, EmailAddress, EmailFriendlyFrom, NotifyByDefault, EmailStatusChange, EmailServer, EmailUser, EmailPass, EmailEnableSSL, EmailAuth, EmailPort, EnableSitemap, SitemapPriority ) VALUES ( @GroupID, @IsActive, @ParentID, @Name, @Description, GETDATE(), @CreatedByUser, @CreatedByUser, GETDATE(), @IsModerated, @SortOrder, @ForumType, @PublicView, @PublicPosting, @EnableForumsThreadStatus, @EnableForumsRating, @ForumLink, @ForumBehavior, @AllowPolls, @EnableRSS, @EmailAddress, @EmailFriendlyFrom, @NotifyByDefault, @EmailStatusChange, @EmailServer, @EmailUser, @EmailPass, @EmailEnableSSL, @EmailAuth, @EmailPort, @EnableSitemap, @SitemapPriority ) SELECT SCOPE_IDENTITY() שגיאות

OK, I droped all procedures, views and tables, uninstalled the module, and deleted the forum folder from the desktopmodules folder.

Now, when tried to install a fresh new version of forums 5 (latest download) I got this error:


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_EmailQueue_TaskEmails') AND type = 'D' AND id = ( SELECT cdefault FROM syscolumns WHERE name = N'DateAdded' ) ) BEGIN SELECT @default_constraint_name = name FROM dbo.sysobjects WHERE parent_obj = OBJECT_ID(N'dbo.Forum_EmailQueue_TaskEmails') AND type = 'D' AND id = ( SELECT cdefault FROM syscolumns WHERE name = N'DateAdded' ) SET @sql = N'ALTER TABLE dbo.Forum_EmailQueue_TaskEmails 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_EmailQueue_TaskEmails ADD CONSTRAINT DF_Forum_EmailQueue_TaskEmails_DateAdded DEFAULT (GETDATE()) FOR DateAdded

OK, found the problem. This is due to duplicates of Foreign Keys in the sysobject table, when You got 2 columns at the same names, in this case - DateAdded.

I just changed the file 04.05.00.SqlDataProvider in the package.

* Please change the files according to this...

2 changes were needed:

DECLARE @default_constraint_name SYSNAME,
    @sql NVARCHAR(3750)

IF EXISTS ( SELECT  name
            FROM    dbo.sysobjects
            WHERE   parent_obj = OBJECT_ID(N'{databaseOwner}{objectQualifier}Forum_EmailQueue_TaskEmails')
                    AND type = 'D'
                    AND id IN ( SELECT   cdefault
                               FROM     syscolumns
                               WHERE    name = N'DateAdded'
                             ) )
    BEGIN
        SELECT  @default_constraint_name = name
        FROM    dbo.sysobjects
        WHERE   parent_obj = OBJECT_ID(N'{databaseOwner}{objectQualifier}Forum_EmailQueue_TaskEmails')
                AND type = 'D'
                AND id IN ( SELECT   cdefault
                           FROM     syscolumns
                           WHERE    name = N'DateAdded'
                         ) 

        SET @sql = N'ALTER TABLE {databaseOwner}{objectQualifier}Forum_EmailQueue_TaskEmails DROP Constraint '
            + @default_constraint_name

        EXEC sp_executesql @sql
    END
GO