I've noticed a problem with the Form Entries Section.
The entries arn't showing up in the list and when you change either of the two filter dropdown lists, the "Processing..." message hangs and dosen't do anything. Details of the SqlHelperException from the Umbraco Log table below;
At
/umbraco/plugins/umbracocontour/webservices/records.aspx?guid=250dc9fe-4c8e-47bd-a698-b0460731b11e&date=14/12/2009%2009:06:23&state=Approved&sEcho=2&iColumns=18&sColumns=&iDisplayStart=0&iDisplayLength=10&sSearch=&bEscapeRegex=true&sSearch_0=&bEscapeRegex_0=true&sSearch_1=&bEscapeRegex_1=true&sSearch_2=&bEscapeRegex_2=true&sSearch_3=&bEscapeRegex_3=true&sSearch_4=&bEscapeRegex_4=true&sSearch_5=&bEscapeRegex_5=true&sSearch_6=&bEscapeRegex_6=true&sSearch_7=&bEscapeRegex_7=true&sSearch_8=&bEscapeRegex_8=true&sSearch_9=&bEscapeRegex_9=true&sSearch_10=&bEscapeRegex_10=true&sSearch_11=&bEscapeRegex_11=true&sSearch_12=&bEscapeRegex_12=true&sSearch_13=&bEscapeRegex_13=true&sSearch_14=&bEscapeRegex_14=true&sSearch_15=&bEscapeRegex_15=true&sSearch_16=&bEscapeRegex_16=true&sSearch_17=&bEscapeRegex_17=true&iSortingCols=1&iSortCol_0=1&iSortDir_0=desc
(Referred by:
http://www.esc.nsw.gov.au/umbraco/plugins/umbracocontour/editFormEntries.aspx?guid=250dc9fe-4c8e-47bd-a698-b0460731b11e):
umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer):
SQL helper exception in ExecuteScalar --->
System.Data.SqlClient.SqlException: The conversion of a char data type
to a datetime data type resulted in an out-of-range datetime value.
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(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
at System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue)
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
umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteScalar(String
commandText, SqlParameter[] parameters) in
d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:line
51
at umbraco.DataLayer.SqlHelper`1.ExecuteScalar[T](String
commandText, IParameter[] parameters) in
d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:line
194
--- End of inner exception stack trace ---
at umbraco.DataLayer.SqlHelper`1.ExecuteScalar[T](String
commandText, IParameter[] parameters) in
d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:line
198
at
Umbraco.Forms.Data.Storage.RecordsViewer.GetPagedXmlRecordsFromStorage(Int32
startIndex, Int32 lenght, Int32 umbracoPageId, Sorting sortOrder, Form
form, List`1 States, DateTime SinceDate, XmlDocument xd) in
d:\TeamCity\buildAgent\work\39da791f9304089a\Umbraco.Forms.Core\Data\RecordStorage\RecordsViewer.cs:line
141
at
Umbraco.Forms.Data.Storage.RecordsViewer.GetPagedXmlRecords(Int32
startIndex, Int32 lenght, Int32 umbracoPageId, Sorting sortOrder, Form
form, List`1 States, DateTime SinceDate, XmlDocument xd) in
d:\TeamCity\buildAgent\work\39da791f9304089a\Umbraco.Forms.Core\Data\RecordStorage\RecordsViewer.cs:line
299
at Umbraco.Forms.UI.Webservices.Records.ReturnRecords(Guid id,
DateTime date, FormState state, Int32 startIndex, Int32 lenght, Sorting
sortOrder) in
d:\TeamCity\buildAgent\work\39da791f9304089a\Umbraco.Forms.UI\Webservices\Records.aspx.cs:line
...
Contour 1.0.7 ready for testing
It is not a final release, but for those who want to preview/test, or is struggling with one of the issues it solves, here is a pre-release.
- It adds additional Css Classes to the form html
- Fixes the issue with forms with more then 2 steps
- The umbraco document prevalue source can use nodes from the current document (does not work in preview mode)
You can get it here:
http://nightly.umbraco.org/Umbraco%20Contour/1.0.7/UmbracoContour_1.0.7_633964705269159533.zip
And as an upgrade which should just be unzipped into the root of your site
http://nightly.umbraco.org/Umbraco%20Contour/1.0.7/UmbracoContour_1.0.7_633964705269159533_update.zip
Testing it now, will reports any issues. My multiple step forms are now working fine :)
Thanks
Evan
Hi Per
I've noticed a problem with the Form Entries Section.
The entries arn't showing up in the list and when you change either of the two filter dropdown lists, the "Processing..." message hangs and dosen't do anything. Details of the SqlHelperException from the Umbraco Log table below;
At /umbraco/plugins/umbracocontour/webservices/records.aspx?guid=250dc9fe-4c8e-47bd-a698-b0460731b11e&date=14/12/2009%2009:06:23&state=Approved&sEcho=2&iColumns=18&sColumns=&iDisplayStart=0&iDisplayLength=10&sSearch=&bEscapeRegex=true&sSearch_0=&bEscapeRegex_0=true&sSearch_1=&bEscapeRegex_1=true&sSearch_2=&bEscapeRegex_2=true&sSearch_3=&bEscapeRegex_3=true&sSearch_4=&bEscapeRegex_4=true&sSearch_5=&bEscapeRegex_5=true&sSearch_6=&bEscapeRegex_6=true&sSearch_7=&bEscapeRegex_7=true&sSearch_8=&bEscapeRegex_8=true&sSearch_9=&bEscapeRegex_9=true&sSearch_10=&bEscapeRegex_10=true&sSearch_11=&bEscapeRegex_11=true&sSearch_12=&bEscapeRegex_12=true&sSearch_13=&bEscapeRegex_13=true&sSearch_14=&bEscapeRegex_14=true&sSearch_15=&bEscapeRegex_15=true&sSearch_16=&bEscapeRegex_16=true&sSearch_17=&bEscapeRegex_17=true&iSortingCols=1&iSortCol_0=1&iSortDir_0=desc (Referred by: http://www.esc.nsw.gov.au/umbraco/plugins/umbracocontour/editFormEntries.aspx?guid=250dc9fe-4c8e-47bd-a698-b0460731b11e): umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteScalar ---> System.Data.SqlClient.SqlException: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
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(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
at System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue)
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 umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteScalar(String commandText, SqlParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:line 51
at umbraco.DataLayer.SqlHelper`1.ExecuteScalar[T](String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:line 194
--- End of inner exception stack trace ---
at umbraco.DataLayer.SqlHelper`1.ExecuteScalar[T](String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:line 198
at Umbraco.Forms.Data.Storage.RecordsViewer.GetPagedXmlRecordsFromStorage(Int32 startIndex, Int32 lenght, Int32 umbracoPageId, Sorting sortOrder, Form form, List`1 States, DateTime SinceDate, XmlDocument xd) in d:\TeamCity\buildAgent\work\39da791f9304089a\Umbraco.Forms.Core\Data\RecordStorage\RecordsViewer.cs:line 141
at Umbraco.Forms.Data.Storage.RecordsViewer.GetPagedXmlRecords(Int32 startIndex, Int32 lenght, Int32 umbracoPageId, Sorting sortOrder, Form form, List`1 States, DateTime SinceDate, XmlDocument xd) in d:\TeamCity\buildAgent\work\39da791f9304089a\Umbraco.Forms.Core\Data\RecordStorage\RecordsViewer.cs:line 299
at Umbraco.Forms.UI.Webservices.Records.ReturnRecords(Guid id, DateTime date, FormState state, Int32 startIndex, Int32 lenght, Sorting sortOrder) in d:\TeamCity\buildAgent\work\39da791f9304089a\Umbraco.Forms.UI\Webservices\Records.aspx.cs:line ...
Thanks Evan, I'll look into it.
Is this on all entries or only specific forms?
I'm having the same problem as Evan (already in 1.06). It happens for all forms not depending on how many steps.
Hi Yannick
There is a take 2 of the 1.0.7 release here
http://nightly.umbraco.org/Umbraco%20Contour/1.0.7/
the one postfixed with _upgrade is just zip file for upgrades which you xcopy to the root of your site. Pick the files with the newest creation date
Great! this one works.
is working on a reply...