> Forums > Active Forums > Community Support > Error in Deleting a Reply
Last Post 21 Jul 2011 02:30 PM by Will Morgenweck. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
dennis
Registered Users
dennis
Post Count:

--
21 Jul 2011 08:46 AM
    • Active Forums Version: 4.3.5
    • DotNetNuke Version: 5.6.1
    When attempting to delete a reply the following error is logged:
    Message: System.Exception: Unhandled Error: ---> System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_activeforums_ForumTopics_activeforums_Replies". The conflict occurred in database "nrc_test", table "dbo.activeforums_ForumTopics", column 'LastReplyId'. The DELETE statement conflicted with the REFERENCE constraint "FK_activeforums_Replies_activeforums_Content". The conflict occurred in database "nrc_test", table "dbo.activeforums_Replies", column 'ContentId'. The statement has been terminated. 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 Active.Modules.Forums.SqlDataProvider.Reply_Delete(Int32 ForumId, Int32 TopicId, Int32 ReplyId, Int32 DelBehavior) at Active.Modules.Forums.Handlers.forumhelper.DeletePost() at Active.Modules.Forums.Handlers.forumhelper.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --- End of inner exception stack trace ---
    Will Morgenweck Forum Admin
    DotNetNuke Staff
    Will Morgenweck
    Post Count:7672

    --
    21 Jul 2011 02:30 PM
    Only time we have seen this happen is when someone imported data into our table or directly manipulated the database. Does this happen on a topic that was created within Active Forums?
    Will Morgenweck
    Director of Product Management
    DotNetNuke Corp.
    You are not authorized to post a reply.
    > Forums > Active Forums > Community Support > Error in Deleting a Reply
    test
    Copyright 2012 by DotNetNuke Corporation / Terms of Use / Privacy