Coupons issue

Posted By amscompanies Wed 25 May 2011
Rated stars based on 1 vote.
Add to Favorites0
Author Message
amscompanies
 Posted Wed 25 May 2011
Supreme Being

Supreme Being - (8,169 reputation)Supreme Being - (8,169 reputation)Supreme Being - (8,169 reputation)Supreme Being - (8,169 reputation)Supreme Being - (8,169 reputation)Supreme Being - (8,169 reputation)Supreme Being - (8,169 reputation)Supreme Being - (8,169 reputation)Supreme Being - (8,169 reputation)

Group: Awaiting Activation
Last Active: Wed 8 Feb 2012
Posts: 11, Visits: 1,149
Whenever I try to access the Coupon menu in the admin section I get an error, attached below is the errorlog: (V1.3000)

-----------------------------------------------------------------------------
>>     URL:http://www.thefootballarchives.com/store/Admin/_Coupons.aspx
>>     Page:
-----------------------------------------------------------------------------
>>     25/05/2011 01:17:08
>>     194.73.118.78
>>     DESCRIPTION:
System.InvalidCastException: Conversion from string "30/5/2009" to type 'Date' is not valid.
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDate(String Value)
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDate(Object Value)
   at ASP.usercontrols_back__coupons_ascx.__DataBinding__control8(Object sender, EventArgs e)
   at System.Web.UI.Control.OnDataBinding(EventArgs e)
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.Control.DataBindChildren()
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.Control.DataBindChildren()
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource)
   at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding)
   at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
   at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
   at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
   at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
   at System.Web.UI.WebControls.GridView.DataBind()
   at UserControls_Back_KartrisCoupons.LoadCouponsGroups()
   at UserControls_Back_KartrisCoupons.Page_Load(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

==================================================


Think the issue is caused by the date formatting of the two pre-defined coupons when creating the DB
Wed 25 May 2011 by amscompanies
amscompanies
 Posted Wed 25 May 2011
Supreme Being

Supreme Being - (8,169 reputation)Supreme Being - (8,169 reputation)Supreme Being - (8,169 reputation)Supreme Being - (8,169 reputation)Supreme Being - (8,169 reputation)Supreme Being - (8,169 reputation)Supreme Being - (8,169 reputation)Supreme Being - (8,169 reputation)Supreme Being - (8,169 reputation)

Group: Awaiting Activation
Last Active: Wed 8 Feb 2012
Posts: 11, Visits: 1,149
So I've confirmed my theory by amending the start dates of the two default coupons and now the page loads OK.

I guess I can't be the first person to have this issue ?

This leads me onto a follow-up question, why do all the tables have triggers against them, is there a code reason, security reason ?

As I have had to remove it just to update the table
Paul
 Posted Wed 25 May 2011
große Käse

große Käse - (511,592 reputation)große Käse - (511,592 reputation)große Käse - (511,592 reputation)große Käse - (511,592 reputation)große Käse - (511,592 reputation)große Käse - (511,592 reputation)große Käse - (511,592 reputation)große Käse - (511,592 reputation)große Käse - (511,592 reputation)

Group: Administrators
Last Active: Tue 10 Sep 2024
Posts: 807, Visits: 2,748
I have confirmed the error - seems to be the format of the date returned from the DAL/BLL. Looking into it now...

--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.

If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top