Server error when replying to 'For sale' items

Forum & Website [Discussion &Technical Issues] Forum & Website Technical Discussion
2

Getting this error when trying to reply to ‘For sale’ items.

 

Server Error in '/' Application.

Cannot insert the value NULL into column 'Indent', table 'yafoc_live.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 'Indent', table 'yafoc_live.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 'Indent', table 'yafoc_live.dbo.yaf_Message'; column does not allow nulls. INSERT fails.
The statement has been terminated.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2084358
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5096328
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2294
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +215
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
   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) +178
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
   YAF.Classes.Data.MsSqlDbAccess.ExecuteNonQuery(IDbCommand cmd, Boolean transaction) in D:websitesyafOCBetaYAF.ClassesYAF.Classes.DatamssqlMsSqlDbAccess.cs:445
   YAF.Types.Interfaces.IDbAccessExtensions.ExecuteNonQuery(IDbAccess dbAccess, IDbCommand cmd) in D:websitesyafOCBetaYAF.TypesInterfacesExtensionsIDbAccessExtensions.cs:48
   YAF.Classes.Data.LegacyDb.message_save(Object topicID, Object userID, Object message, Object userName, Object ip, Object posted, Object replyTo, Object flags, Int64& messageID) in D:websitesyafOCBetaYAF.ClassesYAF.Classes.DatamssqlLegacyDb.cs:5563
   YAF.Pages.postmessage.PostReplyHandleReplyToTopic(Boolean isSpamApproved) +929
   YAF.Pages.postmessage.PostReply_Click(Object sender, EventArgs e) +572
   YAF.Controls.ThemeButton.OnClick(EventArgs e) in D:websitesyafOCBetaYAF.ControlsThemeButton.cs:433
   YAF.Controls.ThemeButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) in D:websitesyafOCBetaYAF.ControlsThemeButton.cs:388
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +176
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563
 
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1008
3

I had that, had to shut down and reboot

4

This should now be sorted - it was caused by part of the data import not setting something correctly.

 

Edit:

  • thank you
5

It would appear to be so. ThanksSmile