"Cannot insert the value NULL into column 'IsModeratorChanged', table 'sm.dbo.yaf_Message'; column does not allow nulls. INSERT fails.

The statement has been terminated."

EDIT: I should specify that the error occurs right when I press the "post" button. I'm able to enter the message and preview the post. The error occurs at the moment of posting.

I also get this when I try to post a reply. I have changed nothing in the database.

Also, when I try to register a new account, I get this YAF-provided error: Failure

There's been a system error processing your request. Please contact the forum admin explaining what you were doing when it happened.

Continue..."

I typically search Google to find my answers, but this one wasn't producing many results. Anyone have any ideas? Thanks very much.

Inside web.config look for this line:

<customErrors defaultRedirect="Error.aspx" mode="On"/>

change to:

<customErrors defaultRedirect="Error.aspx" mode="Off"/>

Then when you get an exception, you will get the details of the exception. Developers will need more details to help diagnose your problem --

Could this error have something to do with application services (roles, profiles, etc)? The reason I ask is because, in order to get my asp.net page to have a user login, I configured my godaddy sql server database for application services using these directions . Could doing this have somehow screwed something up with YAF's application services? This is sort of a shot in the dark.

Given the two errors - not able to register new accounts and not able to post messages - it almost sounds like your database user account does not have write permissions to the database. You might want to check on that. Beyond that, the developers (I am not one) may need full details of your exception errors. I try to help where I can with what I know but some errors are beyond my knowledge -- I would post the full copy of the exception when it appears. The reason I mentioned custom errors tag is because you noted you were seeing the "General Error" page displayed by YAF when custom errors are set to on.

Let's get a full copy of the exception, the YAF version you are running and which error it is linked to (the adding a new user or posting a new topic) and maybe I can help more --

Here is the entire error for when I hit the Post button to reply to a thread:

Error in '/forum' Application.

Cannot insert the value NULL into column 'IsModeratorChanged', table 'sm.dbo.yaf_Message'; column does not allow nulls. INSERT fails.

The statement has been terminated.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'IsModeratorChanged', table 'sm.dbo.yaf_Message'; column does not allow nulls. INSERT fails.

The statement has been terminated.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Cannot insert the value NULL into column 'IsModeratorChanged', table 'sm.dbo.yaf_Message'; column does not allow nulls. INSERT fails.

The statement has been terminated.]

System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1953274

System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849707

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194

System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392

System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +204

System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954

System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162

System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175

System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137

YAF.Classes.Data.YafDBAccess.ExecuteNonQuery(SqlCommand cmd, Boolean transaction) in YafDBAccess.cs:451

YAF.Classes.Data.DB.message_save(Object topicID, Object userID, Object message, Object userName, Object ip, Object posted, Object replyTo, Object flags, Int64& messageID) in DB.cs:4254

YAF.Pages.postmessage.PostReplyHandleReplyToTopic() +491

YAF.Pages.postmessage.PostReply_Click(Object sender, EventArgs e) +566

System.EventHandler.Invoke(Object sender, EventArgs e) +0

YAF.Controls.ThemeButton.OnClick(EventArgs e) in ThemeButton.cs:417

YAF.Controls.ThemeButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) in ThemeButton.cs:275

System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13

System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +175

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Version Information: Microsoft .NET Framework Version:2.0.50727.4206; ASP.NET Version:2.0.50727.4016

Once you get up to the latest version, we can get into trying to sort out the errors you are having.

If the problem comes up again for whatever reason, I'll come back to this thread with an update.

Thanks for your time.

Excellent - glad the update cured that issue. I know there are a couple other issues with 1.9.5 but developers are working on them continually in order to get new version released -- I've seen many issues fixed in that last couple weeks so I'm sure 1.9.5.1 will be around soon with the fixes 🙂

We're working on it... but the version will be v1.9.5.5 since it's quite a bit different internally.

Any idea on when 1.9.5.5 will be available?

I put the roadmap ETA as next week. That's the goal as long as no major issues popup with it.

The release will be a BETA.