I am using DNN 7.0.5, SQL 2012, DF version 4.10.4.23731

If I enter some data and then use the Save for Later link, then come back and add data to the form, I get an error when submitting the form. I get this error repeated over and over for each field in the form:

An error has occurred. DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'DynamicForms_QuestionResponse'. ---> System.Data.SqlClient.SqlException: Invalid object name 'DynamicForms_QuestionResponse'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() 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) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DataSprings.Modules.DynamicForms.SqlDataProvider.UpdateDynamicResponse(Guid ResponseID, Guid QuestionID, String Response, String ResponseText, Int32 UserID, Guid UniqueResponseID, Int32 intSaveForLater) at DataSprings.Modules.DynamicForms.DynamicResponseController.UpdateDynamicResponse(DynamicResponseInfo MyResponse) at DataSprings.Modules.DynamicForms.DynamicForms.SaveTheResponses(Boolean blnSaveForLater) --- End of inner exception stack trace ---

Hello Julie,

What does the save for later link look like? Sounds like this link isn't being generated correctly. Can you please paste the Save for Later link? Just replace your real URL for a fake URL.

Please let me know.

Thanks,

Ryan

http://mysite.idaho.gov/DataEntryFo...fault.aspx

When you hit save for later, it does add the data you entered into the database and shows up in the "View Form Results" you just can't come back to it using the above link.

Hello Julie,

The URL looks to be in the correct format for EDITING.


If you go to View Form Results and Click the Edit link, can you please compare that URL versus the Save For Later URL?

They should be very similar, if not identical.

Please let me know your findings.

Thanks,

Ryan

Hi Ryan -

Yes, the Save for Later URL and the edit form results URL are the same.
I used the $(EditURL) token in the completion event as the link to send to the user to come back and finish completing the form. Is there a different token/link to send them to?

Also, for what it's worth, if I try to go into any of the form result entries and try to edit them, I get the same error (which makes sense seeing as it is the same link to edit an entry as it is to come back to the form via the Save for Later button...)

Hello Julie,

I haven't seen this issue reported with DF 4.1.4 and DNN 7.0.5. If you're even unable to edit the results from the View form Results interface, this turns my attention to the actual data saved for your Dynamic Form.

To test, can you please add a new Dynamic Form to a new page. Give this Dynamic Form 3 fields(FirstName, LastName and Email). Then submit this form several times, and see if you can edit the responses from the View Form Results interface.

Do you receive the same error? Or does this populate the form accordingly?

Please let me know.

Thanks,

Ryan

Hi Ryan -
I created a new form, both in our qual environment which sits behind the same firewalls and security appliances as our production site, and in our dev environment which sits behind nothing and got the same results with both. This was a simple form with just First Name, Last Name, and Email Address. When I go into View Form Results, then choose an entry and click on Edit and make a change, hit submit, I recieve a page full of error messages.

Hello Julie,

Can you please open a support ticket with us? I think this is going to require more attention than the forums have to offer. Please go to http://store.dnnsoftware.com and sign into your account. You can then navigate to your downloads and open up a support ticket for Dynamic Forms.

Please let me know if you have any questions.

Thanks,

Ryan