Hi,
I'm getting an error just when trying to place the forum module on a page. This is on DNN 5.6.7 using Forum 5.0.2. Any insights would be helpful. The error is:
InnerException: Cannot insert the value NULL into column 'EnableModNotification', table 'databasename.dbo.Rel_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 'databasename.dbo.Rel_Forum_Users'; column does not allow nulls. INSERT fails. The statement has been terminated.at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)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)at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)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.UserAdd(ForumUserInfo User)at DotNetNuke.Modules.Forum.ForumUserController.SetForumUser(Int32 UserID, Int32 PortalID, Int32 ModuleID)at DotNetNuke.Modules.Forum.ForumUserController.UserGetCallBack(CacheItemArgs cacheItemArgs)
Source: