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 ForumsForumForumerror installing Forum Module 5.0.3 on DNN6error installing Forum Module 5.0.3 on DNN6
Previous
 
Next
New Post
12/28/2012 2:36 PM
 

Oh yes...all the normal fun.

So on my dev instance I decided to try and go back to the old forums and go forward again step by step. I deleted the new forum folder and then put the old one back over it and allowed instantbi613.com access to the folder via permissions. But I think there was another step for permissions to allow the IISPOOL access to files. It has been a while since I did this. This is on server 2008 and IIS7. Is that what this problem sounds like?

Thanks in advance.


Error: Forum is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: C:\websites\InstantBI613\DesktopModules\Forum\Forum_Container.ascx(3): error BC30451: 'ForumConfig' is not declared. It may be inaccessible due to its protection level. ---> System.Web.HttpCompileException: C:\websites\InstantBI613\DesktopModules\Forum\Forum_Container.ascx(3): error BC30451: 'ForumConfig' is not declared. It may be inaccessible due to its protection level. at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResult(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean ensureIsUpToDate) at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath) at DotNetNuke.UI.Modules.WebFormsModuleControlFactory.CreateModuleControl(TemplateControl containerControl, ModuleInfo moduleConfiguration) at DotNetNuke.UI.Modules.ModuleControlFactory.LoadModuleControl(TemplateControl containerControl, ModuleInfo moduleConfiguration) at DotNetNuke.UI.Modules.ModuleHost.LoadModuleControl() --- End of inner exception stack trace ---


Best Regards Peter
 
New Post
12/28/2012 3:39 PM
 

So I sorted that one out by reinstalling the old forums and  then going through all the upgrade again. The admin tab can be made to appear if you disable the display of the container...however...even when the admin tab appears it does not have all the features to admin groups and forums etc.....

So this seems to be quite an issue in getting the later forums to work...


Best Regards Peter
 
New Post
11/29/2013 7:21 PM
 

Hi Guys,
I am getting back to trying to upgrade my forums to 5.0.3 on DNN 6.1.3. I have left it for a long time but now it really is time to upgrade the forums.

What I have done is to apply all the sql script commands by hand rather than through  the installer. I then went and created a new package that had empty files in the script commands and rand the 5.0.3 installer....it said it installed ok and in extensions the forums were up to 5.0.3.

I then tried to create  a forum but got a message indicating the field could not take nulls. Scripting the table shows me this line.

ALTER TABLE [dbo].[dnn1_Forum_Forums] ADD  CONSTRAINT [DF_dnn1_Forum_Users_EnableModNotification]  DEFAULT ((1)) FOR [EnableModNotification]
GO

It is set to not null as well. So my question is why should this field be attempted to be set to zero by DNN Forums at the 5.0.3 level. Is it a left over field that should have been deleted or something?


The long message is below.


AssemblyVersion: 6.1.3

PortalID: 0

PortalName: Instant Business Intelligence Webhosting

UserID: 1

UserName: host

ActiveTabID: 905

ActiveTabName: forums2

RawURL: /forums2.aspx

AbsoluteURL: /Default.aspx

AbsoluteURLReferrer: http://instantbi-webhosting613dev.com/

UserAgent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.57 Safari/537.36

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID: 611d8e16-ebb7-45b0-9fbc-76a94cb4039a

InnerException: Cannot insert the value NULL into column 'EnableModNotification', table 'SQL2008R2_160186_ibidb01.dbo.dnn1_Forum_Users'; column does not allow nulls. INSERT fails. The statement has been terminated.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.Data.SqlClient.SqlConnection.

StackTrace:

Message: System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'EnableModNotification', table 'SQL2008R2_160186_ibidb01.dbo.dnn1_Forum_Users'; column does not allow nulls. INSERT fails. The statement has been terminated. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Forum.SqlDataProvider.UserAdd(Int32 UserId, Int32 UserAvatar, String Avatar, String AdditionalAvatars, String Signature, Boolean IsTrusted, Boolean EnableOnlineStatus, Int32 ThreadsPerPage, Int32 PostsPerPage, Boolean EnablePublicEmail, Int32 PortalID) at DotNetNuke.Modules.Forum.ForumUserController.SetForumUser(Int32 UserID, Int32 PortalID, Int32 ModuleID) at DotNetNuke.Modules.Forum.ForumUserController.UserGetCallBack(CacheItemArgs cacheItemArgs) ClientConnectionId:f2ca05f5-71e3-4938-b795-188c814aba99

Source:

Server Name: IBIDEV01


Best Regards Peter
 
New Post
11/29/2013 8:01 PM
 

Just to add to this...I have another DNN test portal that I did the same updates on. The forum users has the same field set to not nullable and the forum upgrade almost worked on this second forum on this second portal.

The outstanding issue remains that even on the second forum as the host I do not get a a forum admin option when I mouse over "manage". So I can't manage the forums or do anything with them. Also  the suffix if the images is set to .png and so I can't get to the setting to set it to .gif via  the admin button....

All ideas welcome. I can't believe that this has been an outstanding issue for more than 12 months and no one else here has seen it....that would be surprising.


Best Regards Peter
 
New Post
11/29/2013 8:31 PM
 

The line that I think is causing the error is  DotNetNuke.Modules.Forum.SqlDataProvider.UserAdd.

Which does not have EnableModNotification mentioned. I am bemused as to how the same installed module can work on one portal and not another...I am guessing that the  EnableModNotification  is being set to the value of another field as a default and that in the portal that is failing this field is set to null some how. But I can't figure out where to look for where that other field might come from..I thought it might be in this SP but it seems not.

CREATE PROCEDURE [dbo].[dnn1_Forum_User_Add]
    (
      @UserID INT,
      @UserAvatar INT,
      @Avatar NVARCHAR(255),
      @AdditionalAvatars NVARCHAR(255),
      @Signature NVARCHAR(1024),
      @IsTrusted BIT,
      @EnableOnlineStatus BIT,
      @ThreadsPerPage INT,
      @PostsPerPage INT,
      @EnablePublicEmail BIT,
      @PortalID INT
    )
AS 
    IF NOT EXISTS ( SELECT  [UserID]
                    FROM    dbo.dnn1_Forum_Users
                    WHERE   [UserID] = @UserID
                            AND PortalID = @PortalID ) 
        BEGIN
            INSERT  INTO dbo.dnn1_Forum_Users
                    (
                      [UserID],
                      [UserAvatar],
                      [Avatar],
                      [AdditionalAvatars],
                      [Signature],
                      [IsTrusted],
                      [EnableOnlineStatus],
                      [ThreadsPerPage],
                      [PostsPerPage],
                      [EmailFormat],
                      [PortalID],
                      [EnablePublicEmail]
             )
            VALUES  (
                      @UserID,
                      @UserAvatar,
                      @Avatar,
                      @AdditionalAvatars,
                      @Signature,
                      @IsTrusted,
                      @EnableOnlineStatus,
                      @ThreadsPerPage,
                      @PostsPerPage,
                      1,
                      @PortalID,
                      @EnablePublicEmail
             )
        END

GO




Best Regards Peter
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumerror installing Forum Module 5.0.3 on DNN6error installing Forum Module 5.0.3 on DNN6


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.