An error occurs when submitting a survery that includes a free text option
Software Versions
DNN: 08.00.04
Module: 09.00.00
To Reproduce
Steps to reproduce the behavior:
Create a survey with a few single and multiple options questions
Add a free text option
Try to submit survey
Expected behavior
Survey should submit without errors
Screenshots
Error log
at System.Data.SqlClient.SqlBuffer.get_Boolean()
at System.Data.SqlClient.SqlDataReader.GetBoolean(Int32 i)
at petapoco_factory_0(IDataReader )
at PetaPoco.Database.d__21.MoveNext() at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)
at PetaPoco.Database.Fetch[T](String sql, Object[] args)
at DotNetNuke.Data.PetaPoco.PetaPocoDataContext.ExecuteQuery[T](CommandType type, String sql, Object[] args)
at DNN.Modules.Survey.Components.Controllers.SurveyResultsController.Get(Int32 surveyID) in D:\websites\vendors\DesktopModules\DNN.Survey\DNN.Survey\Components\Controllers\SurveyResultsController.cs:line 79
at DNN.Modules.Survey.SurveyResults.OnPreRender(EventArgs e) in D:\websites\vendors\DesktopModules\DNN.Survey\DNN.Survey\SurveyResults.ascx.cs:line 211
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Describe the bug
An error occurs when submitting a survery that includes a free text option
Software Versions
To Reproduce
Steps to reproduce the behavior:
Expected behavior
Survey should submit without errors
Screenshots
Error log
at System.Data.SqlClient.SqlBuffer.get_Boolean() at System.Data.SqlClient.SqlDataReader.GetBoolean(Int32 i) at petapoco_factory_0(IDataReader ) at PetaPoco.Database.d__2
1.MoveNext() at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at PetaPoco.Database.Fetch[T](String sql, Object[] args) at DotNetNuke.Data.PetaPoco.PetaPocoDataContext.ExecuteQuery[T](CommandType type, String sql, Object[] args) at DNN.Modules.Survey.Components.Controllers.SurveyResultsController.Get(Int32 surveyID) in D:\websites\vendors\DesktopModules\DNN.Survey\DNN.Survey\Components\Controllers\SurveyResultsController.cs:line 79 at DNN.Modules.Survey.SurveyResults.OnPreRender(EventArgs e) in D:\websites\vendors\DesktopModules\DNN.Survey\DNN.Survey\SurveyResults.ascx.cs:line 211 at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)