Site maintenance: Tuesday 17 Nov, from 10:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

The CabinetGuy

Started by cabinetguy on 13 Jan 2012, 5:36 PM · Views: 4,117

Results 1 to 20 of 43
13 Jan 2012, 5:36 PM
#1
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

The 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

13 Jan 2012, 11:38 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: The CabinetGuy

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? :unsure:

Is the site Live or in process?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

14 Jan 2012, 2:35 PM
#3
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

Re: The 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

14 Jan 2012, 2:59 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: The CabinetGuy

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? :unsure:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

14 Jan 2012, 3:12 PM
#5
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

Re: The 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?main_page=checkout_shipping

thx

14 Jan 2012, 3:19 PM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: The CabinetGuy

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

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

14 Jan 2012, 3:20 PM
#7
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

Re: The CabinetGuy

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

thx

14 Jan 2012, 3:21 PM
#8
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: The CabinetGuy

Now I see it turning off ...

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

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

14 Jan 2012, 3:26 PM
#9
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: The CabinetGuy

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

to the line with your:
PHPVersion

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

14 Jan 2012, 3:28 PM
#10
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

Re: The CabinetGuy

PHP Version: 5.2.17 (Zend: 2.2.0)

14 Jan 2012, 3:29 PM
#11
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

Re: The CabinetGuy

Server Host: qui.quikdrawers.com (96.125.169.210) Database Host: localhost (127.0.0.1)
Server OS: Linux 2.6.18-028stab089.1 Database: MySQL 5.1.56
Server Date: 01/14/2012 09:28:07 Database Date: 01/14/2012 09:28:07
Server Up Time: 09:28:07 up 73 days, 21:06, 0 users, load average: 0.21, 0.38, 0.35 HTTP Server: Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8e-fips-rhel5 DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
PHP Version: 5.2.17 (Zend: 2.2.0) PHP Memory Limit: 64M

14 Jan 2012, 3:30 PM
#12
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

Re: The CabinetGuy

Ooops, my bad...

Server Host: qui.quikdrawers.com (96.125.169.210) Database Host: localhost (127.0.0.1)
Server OS: Linux 2.6.18-028stab089.1 Database: MySQL 5.1.56
Server Date: 01/14/2012 09:28:07 Database Date: 01/14/2012 09:28:07
Server Up Time: 09:28:07 up 73 days, 21:06, 0 users, load average: 0.21, 0.38, 0.35 HTTP Server: Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8e-fips-rhel5 DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
PHP Version: 5.2.17 (Zend: 2.2.0) PHP Memory Limit: 64M

14 Jan 2012, 3:32 PM
#13
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: The CabinetGuy

Are you able to increase your memory limits on your server?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

14 Jan 2012, 4:08 PM
#14
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

Re: The CabinetGuy

I have increased the memory to 512 from 64.

15 Jan 2012, 12:57 PM
#15
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

Re: The CabinetGuy

It seems that I have "stumped" the panel again.

This is the second time that I have posted for help on this issue.

Does anyone else have any ideas?

What is the correlation between large shopping cart and whether or not someone is logged in or it is a "guest" cart?

tia

15 Jan 2012, 4:13 PM
#16
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: The CabinetGuy

I am not a server guru but I would check the settings for your MySQL and increase the memory on it ... optimizing the my.cnf file, if I am not mistaken ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

15 Jan 2012, 8:29 PM
#17
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

Re: The CabinetGuy

Linda,

thx for the input, i will definitely do so.

I just don't understand why this happens... I hate to lose customers because they cannot checkout when they want to purchase a large amount of product...

Keith

15 Jan 2012, 8:36 PM
#18
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: The CabinetGuy

Your server is not optimized ... it sounds like you have a good server but you are not utilizing it at its potential ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

15 Jan 2012, 8:39 PM
#19
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

Re: The CabinetGuy

and how does one go about "optimizing" one's server?

15 Jan 2012, 8:41 PM
#20
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: The CabinetGuy

read a lot ... :cool:

Start with that file and learn what settings it has and what settings it can have ...

Your server behaves as if using the default settings ... and those are no where near the correct ones ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!