Looking for the old forum?

For topics posted before June 2015, please click here to visit the old support forum. Post your questions in this forum if you have any questions.

Support Forums
PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 30 Oct 2015 05:46 PM by  Josiah Olhava
Errors when saving and deleting
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages


New Member


Posts:40
New Member


--
30 Oct 2015 05:46 PM
    Hi,
    Often when I edit and save or delete an event it gives me an error. It is happening frequently. Please

    Here is what it says in the Event Viewer:

    ******************FIRST EXAMPLE*************************
    Referrer:http://sonomalighthouse.com/Event-C.../ItemId/26

    UserAgent:Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.80 Safari/537.36

    ExceptionHash:WJDYHK2phbwchIG/waFzCA==

    Message:The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_Journal_ContentItems". The conflict occurred in database "DNN7", table "dbo.ContentItems", column 'ContentItemID'. The statement has been terminated.

    StackTrace:

    InnerMessage:The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_Journal_ContentItems". The conflict occurred in database "DNN7", table "dbo.ContentItems", column 'ContentItemID'. The statement has been terminated.

    InnerStackTrace:

    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
    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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at PetaPoco.Database.Execute(String sql, Object[] args)
    at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteNonQuery(String connectionString, CommandType type, String sql, Object[] args)
    at DotNetNuke.Services.Journal.JournalDataServiceImpl.Journal_UpdateContentItemId(Int32 journalId, Int32 contentItemId)
    at DotNetNuke.Services.Journal.JournalControllerImpl.SaveJournalItem(JournalItem journalItem, Int32 tabId, Int32 moduleId)
    at BizModules.FlexEvents.IntegrationController.EnsurePostToGroup(EventInfo objEvent)
    at BizModules.FlexEvents.EventController.Update(EventInfo objEvent)
    at BizModules.FlexEvents.AddEvent.lnkUpdate_Click(Object sender, EventArgs e)
    at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)
    at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)




    ******************SECOND EXAMPLE*************************
    Referrer:http://sonomalighthouse.com/Event-C...s/mid/4475

    UserAgent:Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.80 Safari/537.36

    ExceptionHash:er1xCP6C8FG98fx+kAQZqQ==

    Message:The DELETE statement conflicted with the REFERENCE constraint "FK_FlexBooking_FlexOccurance". The conflict occurred in database "DNN7", table "dbo.FlexBooking", column 'OccuranceId'. The statement has been terminated.

    StackTrace:

    InnerMessage:The DELETE statement conflicted with the REFERENCE constraint "FK_FlexBooking_FlexOccurance". The conflict occurred in database "DNN7", table "dbo.FlexBooking", column 'OccuranceId'. The statement has been terminated.

    InnerStackTrace:

    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
    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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    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 BizModules.FlexEvents.DataProvider.DeleteEvent(Int32 itemId)
    at BizModules.FlexEvents.EventController.Delete(Int32 itemId)
    at BizModules.FlexEvents.Events.lst


    Basic Member


    Posts:240
    Basic Member


    --
    01 Nov 2015 01:14 PM
    Regarding to the 1st error, I am not sure why it happens because it comes from DNN core, I can choose to catch it and simply ignore it, but I think this might not be a good idea because it might hide some useful information.

    Regarding to the 2nd error, you were not supposed to delete this event because it has booking records. However, I'll change it so it won't fire such a unfriendly message. The fix will be included in version 1.7.8.


    New Member


    Posts:40
    New Member


    --
    01 Nov 2015 02:17 PM
    Ah ok that second one makes sense but I agree the error message should indicate the reason as you said.


    Basic Member


    Posts:240
    Basic Member


    --
    09 Nov 2015 08:23 AM
    Just let you know version 1.7.8 is already available.

    Good luck.


    New Member


    Posts:40
    New Member


    --
    09 Nov 2015 11:01 AM
    Thanks for the update. I just installed it.

    You are not authorized to post a reply.


    Copyright © 2005-2013 BizModules Contact us