I am getting an error when committing a new post: I assume this is happening when I am posting to a thread that I am already tracking. Perhaps a post or edit of an existing thread should check to see if notification is already in place and if so it should be an update rather than insert this way you can remove notification of the thread if you want.

InnerException: Violation of PRIMARY KEY constraint 'PK_Forum_TrackedThreads'. Cannot insert duplicate key in object 'dbo.Forum_TrackedThreads'. The statement has been terminated.
FileName: 
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace: 
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Violation of PRIMARY KEY constraint 'PK_Forum_TrackedThreads'. Cannot insert duplicate key in object 'dbo.Forum_TrackedThreads'. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Forum_TrackedThreads'. Cannot insert duplicate key in object 'dbo.Forum_TrackedThreads'. The statement has been terminated.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.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.TrackingThreadCreateDelete(Int32 ForumID, Int32 ThreadID, Int32 UserID, Boolean Add, Int32 ModuleID)at DotNetNuke.Modules.Forum.TrackingController.TrackingThreadCreateDelete(Int32 ForumID, Int32 ThreadID, Int32 UserID, Boolean Add, Int32 ModuleID)at DotNetNuke.Modules.Forum.PostConnector.PostToDatabase(Int32 TabID, Int32 ModuleID, Configuration objConfig, Int32 PortalID, ForumUserInfo objForumUser, String PostSubject, String PostBody, ForumInfo objForum, Int32 ParentPostID, Int32 PostID, Boolean IsPinned, Boolean IsClosed, Boolean ReplyNotify, ThreadStatus Status, String lstAttachmentFileIDs, String RemoteAddress, Int32 PollID, Int32 ThreadID, PostAction objAction, Boolean IsModerated, List`1 Terms)at DotNetNuke.Modules.Forum.PostConnector.PostingValidation(Int32 TabID, Int32 ModuleID, Int32 PortalID, Int32 UserID, String PostSubject, String PostBody, Int32 ForumID, Int32 ParentPostID, Int32 PostID, Boolean IsPinned, Boolean IsClosed, Boolean ReplyNotify, ThreadStatus Status, String lstAttachmentFileIDs, String RemoteAddress, Int32 PollID, Boolean IsQuote, String Provider, Int32 ThreadID, List`1 Terms)at DotNetNuke.Modules.Forum.PostConnector.SubmitInternalPost(Int32 TabID, Int32 ModuleID, Int32 PortalID, Int32 UserID, String PostSubject, String PostBody, Int32 ForumID, Int32 ParentPostID, Int32 PostID, Boolean IsPinned, Boolean IsClosed, Boolean ReplyNotify, ThreadStatus Status, String AttachmentFileIDs, String RemoteAddress, Int32 PollID, Boolean IsQuote, Int32 ThreadID, List`1 Terms)at DotNetNuke.Modules.Forum.PostEdit.cmdSubmit_Click(Object sender, EventArgs e)--- End of inner exception stack trace ---
Source: 

this must be a local issue for me.  I modified the editpost.ascx file and set the property for "checked" to true. so I can get the default selection on notification to be checked.  I guess this may be causing an issue in situations where the user is already subscribed.  In your code it looks like you shut off the property. Can you add something programmatically that will allow the admin to select the default notification on of off for new posts and replies so I dont have to do it in the ascx file?

Hi Joiseystud good input.