Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Scott Robinson 54 posts 75 karma points
    Jul 01, 2013 @ 17:04
    Scott Robinson
    0

    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

    Jul 01, 2013 @ 17:25

    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)

  • Scott Robinson 54 posts 75 karma points
    Aug 11, 2013 @ 13:47
    Scott Robinson
    0

    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

    Aug 12, 2013 @ 10:58

    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

  • Scott Robinson 54 posts 75 karma points
    Aug 12, 2013 @ 11:31
    Scott Robinson
    0

    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

    Aug 12, 2013 @ 11:34

    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

  • Scott Robinson 54 posts 75 karma points
    Aug 12, 2013 @ 11:45
    Scott Robinson
    0

    For anyone experiencing the same issues that script worked a treat. Contact forms are now working for me on Azure.

  • Comment author was deleted

    Aug 12, 2013 @ 11:46

    Sweet thanks for confirming :)

Please Sign in or register to post replies

Write your reply to:

Draft