The CabinetGuy

[CabinetGuy]

I have raised this question before but I am still having the same problem with my shopping cart timing out if there is a lot of product in it.

I am currently working with a customer who has a 20 line order with 100 items. These are custom products so each of these items has several attributes.

I cannot "checkout" with this many items. The site just keeps timing out on the shopping cart and cannot complete the sale.

I am running v1.39h and i am running on VPS and have had my provider increase my SQL Max concurrent to 300 to see if this would help. No, it did not. I have even tried turning off all of the shipping options to see if the bogging was in the shipping calculations. This did not help either.

If I remove items from the shopping cart, in this case, with these items, once I get down to 7 lines, 12 items, it will process, showing a parse of 34601 inquiries - 11.3060685. If I add any more merchandise, it times out again.

Any ideas would be welcome....

Thanks

[Ajeh]

Is this a Clean install of v1.3.9h or an Upgrade?

Any chance of perhaps seeing a URL to you site?

Could you make a test customer account that breaks when trying to checkout so we can reproduce this?

Is the site Live or in process?

[CabinetGuy]

As I was rebuilding the shopping cart for this, I found that the issue occurs when it is with a customer logged in or trying to log in.

This seems to process fine until you try to log in, or, as yesterday, already logged in and trying to check out.

This was an upgrade from 1.38.

This is a live site @ quikdrawers.com

[Ajeh]

Customize the shopping cart sidebox to not show on the checkout pages by adding the code in RED to the file:
/includes/modules/sideboxes/shopping_cart.php

using your templates and overrides:

// bof: do not show on checkout pages
  if (in_array($_GET['main_page'], array(FILENAME_CHECKOUT_SHIPPING, FILENAME_CHECKOUT_SHIPPING_ADDRESS, FILENAME_CHECKOUT_PAYMENT, FILENAME_CHECKOUT_PAYMENT_ADDRESS, FILENAME_CHECKOUT_CONFIRMATION))) {
    $show_shopping_cart_box = false;
  }
// eof: do not show on checkout pages

  if ($show_shopping_cart_box == true) {

Does that help on this issue?

[CabinetGuy]

this does not seem to have any effect.

I am still timing out to a blank white page after about 40 seconds.

this is what is in the address bar when it times out:

https://quikdrawers.com/index.php?ma...ckout_shipping

thx

[Ajeh]

I do not see the Shopping Cart sidebox turning off when I get to the checkout pages ...

Did you add the code that I posted?

NOTE: check that you used your templates and overrides on this ...
/includes/modules/sideboxes/your_template_dir/shopping_cart.php

[CabinetGuy]

why would this issue only seem to manifest when logged in?

thx

[Ajeh]

Now I see it turning off ...

I have so far 14 products in the cart ... it is slow but still working ...

[Ajeh]

If you go to your Tools ... Server Info ... what do you see from the line:
Server Information

to the line with your:
PHPVersion

[CabinetGuy]

PHP Version: 5.2.17 (Zend: 2.2.0)