I just upgraded to 3.8, I had been running a few releases prior.
I edited a couple of my schedules and whenever I do I get the following error and I can no longer get the schedule list.
Just wondering if I may be doing something wrong, any assistance would be appreciated. The only way I can seem to recover is to load the default database and start over.
Thanks;
Server Error in '/' Application.
--------------------------------------------------------------------------------
Conversion from type 'DBNull' to type 'String' is not valid.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidCastException: Conversion from type 'DBNull' to type 'String' is not valid.
Source Error:
Line 202: <Headerstyle width="60" wrap="true" />
Line 203: <ItemTemplate>
Line 204: <asp:Label ID="last_time" runat="server" Text='<%# GetLastRun(Eval("EventName")) %>' />
Line 205: </ItemTemplate>
Line 206: <ItemStyle Wrap="True" Width="60" />
Source File: C:\Program Files\HomeSeer 2\html\SprinklerEdit.aspx Line: 204
Stack Trace:
[InvalidCastException: Conversion from type 'DBNull' to type 'String' is not valid.]
Microsoft.VisualBasic.CompilerServices.Conversions.ToString( Object Value) +809
ASP.sprinkleredit_aspx.__DataBinding__control51(Object sender, EventArgs e) in C:\Program Files\HomeSeer 2\html\SprinklerEdit.aspx:204
System.Web.UI.Control.OnDataBinding(EventArgs e) +73
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +139
System.Web.UI.Control.DataBind() +15
System.Web.UI.Control.DataBindChildren() +205
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +149
System.Web.UI.Control.DataBind() +15
System.Web.UI.Control.DataBindChildren() +205
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +149
System.Web.UI.Control.DataBind() +15
System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource) +156
System.Web.UI.WebControls.GridView.CreateChildControls(IEnum erable dataSource, Boolean dataBinding) +2433
System.Web.UI.WebControls.CompositeDataBoundControl.PerformD ataBinding(IEnumerable data) +58
System.Web.UI.WebControls.GridView.PerformDataBinding(IEnume rable data) +15
System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewS electCallback(IEnumerable data) +104
System.Web.UI.DataSourceView.Select(DataSourceSelectArgument s arguments, DataSourceViewSelectCallback callback) +27
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +133
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +71
System.Web.UI.WebControls.GridView.DataBind() +5
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBou nd() +61
System.Web.UI.WebControls.CompositeDataBoundControl.CreateCh ildControls() +70
System.Web.UI.Control.EnsureChildControls() +97
System.Web.UI.Control.PreRenderRecursiveInternal() +53
System.Web.UI.Control.PreRenderRecursiveInternal() +180
System.Web.UI.Control.PreRenderRecursiveInternal() +180
System.Web.UI.Control.PreRenderRecursiveInternal() +180
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3873
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082
I edited a couple of my schedules and whenever I do I get the following error and I can no longer get the schedule list.
Just wondering if I may be doing something wrong, any assistance would be appreciated. The only way I can seem to recover is to load the default database and start over.
Thanks;
Server Error in '/' Application.
--------------------------------------------------------------------------------
Conversion from type 'DBNull' to type 'String' is not valid.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidCastException: Conversion from type 'DBNull' to type 'String' is not valid.
Source Error:
Line 202: <Headerstyle width="60" wrap="true" />
Line 203: <ItemTemplate>
Line 204: <asp:Label ID="last_time" runat="server" Text='<%# GetLastRun(Eval("EventName")) %>' />
Line 205: </ItemTemplate>
Line 206: <ItemStyle Wrap="True" Width="60" />
Source File: C:\Program Files\HomeSeer 2\html\SprinklerEdit.aspx Line: 204
Stack Trace:
[InvalidCastException: Conversion from type 'DBNull' to type 'String' is not valid.]
Microsoft.VisualBasic.CompilerServices.Conversions.ToString( Object Value) +809
ASP.sprinkleredit_aspx.__DataBinding__control51(Object sender, EventArgs e) in C:\Program Files\HomeSeer 2\html\SprinklerEdit.aspx:204
System.Web.UI.Control.OnDataBinding(EventArgs e) +73
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +139
System.Web.UI.Control.DataBind() +15
System.Web.UI.Control.DataBindChildren() +205
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +149
System.Web.UI.Control.DataBind() +15
System.Web.UI.Control.DataBindChildren() +205
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +149
System.Web.UI.Control.DataBind() +15
System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource) +156
System.Web.UI.WebControls.GridView.CreateChildControls(IEnum erable dataSource, Boolean dataBinding) +2433
System.Web.UI.WebControls.CompositeDataBoundControl.PerformD ataBinding(IEnumerable data) +58
System.Web.UI.WebControls.GridView.PerformDataBinding(IEnume rable data) +15
System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewS electCallback(IEnumerable data) +104
System.Web.UI.DataSourceView.Select(DataSourceSelectArgument s arguments, DataSourceViewSelectCallback callback) +27
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +133
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +71
System.Web.UI.WebControls.GridView.DataBind() +5
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBou nd() +61
System.Web.UI.WebControls.CompositeDataBoundControl.CreateCh ildControls() +70
System.Web.UI.Control.EnsureChildControls() +97
System.Web.UI.Control.PreRenderRecursiveInternal() +53
System.Web.UI.Control.PreRenderRecursiveInternal() +180
System.Web.UI.Control.PreRenderRecursiveInternal() +180
System.Web.UI.Control.PreRenderRecursiveInternal() +180
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3873
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082
Comment