HomeHome Product Discus... Product Discus...SmithCartSmithCartError when trying to go to shippingError when trying to go to shipping
Previous
 
Next
New Post
9/25/2014 6:06 AM
 
Hi 
When trying to go to Shipping from the Dashboard I keep getting this Error
"A critical error has occurred. String was not recognized as a valid Boolean."

Please help!
 
New Post
9/25/2014 12:33 PM
 
Hi Steve,

Did you recently make any changes to your site around the same time you started seeing this error such as a new module installation or module upgrade?
 
New Post
9/25/2014 11:33 PM
 
Hi Kevin

Nope, the last thing I did on the site was import some users last week.

Regards
Steve
 
New Post
9/26/2014 1:05 PM
 
Hi Steve,

Which version of the Cart and DNN are you currently using?

What is the error logged to your DNN Event Viewer?
 
New Post
9/28/2014 11:26 PM
 
Hi

This is the Error and I am using 6.50.0

AssemblyVersion:7.2.1
PortalID:0
PortalName:Trans Natal Glass
UserID:2
UserName:HostSC
ActiveTabID:108
ActiveTabName:Member Store
RawURL:/Member-Store/ctl/ManageShipping/mid/545
AbsoluteURL:/Default.aspx
AbsoluteURLReferrer:http://www.transnatal.co.za/Member-Store
UserAgent:Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.124 Safari/537.36
DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID:dbfa14a1-d0c6-4812-875a-151f5647340e
InnerException:String was not recognized as a valid Boolean.
FileName:
FileLineNumber:0
FileColumnNumber:0
Method:System.Boolean.Parse
StackTrace:
Message:
DotNetNuke.Services.Exceptions.PageLoadException: String was not recognized as a valid Boolean. ---> System.FormatException: String was not recognized as a valid Boolean.
at System.Boolean.Parse(String value)
at ASP.desktopmodules_smith_buynow_manageshipping_ascx.__DataBinding__control168(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 Smith.DNN.Modules.BuyNow.ManageShipping.BindGridShippingByAmount()
at Smith.DNN.Modules.BuyNow.ManageShipping.BindAllGrids()
at Smith.DNN.Modules.BuyNow.ManageShipping.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(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.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)
--- End of inner exception stack trace ---
 
New Post
9/29/2014 2:11 PM
 
Hi Steve,

It looks like the error is being caused by a NULL value in the database. In the release of 6.50 we added a "Is International" setting which required a new column to be added to the Smith_ShippingByAmount table. If this new field is the cause of the error, running the following SQL statement should resolve the issue:

Update Smith_ShippingByAmount SET IsIntl=0

 
New Post
9/30/2014 12:21 AM
 
Hi.

Thanks for this it worked.

Regards Steve
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartError when trying to go to shippingError when trying to go to shipping