Hi Joe, we're getting an error when trying to delete orphan responses in Form Wizard Pro 2.6.0.5. Actually I don't think we've ever been able to delete orphan responses through the interface, but I've had it back-burnered until now.
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'rs.ResponseSetGuid' in 'field list'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(MySqlConnection connection, String commandText, MySqlParameter[] commandParameters)
at MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(String connectionString, String commandText, MySqlParameter[] parms)
at sts.FormWizard.Data.DBWebFormResponse.DeleteOrphansByForm(Guid formGuid)
at sts.FormWizard.Web.UI.FormResultsPage.btnDeleteOrphans_Click(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Thanks,
Jamie