Problem with Checkout Process

Problem with Checkout Process

Home » Kartris ASP.NET Ecommerce Software » Kartris technical issues

https://forum.kartris.com/Topic1627.aspx

Print Topic | Close Window

By oliverwestby - Mon 16 Apr 2012

Hi All,

I have used Kartris to set up my online shop at http://www.furry-feet.co.uk/index.aspx

Whilst the shop is still in the process of being set up, I have made Paypal live and I've tried to run through the procedure for checking out, but have encountered a problem.

To explain, I will run through where the problem occurs.

Add item to basket
view basket and click Checkout
Sign in
Select shipping type and agree to T&C
Click Proceed

I am now returned to the view basket screen again.

If I click checkout for the second time, I run through the same process as above, but the second time, I get to the next screen. Clicking proceed now takes me to Paypal correctly.

Any ideas why I have to run through the checkout procedure twice?

Thanks,

Oliver

By Medz - Thu 19 Apr 2012

Hi Oliver, I was redirected to the error page when I tried adding an item to the basket. Can you post whats in the logs so we can get a hint of whats going on.

Regards,

Medz

By oliverwestby - Fri 20 Apr 2012

Hi, Thanks for having a look at this for me.
The error you are seeing seems to be a result of having 'none' selected as the colour option for the product. Selecting a colour allows you to view the basket correctly / load other pages without an error.
Once 'add' is clicked when the option for 'none' is selected, nothing happens, but it produces this error in subsequent pages.
Clearing the browser cache seems to remove the error.

I will look into removing the 'none' option, but here are the results of the error log.

Thanks,
Oliver

-----------------------------------------------------------------------------
>>     URL:http://www.furry-feet.co.uk/Product.aspx?ProductID=11&L=1
>>     Page:
-----------------------------------------------------------------------------
>>     19/04/2012 17:38:49
>>     80.90.195.93
>>     DESCRIPTION:
System.InvalidCastException: Conversion from type 'DBNull' to type 'Double' is not valid.
   at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags)
   at Microsoft.VisualBasic.CompilerServices.NewLateBinding.CallMethod(Container BaseReference, String MethodName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, BindingFlags InvocationFlags, Boolean ReportErrors, ResolutionFailure& Failure)
   at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCall(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean IgnoreReturn)
   at Product.Page_LoadComplete(Object sender, EventArgs e)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Page.OnLoadComplete(EventArgs e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

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

-----------------------------------------------------------------------------
>>     URL:http://www.furry-feet.co.uk/Product.aspx?ProductID=11&L=1
>>     Page:
-----------------------------------------------------------------------------
>>     19/04/2012 17:39:10
>>     80.90.195.93
>>     DESCRIPTION:
System.InvalidCastException: Conversion from type 'DBNull' to type 'Double' is not valid.
   at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags)
   at Microsoft.VisualBasic.CompilerServices.NewLateBinding.CallMethod(Container BaseReference, String MethodName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, BindingFlags InvocationFlags, Boolean ReportErrors, ResolutionFailure& Failure)
   at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCall(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean IgnoreReturn)
   at Product.Page_LoadComplete(Object sender, EventArgs e)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Page.OnLoadComplete(EventArgs e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

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

-----------------------------------------------------------------------------
>>     URL:http://www.furry-feet.co.uk/Basket.aspx
>>     Page:
-----------------------------------------------------------------------------
>>     19/04/2012 17:39:24
>>     80.90.195.93
>>     DESCRIPTION:
System.InvalidCastException: Conversion from type 'DBNull' to type 'Double' is not valid.
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(Object Value, NumberFormatInfo NumberFormat)
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(Object Value)
   at BasketBLL.LoadBasketItems()
   at Templates_BasketView.LoadBasket()
   at Templates_BasketView.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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

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

-----------------------------------------------------------------------------
>>     URL:http://www.furry-feet.co.uk/Product.aspx?ProductID=11&L=1
>>     Page:
-----------------------------------------------------------------------------
>>     19/04/2012 17:39:33
>>     80.90.195.93
>>     DESCRIPTION:
System.InvalidCastException: Conversion from type 'DBNull' to type 'Double' is not valid.
   at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags)
   at Microsoft.VisualBasic.CompilerServices.NewLateBinding.CallMethod(Container BaseReference, String MethodName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, BindingFlags InvocationFlags, Boolean ReportErrors, ResolutionFailure& Failure)
   at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCall(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean IgnoreReturn)
   at Product.Page_LoadComplete(Object sender, EventArgs e)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Page.OnLoadComplete(EventArgs e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

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

-----------------------------------------------------------------------------
>>     URL:http://www.furry-feet.co.uk/Product.aspx?ProductID=11&L=1
>>     Page:
-----------------------------------------------------------------------------
>>     19/04/2012 17:41:08
>>     80.90.195.93
>>     DESCRIPTION:
System.InvalidCastException: Conversion from type 'DBNull' to type 'Double' is not valid.
   at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags)
   at Microsoft.VisualBasic.CompilerServices.NewLateBinding.CallMethod(Container BaseReference, String MethodName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, BindingFlags InvocationFlags, Boolean ReportErrors, ResolutionFailure& Failure)
   at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCall(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean IgnoreReturn)
   at Product.Page_LoadComplete(Object sender, EventArgs e)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Page.OnLoadComplete(EventArgs e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

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

-----------------------------------------------------------------------------
>>    Product.Page_Load
-----------------------------------------------------------------------------
>>    System.Data.SqlClient.SqlException
>>    19/04/2012 17:41:26
>>     URL:http://www.furry-feet.co.uk/Product.aspx?ProductID=11&L=1
>>    80.90.195.93
>>    CUSTOM MESSAGE:
Database Error: A general error has occurred.
>>    NUMBER:8144
>>    MESSAGE:
Procedure or function spKartrisProducts_GetByProductID has too many arguments specified.
>>    STACK:
   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.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at kartrisProductsDataTableAdapters.ProductsTblAdptr.GetByID(Nullable`1 P_ID, Nullable`1 LANG_ID)
   at ProductsBLL.GetProductDetailsByID(Int32 _ProductID, Int16 _LanguageID)
   at ProductView.LoadProduct(Int32 pProductID, Int16 pLanguageID)
   at Product.Page_Load(Object sender, EventArgs e)
==================================================

-----------------------------------------------------------------------------
>>     URL:http://www.furry-feet.co.uk/Product.aspx?ProductID=11&L=1
>>     Page:
-----------------------------------------------------------------------------
>>     19/04/2012 17:41:26
>>     80.90.195.93
>>     DESCRIPTION:
System.IO.IOException: The process cannot access the file '\\web-123win\winpackage21\furry-feet.co.uk\www.furry-feet.co.uk\web\content\Uploads\Logs\Errors\2012.04\2012.04.19.config' because it is being used by another process.
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options)
   at System.IO.StreamWriter.CreateFile(String path, Boolean append)
   at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize)
   at System.IO.StreamWriter..ctor(String path, Boolean append)
   at System.IO.File.AppendText(String path)
   at Kartris.CkartrisFormatErrors.ReportHandledError(Exception _ex, MethodBase _Source, String& _msg)
   at Product.Page_Load(Object sender, EventArgs e)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

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

