caiman8
  •  caiman8
  • 53.6% (Neutral)
  • YAF Forumling Topic Starter
2010-12-25T21:50:57Z
Hi, I recently got my website, including the YAF forum, onto its production server with Godaddy.com. It took me a while to get the database working, but I eventually got the forum to work. Everything seemed fine until I tried to post a new thread. I get this error:

"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.
Sponsor
squirrel
2010-12-26T00:39:49Z
One thing you will need to do is to turn off custom errors in your web.config file for YAF. This will give you the detailed results of the error.

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 --
If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend 
caiman8
  •  caiman8
  • 53.6% (Neutral)
  • YAF Forumling Topic Starter
2010-12-26T22:56:02Z
Looks like custom errors are already set to "off". 😕

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.
squirrel
2010-12-26T23:19:22Z
Originally Posted by: caiman8 

Looks like custom errors are already set to "off". 😕

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 --
If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend 
caiman8
  •  caiman8
  • 53.6% (Neutral)
  • YAF Forumling Topic Starter
2010-12-27T16:36:11Z
My version of YAF is 1.9.5 RC1.

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
squirrel
2010-12-28T00:47:34Z
You will want to get the 1.9.5 RTM release from CodePlex - the sourceforge link is outdated. I don't have the direct link handy but it has been posted here in the forums. Be sure to run the /install/default.aspx script and follow the upgrade instructions for merging/selecting your web.config file from your existing configuration.

Once you get up to the latest version, we can get into trying to sort out the errors you are having.
If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend 
caiman8
  •  caiman8
  • 53.6% (Neutral)
  • YAF Forumling Topic Starter
2010-12-29T18:37:00Z
I installed the new version, and the problem went away!

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

Thanks for your time.
squirrel
2010-12-30T00:28:37Z
Originally Posted by: caiman8 

I installed the new version, and the problem went away!

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 🙂
If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend 
Jaben
  •  Jaben
  • 100% (Exalted)
  • YAF Developer
2010-12-30T21:06:53Z
Originally Posted by: squirrel 

Originally Posted by: caiman8 

I installed the new version, and the problem went away!

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.
SilhouetteBS
2010-12-30T21:24:39Z
Originally Posted by: Jaben 

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?
Jaben
  •  Jaben
  • 100% (Exalted)
  • YAF Developer
2010-12-31T02:12:27Z
Originally Posted by: SilhouetteBS 

Originally Posted by: Jaben 

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.

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved