Copied to clipboard

Flag this post as spam?

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


  • Crawford Tait 11 posts 64 karma points
    Apr 24, 2015 @ 11:24
    Crawford Tait
    0

    Forms 4.1 - migrated forms become uneditable, possibly after a submission

    I migrated a multi-page Contour form successfully and was able to edit it to add prevalues back in etc, I also got the front end rendering working and everything was fine. However, on 2 or 3 occasions now, when I return to edit the form I find an error being thrown. I previously put this down to some glitch and re-migrated the form, but it happens repeatedly - I think possibly after the form has been submitted in the front end?

    Error is:

    System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'order'.

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

       at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

       at System.Data.SqlClient.SqlDataReader.get_MetaData()

       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)

       at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters)

       at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)

     

  • Crawford Tait 11 posts 64 karma points
    Apr 24, 2015 @ 13:34
    Crawford Tait
    0

    Seems to be intermittent!

  • Gerjan 19 posts 78 karma points
    Apr 24, 2015 @ 14:30
    Gerjan
    0

    I just happen to have the same error after i made a form (using Umbraco 7.2.4 Forms 4.1) with a worfklow action to create a node when Approved...

    After a test entry and approvel i get that error too. 

    //edit, after i made another test entry (this time with correct SMTP settings), it works again.. Strange

  • Gerjan 19 posts 78 karma points
    Apr 29, 2015 @ 13:19
    Gerjan
    0

    Hi Crawford did you get any answer somewhere?

  • Crawford Tait 11 posts 64 karma points
    Apr 29, 2015 @ 14:52
    Crawford Tait
    0

    No, but I noticed the saem as you - if I submit another entry it went away, not sure if it's toggling on form submissions!

  • Comment author was deleted

    May 06, 2015 @ 09:28

    Hey,

    Would it be possible to send me a copy of the site that is having the issue (tg at umbraco dot com) since I can't reproduce at the moment and would love to solve this bug

  • Gerjan 19 posts 78 karma points
    May 07, 2015 @ 21:49
    Gerjan
    0

    Hi Tim,

    What files etc do you need? All web files + db?

  • Comment author was deleted

    May 08, 2015 @ 10:22

    Yup but you can exlude /media and /app_data/temp , thanks

  • 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