help me with an error: Exception of type 'System.Web.HttpUnhandledException' was thrown.

Nov 16, 2010 at 12:11 PM

my host tried a server transfer. but it ruined some things.

I get this error when I want to delete spam messages.

I guess something in the DB has become corrupt. can you please help me to find it?

 

 

Message : Exception of type 'System.Web.HttpUnhandledException' was thrown.

Source : System.Web

StackTrace : at System.Web.UI.Page.HandleError(Exception e)

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

at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

at System.Web.UI.Page.ProcessRequest()

at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)

at System.Web.UI.Page.ProcessRequest(HttpContext context)

at ASP.admin_comments_spam_aspx.ProcessRequest(HttpContext context)

at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

TargetSite : Boolean HandleError(System.Exception)

Message : Cannot insert the value NULL into column 'PostNotifyID', table 'sepidweb_ir_sepidweb-english.dbo.be_PostNotify'; column does not allow nulls. INSERT fails.

The statement has been terminated.

Source : .Net SqlClient Data Provider

StackTrace : 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 BlogEngine.Core.Providers.DbBlogProvider.UpdateNotify(Post post, DbConnection conn, DbProviderFactory provider) in C:\Data\Development\BlogEngine.NET\BlogEngine\DotNetSlave.BusinessLogic\Providers\DbBlogProvider.cs:line 2037

at BlogEngine.Core.Providers.DbBlogProvider.UpdatePost(Post post) in C:\Data\Development\BlogEngine.NET\BlogEngine\DotNetSlave.BusinessLogic\Providers\DbBlogProvider.cs:line 450

at BlogEngine.Core.Providers.BlogService.UpdatePost(Post post) in C:\Data\Development\BlogEngine.NET\BlogEngine\DotNetSlave.BusinessLogic\Providers\BlogService.cs:line 113

at BlogEngine.Core.Post.DataUpdate() in C:\Data\Development\BlogEngine.NET\BlogEngine\DotNetSlave.BusinessLogic\Post.cs:line 816

at BlogEngine.Core.Post.RemoveComment(Comment comment) in C:\Data\Development\BlogEngine.NET\BlogEngine\DotNetSlave.BusinessLogic\Post.cs:line 741

at admin_Comments_DataGrid.RemoveComment(Comment comment)

at admin_Comments_DataGrid.ProcessSelected(ActionType action)

at admin_Comments_DataGrid.btnDelete_Click(Object sender, EventArgs e)

at System.Web.UI.WebControls.Button.OnClick(EventArgs e)

at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)

at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)

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

at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

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

TargetSite : Void OnError(System.Data.SqlClient.SqlException, Boolean)

Nov 16, 2010 at 2:03 PM
Edited Oct 24, 2011 at 5:11 PM

The problem is a null reference:

 

Message : Cannot insert the value NULL into column 'PostNotifyID', table 'sepidweb_ir_sepidweb-english.dbo.be_PostNotify'; column does not allow nulls. INSERT fails.

 

The updating a post is not working.  Thats all I can tell you.

 

Someone else here will find a solution for you :)

Java Blog