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

  • Tim Geyssens 6562 posts 15373 karma points MVP 2x c-trib
    Jul 01, 2013 @ 17:25
    Tim Geyssens
    0

    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.

  • Tim Geyssens 6562 posts 15373 karma points MVP 2x c-trib
    Aug 12, 2013 @ 10:58
    Tim Geyssens
    0

    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])

  • Tim Geyssens 6562 posts 15373 karma points MVP 2x c-trib
    Aug 12, 2013 @ 11:34
    Tim Geyssens
    0

    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.

  • Tim Geyssens 6562 posts 15373 karma points MVP 2x c-trib
    Aug 12, 2013 @ 11:46
    Tim Geyssens
    0

    Sweet thanks for confirming :)

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies