at MySql.Data.MySqlClient.MySqlDataReader.GetFieldValue(Int32 index, BooleancheckNull) at MySql.Data.MySqlClient.MySqlDataReader.GetDateTime(Int32 column) at umbraco.DataLayer.RecordsReaderAdapter`1.GetDateTime(String fieldName)
at Umbraco.Forms.Core.Record.CreateFromDataReader(IRecordsReader reader) in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.Core\Record.cs:line 105 at Umbraco.Forms.Data.Storage.RecordStorage.GetRecord(Object id) in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.Core\Data\RecordStorage\RecordStorage.cs:line 88
at Umbraco.Forms.Core.Services.WorkflowService.ExecuteWorkflows(List`1 workflows, RecordEventArgs e) in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.Core\Services\WorkflowService\WorkflowService.cs:line 123
at Umbraco.Forms.Core.Services.WorkflowServiceApplication.FormService_FormEvent(Object sender, RecordEventArgs e) in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.Core\Services\WorkflowService\WorkflowService.cs:line 71
at Umbraco.Forms.Core.Services.RecordService.Submit() in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.Core\Services\RecordService\RecordService.cs:line 184 at Umbraco.Forms.Core.Services.RecordService.NextPage() in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.Core\Services\RecordService\RecordService.cs:line 257
at Umbraco.Forms.UI.Usercontrols.RenderForm.nextPage(Object sender, EventArgs e) in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.UI\Usercontrols\RenderForm.ascx.cs:line 204 at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
It seems like I have some problem with MySQL but I have no clue.
Umbraco can really frustrate one from time to time. Hard to find information and the site is full of dead links leading nowhere, outdated info and so on. That's why I'm moving torwards using WordPress for my customers instead of Umbraco.
Switching to MSSQL is not an option for me so that means I'm kind of stuck then.
Guess one option is to download source and fix it myself...
Exception Data is Null when submitting a Contour form
I installed Contour (1.1.3) and added the license, everything looks fine.
I create a contact form from the template without any additions and save it.
I press the preview button and the form is shown.
I fill the fform fields.
When I press submit I get the following exception:
At /umbraco/plugins/umbracocontour/previewFormDialog.aspx?guid=ac0221d2-020a-42c5-956a-ea84a8e932ef&rnd=3 (Referred by: http://lang.meuhedet.co.il/umbraco/plugins/umbracocontour/previewFormDialog.aspx?guid=ac0221d2-020a42c5-956a-ea84a8e932ef&rnd=3): System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.
at MySql.Data.MySqlClient.MySqlDataReader.GetDateTime(Int32 column)
at umbraco.DataLayer.RecordsReaderAdapter`1.GetDateTime(String fieldName)
at Umbraco.Forms.Core.Record.CreateFromDataReader(IRecordsReader reader) in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.Core\Record.cs:line 105
at Umbraco.Forms.Data.Storage.RecordStorage.GetRecord(Object id) in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.Core\Data\RecordStorage\RecordStorage.cs:line 88
at Umbraco.Forms.Core.Services.WorkflowService.ExecuteWorkflows(List`1 workflows, RecordEventArgs e) in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.Core\Services\WorkflowService\WorkflowService.cs:line 123
at Umbraco.Forms.Core.Services.WorkflowServiceApplication.FormService_FormEvent(Object sender, RecordEventArgs e) in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.Core\Services\WorkflowService\WorkflowService.cs:line 71
at Umbraco.Forms.Core.Services.RecordService.Submit() in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.Core\Services\RecordService\RecordService.cs:line 184
at Umbraco.Forms.Core.Services.RecordService.NextPage() in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.Core\Services\RecordService\RecordService.cs:line 257
at Umbraco.Forms.UI.Usercontrols.RenderForm.nextPage(Object sender, EventArgs e) in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.UI\Usercontrols\RenderForm.ascx.cs:line 204
at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
It seems like I have some problem with MySQL but I have no clue.
Comment author was deleted
Hi Gal,
What version of mysql are you running? WIll try to reproduce the error once I know the version number.
Hey Tim,
Thank you for your reply. It is ver 5.1
Regards,
Gal
Hello Tim,
Any news?
Gal.
Hello Tim and Gal.
I'm having the exact same problem. Did you come up with a solution?
Best
Örjan
After so many emails to support,to niels and the forum I was simply put: forgotten.
It seems like Umbraco will gladley take your money but when it needs to support you, NADA. They will not even answer mails.
After not receiving any response I moved from MySQL to MSSQL which was very painfull but now it works fine.
Sorry I can not give you more info on that.
Gal
I'm sorry to hear that Gal and that's really bad.
Umbraco can really frustrate one from time to time. Hard to find information and the site is full of dead links leading nowhere, outdated info and so on.
That's why I'm moving torwards using WordPress for my customers instead of Umbraco.
Switching to MSSQL is not an option for me so that means I'm kind of stuck then.
Guess one option is to download source and fix it myself...
//Örjan
Same problem here.
MySQL version: 5.1.39
I made a temporary hack until contour is updatet.
In the mysql table UFRECORDS change settings for the row UPDATED from:
NULL=Yes To NULL=No
Default value: CURRENT_TIMESTAMP to : 2011-01-16 20:42:34
Here a screendump from phpmyadmin before and after
Before
After
is working on a reply...