search

umbraco / Umbraco.Forms.Issues

Public issue tracker for Umbraco Forms
30 stars 0 forks source link

Issue when saving a node when form is added to RTE. #1139

Closed wonderwilson closed 4 months ago

wonderwilson commented 10 months ago

When saving a node in Umbraco 12 with a form added to the RTE, the following error is displayed: Cannot insert duplicate key row in object 'dbo.umbracoRelation' with unique index 'IX_umbracoRelation_parentChildType'. The duplicate key value is (2267, 2271, 6). The statement has been terminated.

Reproduction

If you're filing a bug, please describe how to reproduce it. Include as much relevant information as possible, such as:

Bug summary

Specifics

Steps to reproduce

Expected result

Actual result

AndyButland commented 10 months ago

I think this is a duplicate of the issue reported here - but with the additional information that the problem arises with the rich text editor as well as the block list. Fundamentally this is an issue that needs to be solved in the CMS, but there are a couple of workarounds described in the meantime in the linked issue and we'll be picking this up further next week.

AndyButland commented 10 months ago

We're picking up this issue to see if it can be solved in the CMS, but in the meantime, as of the next patch release, we'll add a configuration option to allow for disabling of tracking form relations. It will be applied as follows:

"Umbraco": {
  "Forms": {,
    "Options": {
      "DisableRelationTracking": true
    },
  }
}
AndyButland commented 4 months ago

Closing this one now as related issues are closed and CMS updates released.