So, I have this Contour form, where I can insert Name, Email and a Message. However, when I try to submit my form, I get the following error:
Server Error in '/' Application.
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_UFRecordDataString_UFRecordFields". The conflict occurred in database "DatabaseName", table "dbo.UFRecordFields", column 'Key'. The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_UFRecordDataString_UFRecordFields". The conflict occurred in database "DatabaseName", table "dbo.UFRecordFields", column 'Key'. The statement has been terminated.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Hmm that's strange, could you try saving the form in the backoffice, does that work or do you also get an error? And does it contain the same fields in the designer and when you output the form?
Error on submit
Hey Umbracians.
So, I have this Contour form, where I can insert Name, Email and a Message. However, when I try to submit my form, I get the following error:
Server Error in '/' Application.
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_UFRecordDataString_UFRecordFields". The conflict occurred in database "DatabaseName", table "dbo.UFRecordFields", column 'Key'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.The statement has been terminated.
Exception Details: System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_UFRecordDataString_UFRecordFields". The conflict occurred in database "DatabaseName", table "dbo.UFRecordFields", column 'Key'.
The statement has been terminated.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
Any clue?
Br
Dan
Comment author was deleted
Hmm what version of Contour are you running? + db engine (sql server, mysql) ? + did you perform an Contour upgrade recently ?
Contour version 3.0.9, SQL Server 2008 - and I have not done any upgrade recently.
Comment author was deleted
Hmm that's strange, could you try saving the form in the backoffice, does that work or do you also get an error? And does it contain the same fields in the designer and when you output the form?
I get no errors when saving the form. And yes, it does contain the same fields.
Comment author was deleted
Ok thanks for the extra details, any chance I can take a look at the site, you can mail details to tg at umbraco dot com
Hey Tim, thanks for helping out.
Solution: delete the old form and create a new one! :)
Comment author was deleted
Yeah must have gotten corrupted in some way but new forms and other existing forms worked fine...
is working on a reply...