Can't edit forms after upgrading from 4.2.2 to 7.05
Hi people,
I've upgraded Umbraco from 7.3.8 to 7.12.3 and Umbraco Forms from 4.22 to 7.05. Apart from many other issues I'm not able to edit a from in the backoffice, when I click on any nothing is displayed and there's an error in the console for the following request:
ExceptionMessage: "Sequence contains more than one matching element"
ExceptionType: "System.InvalidOperationException"
Looking at the stacktrace the error is thrown by the SingleOrDefault() function of the IEnumerable interface when trying to retrieve the forms for the given user. I already checked the db and there is no duplicates for this user (neither for others) and don't know what else to check. Any ideas?
PS: Db and App Service on Azure. Works fine locally pointing to the same db though
I had this error message and I had form entries with the same id. The error is basically correct, shame it doesn't give a clue to where the duplicates are.
HTH
t
Can't edit forms after upgrading from 4.2.2 to 7.05
Hi people,
I've upgraded Umbraco from 7.3.8 to 7.12.3 and Umbraco Forms from 4.22 to 7.05. Apart from many other issues I'm not able to edit a from in the backoffice, when I click on any nothing is displayed and there's an error in the console for the following request:
https://mydomain/umbraco/backoffice/UmbracoForms/FormSecurity/GetByUserId?userId=30 500 (Internal Server Error)
Looking at the stacktrace the error is thrown by the SingleOrDefault() function of the IEnumerable interface when trying to retrieve the forms for the given user. I already checked the db and there is no duplicates for this user (neither for others) and don't know what else to check. Any ideas?
PS: Db and App Service on Azure. Works fine locally pointing to the same db though
I had this error message and I had form entries with the same id. The error is basically correct, shame it doesn't give a clue to where the duplicates are. HTH t
Thanks Tom but as I said, there's no duplicate form entries. It's got to be something with the environment since it works fine locally.
Hi Germán,
You'll likely find a duplicate entry in the UFUserFormSecurity table. The combination of UserId and Form will be duplicated somewhere.
We have this bug across about many clients and servers so it's not your installation, it's just some combinations of actions that causes it to happen.
Hope this fixes it.
Hi Simon, thanks for your answer, however there is no duplicate either with same combination of Form and UserId in that table.
is working on a reply...