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 ---

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

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