Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Performance and...Performance and...Turbo Script problems enter a pos yaf forum .Turbo Script problems enter a pos yaf forum .
Previous
 
Next
New Post
4/30/2016 4:42 AM
 
hi,

After applying Turbo Scripts 0.9.9 for DNN 7.1.2 - 8.0.1V scripts on the site.

YAF module was in trouble. The problem appears when I enter a post on the YAF forum.

How do we solve this problem?
Error Msg:


Message:The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Journal_Security_Jour
nal". The conflict occurred in database "Portal_DB", table "dbo.Journal", column 'JournalId'. 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. The statement has been terminated.


 
New Post
4/30/2016 8:49 AM
 
would you mind to provide the full stack trace?
it sounds to me that there is an issue in DNNYAF, creating child records without a master record.
this doesn't show up in DNN default, because the Journal developers forgot to add indexes and constraints to their tables, which are added by TurboScripts to improve integrity.

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
5/3/2016 3:17 AM
 
How do we solve this problem? ????
 
New Post
5/3/2016 6:11 AM
 
please post full stack trace of this error from DNN Eventlog.
You may drop the constraint by running
ALTER TABLE dbo.Journal_Security DROP CONSTRAINT FK_Journal_Security_Journal;

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
5/3/2016 6:30 AM
 
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:
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Performance and...Performance and...Turbo Script problems enter a pos yaf forum .Turbo Script problems enter a pos yaf forum .


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Content Layout

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out