-----------------------------------------------------------------------------
>>     URL:http://www.furry-feet.co.uk/404.aspx
>>     Page:
-----------------------------------------------------------------------------
>>     19/04/2012 17:41:27
>>     80.90.195.93
>>     DESCRIPTION:
System.InvalidCastException: Conversion from type 'DBNull' to type 'Double' is not valid.
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(Object Value, NumberFormatInfo NumberFormat)
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(Object Value)
   at BasketBLL.LoadBasketItems()
   at Templates_BasketView.LoadBasket()
   at Templates_BasketView.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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

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

-----------------------------------------------------------------------------
>>     URL:http://www.furry-feet.co.uk/Product.aspx?ProductID=11&L=1
>>     Page:
-----------------------------------------------------------------------------
>>     19/04/2012 17:41:32
>>     80.90.195.93
>>     DESCRIPTION:
System.InvalidCastException: Conversion from type 'DBNull' to type 'Double' is not valid.
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(Object Value, NumberFormatInfo NumberFormat)
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(Object Value)
   at BasketBLL.LoadBasketItems()
   at Templates_BasketView.LoadBasket()
   at Templates_BasketView.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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

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

-----------------------------------------------------------------------------
>>     URL:http://www.furry-feet.co.uk/Product.aspx?ProductID=11&L=1
>>     Page:
-----------------------------------------------------------------------------
>>     19/04/2012 17:41:35
>>     80.90.195.93
>>     DESCRIPTION:
System.InvalidCastException: Conversion from type 'DBNull' to type 'Double' is not valid.
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(Object Value, NumberFormatInfo NumberFormat)
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(Object Value)
   at BasketBLL.LoadBasketItems()
   at Templates_BasketView.LoadBasket()
   at Templates_BasketView.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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

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

-----------------------------------------------------------------------------
>>     URL:http://www.furry-feet.co.uk/index.aspx
>>     Page:
-----------------------------------------------------------------------------
>>     19/04/2012 17:42:10
>>     80.90.195.93
>>     DESCRIPTION:
System.InvalidCastException: Conversion from type 'DBNull' to type 'Double' is not valid.
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(Object Value, NumberFormatInfo NumberFormat)
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(Object Value)
   at BasketBLL.LoadBasketItems()
   at Templates_BasketView.LoadBasket()
   at Templates_BasketView.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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

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

-----------------------------------------------------------------------------
>>     URL:http://www.furry-feet.co.uk/index.aspx
>>     Page:
-----------------------------------------------------------------------------
>>     19/04/2012 17:42:34
>>     80.90.195.93
>>     DESCRIPTION:
System.InvalidCastException: Conversion from type 'DBNull' to type 'Double' is not valid.
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(Object Value, NumberFormatInfo NumberFormat)
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(Object Value)
   at BasketBLL.LoadBasketItems()
   at Templates_BasketView.LoadBasket()
   at Templates_BasketView.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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

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

By oliverwestby - Fri 27 Apr 2012

Any Ideas?

Ollie

By Medz - Fri 27 Apr 2012

Hi Ollie, can you let me know which version of Kartris are you using? I know there are quite a few changes to the basketbll recently which may have already fixed the issue you're getting right now. Latest version is v1.3009

By oliverwestby - Fri 27 Apr 2012

Thanks for your reply,

It shows that I am using 1.3008 - How do I update it, and will this do anything to the basket function?