New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumInstall errorInstall error
Previous
 
Next
New Post
11/22/2010 6:58 PM
 
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() שגיאות
 
New Post
11/23/2010 5:50 AM
 
You got this error if you have old Forum database artifacts on your system.  Please uninstall the module, open your DNN database using SQL Management Studio and delete all forum artifacts from the table, procedures and views.

After you have cleaning your dnn instance and have successfully uninstalled the forum from your DNN you could try to re-install it.

If you had run the install as a upgrade, please restore a backup of your database and retry it.
 
New Post
11/23/2010 7:10 AM
 
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
 
New Post
11/23/2010 7:34 AM
 
This is so frustrating...
I just can't install this module...
 
New Post
11/23/2010 8:03 AM
 

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

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumInstall errorInstall error


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.