run a query that has been said, but problems remain
full stack trace :
AbsoluteURL:/Default.aspx
DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID:a8be6a77-f54d-4be3-a64a-36be007c5428
AssemblyVersion:7.4.2
PortalId:0
UserId:1
TabId:91
RawUrl:/Forum/g/postmessage/f/17/forum-dnn
Referrer:
http://dnniasfr.org/Forum/g/postmessa...UserAgent:Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0
ExceptionHash:eIhBk0otPLHLEbvoivjjuw==
Message:The MERGE statement conflicted with the FOREIGN KEY constraint "FK_Journal_Data_Journal". The conflict occurred in database "Portal_DB", table "dbo.Journal", column 'JournalId'. The statement has been terminated.
StackTrace:
InnerMessage:The MERGE statement conflicted with the FOREIGN KEY constraint "FK_Journal_Data_Journal". The conflict occurred in database "Portal_DB", table "dbo.Journal", column 'JournalId'. The statement has been terminated.
InnerStackTrace:
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection. (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.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
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, Boolean describeParameterEncryptionRequest)
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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at PetaPoco.Database.ExecuteScalar[T](String sql, Object[] args)
at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteScalar[T](String connectionString, CommandType type, Int32 timeout, String sql, Object[] args)
at DotNetNuke.Data.SqlDataProvider.ExecuteScalar[T](String procedureName, Object[] commandParameters)
at DotNetNuke.Services.Journal.JournalDataServiceImpl.Journal_Save(Int32 portalId, Int32 currentUserId, Int32 profileId, Int32 groupId, Int32 journalId, Int32 journalTypeId, String title, String summary, String body, String itemData, String xml, String objectKey, Guid accessKey, String securitySet, Boolean commentsDisabled, Boolean commentsHidden)
at DotNetNuke.Services.Journal.JournalControllerImpl.SaveJournalItem(JournalItem journalItem, Int32 tabId, Int32 moduleId)
at DotNetNuke.Services.Journal.JournalControllerImpl.SaveJournalItem(JournalItem journalItem, Int32 tabId)
at YAF.DotNetNuke.Components.Integration.Journal.AddTopicToStream(Int32 forumID, Int64 topicID, Int32 messageID, String topicTitle, String message)
at YAF.Pages.postmessage.PostReply_Click(Object sender, EventArgs e)
at YAF.Controls.ThemeButton.OnClick(EventArgs e)
at YAF.Controls.ThemeButton.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)
Source:
FileName:
FileLineNumber:0
FileColumnNumber:0
Method: