Is this a form containing a checkboxlist? If so I'm pretty sure it's this issue http://issues.umbraco.org/issue/CON-98 to fix just run the sql snippet found in the comments of that issue (was a bug in that version of Contour)
Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery
appearing in place of the form.
I see a post suggesting I run this script on the DB. WHould that help?
CREATE CLUSTERED INDEX [UFFieldSettings_Index] ON [UFFieldSettings]([Field]) CREATE CLUSTERED INDEX [UFRecordDataBit_Index] ON [UFRecordDataBit]([Key]) CREATE CLUSTERED INDEX [UFRecordDataDateTime_Index] ON [UFRecordDataDateTime]([Key]) CREATE CLUSTERED INDEX [UFRecordDataInteger_Index] ON [UFRecordDataInteger]([Key]) CREATE CLUSTERED INDEX [UFRecordDataLongString_Index] ON [UFRecordDataLongString]([Key]) CREATE CLUSTERED INDEX [UFRecordDataString_Index] ON [UFRecordDataString]([Key])
Error when submitting: exception in ExecuteNonQuery
Hi,
I'm getting this error then submitting a contour form:
Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery
I'm using this build UmbracoContour_3.0.13 WIP.zip with Umbraco 6.0.6
Anyone had any experience with this?
Thanks for any help
Scott
Comment author was deleted
Hey Scott,
Is this a form containing a checkboxlist? If so I'm pretty sure it's this issue http://issues.umbraco.org/issue/CON-98 to fix just run the sql snippet found in the comments of that issue (was a bug in that version of Contour)
Actual I get the same error with the simplist of forms, name, email.
I haven't been able to get contour working with Azure at all.
Comment author was deleted
Hi Scott,
Could you try latest stable version that's v 3.0.14 there have been some updates in regards to azure in that one
Same error: after submitting I get the text:
Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery
appearing in place of the form.
I see a post suggesting I run this script on the DB. WHould that help?
CREATE CLUSTERED INDEX [UFFieldSettings_Index] ON [UFFieldSettings]([Field])
CREATE CLUSTERED INDEX [UFRecordDataBit_Index] ON [UFRecordDataBit]([Key])
CREATE CLUSTERED INDEX [UFRecordDataDateTime_Index] ON [UFRecordDataDateTime]([Key])
CREATE CLUSTERED INDEX [UFRecordDataInteger_Index] ON [UFRecordDataInteger]([Key])
CREATE CLUSTERED INDEX [UFRecordDataLongString_Index] ON [UFRecordDataLongString]([Key])
CREATE CLUSTERED INDEX [UFRecordDataString_Index] ON [UFRecordDataString]([Key])
Comment author was deleted
Yeah give it a try, I'll also take a look this week so 3.0.15 will be out and should work on azure
For anyone experiencing the same issues that script worked a treat. Contact forms are now working for me on Azure.
Comment author was deleted
Sweet thanks for confirming :)
is working on a reply...