Running Umbaco 7.4.1. I have successfully installed Umbraco Forms 4.2.1. I do have a license. I can create one form. I can also copy it. But I can't create more than one form. I also cannot edit any form or create any workflows. When I check the logs, I see this error:
Error executing query INSERT INTO UFuserformsecurity([user], form, hasaccess, securitytype, allowineditor) VALUES(@user, @form, @hasaccess, @securitytype, @allowineditor)
System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FKUFUserFormSecurityUFForms". The conflict occurred in database "UmbracoUpgradeTest", table "dbo.UFForms", column 'Id'.
I understand this is a foreign key constraint issue. How do I resolve it? Does anyone have any ideas? It may be pertinent to know I recently upgrade from v6.1.0 to v7.4.1. I was previously using Contour. I have been working on this upgrade for quite some time now. Contour has been causing a lot of headaches. I am attempting to not bring over any Contour stuff and just start fresh with Forms. While I did exclude any Contour files, I didn't do so for any Contour tables in the DB. I figured it wouldn't cause any issues. I may be wrong.
I figured it out. I had to delete all the old Contour tables. Apparently the new Umbraco Forms uses the same namings of various tables and primary/foreign keys as Contour (which does make sense). I am a bit surprised that this wouldn't have been considered when developing the package. Oh well.
So yea, deleting all the old Contour tables (which all start with 'UF') and then doing the install seems to have cleared up the issue.
And we also had to remove a couple of the old foreign key contraints:
[dbo].[UFForms][FKUFFormsUFDataSources]
[dbo].[UFUserFormSecurity] [FKUFUserFormSecurityUFForms]
Comparing our database to a fresh install of v7 it looks like a lot of the old contur/forms tables are now defunct and can probably be binned. But that's for another day :)
Umbraco Forms Error
Running Umbaco 7.4.1. I have successfully installed Umbraco Forms 4.2.1. I do have a license. I can create one form. I can also copy it. But I can't create more than one form. I also cannot edit any form or create any workflows. When I check the logs, I see this error:
Error executing query INSERT INTO UFuserformsecurity([user], form, hasaccess, securitytype, allowineditor) VALUES(@user, @form, @hasaccess, @securitytype, @allowineditor) System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FKUFUserFormSecurityUFForms". The conflict occurred in database "UmbracoUpgradeTest", table "dbo.UFForms", column 'Id'.
I understand this is a foreign key constraint issue. How do I resolve it? Does anyone have any ideas? It may be pertinent to know I recently upgrade from v6.1.0 to v7.4.1. I was previously using Contour. I have been working on this upgrade for quite some time now. Contour has been causing a lot of headaches. I am attempting to not bring over any Contour stuff and just start fresh with Forms. While I did exclude any Contour files, I didn't do so for any Contour tables in the DB. I figured it wouldn't cause any issues. I may be wrong.
I figured it out. I had to delete all the old Contour tables. Apparently the new Umbraco Forms uses the same namings of various tables and primary/foreign keys as Contour (which does make sense). I am a bit surprised that this wouldn't have been considered when developing the package. Oh well.
So yea, deleting all the old Contour tables (which all start with 'UF') and then doing the install seems to have cleared up the issue.
Hello,
Just in case anyone else has this issue. We upgraded an old site (v4) to v7 and have upgraded forms where it used to be contour.
We found some issues where we had to add 2 id columns to 2 tables - as per this issue: http://issues.umbraco.org/issue/CON-1133
And we also had to remove a couple of the old foreign key contraints: [dbo].[UFForms][FKUFFormsUFDataSources] [dbo].[UFUserFormSecurity] [FKUFUserFormSecurityUFForms]
Comparing our database to a fresh install of v7 it looks like a lot of the old contur/forms tables are now defunct and can probably be binned. But that's for another day :)
Kenny
is working on a reply...