Too many items in cart? Or is it too many attributes?
I have a problem with shopping cart when shopper puts too many items that have multiple attributes. I am running 1.39h and I have products with as many as 10 different attributes per product.
Right now, when customer or myself, for that matter, enters the eighth item, the cart first goes out of alignment to the template and then if you select checkout, the page just goes blank and that's it, no checkout.
I have attached a couple of screen captures to demonstrate.
I have this issue with all of this type of product and I cannot afford to limit my cart contents....can someone help?
If any other information is needed, let me know.
Keith
Re: Too many items in cart? Or is it too many attributes?
If you look in your Zen Cart Admin at the Tools ... Server Info ... what are you showing from the:
Server Information
< stuff here>
PHP Version X.X.X
Re: Too many items in cart? Or is it too many attributes?
Server Host: gator1073.hostgator.com (174.120.168.2) Database Host: localhost (127.0.0.1)
Server OS: Linux 2.6.38.7 Database: MySQL 5.1.52
Server Date: 08/21/2011 11:18:59 Database Date: 08/21/2011 11:18:59
Server Up Time: 11:18:59 up 56 days, 13:13, 0 users, load average: 12.98, 11.18, 9.86 HTTP Server: Apache mod_fcgid/2.3.6 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 PHP Safe Mode: Off
PHP File Uploads: On Max Size: 64M POST Max Size: 64M
Database Data Size: 29,990 kB Database Index Size: 5,670 kB
Re: Too many items in cart? Or is it too many attributes?
The load on the server is high ...
You might talk to your hosting provider about moving your site to a less loaded server ...
Re: Too many items in cart? Or is it too many attributes?
so, you think this is load related?
Re: Too many items in cart? Or is it too many attributes?
Partially ...
There can be other factors but the first is the load on the server ...
Can you turn on your parse times?
Re: Too many items in cart? Or is it too many attributes?
Parse Time: - Number of Queries: 3009 - Query Time: 0.38964174850464
if i try and click on edit cart, the page won't even totally load, just as shown in the screen caps on the link...
Re: Too many items in cart? Or is it too many attributes?
Go to the Configuration ... Layout Settings ... and turn off the Shopping Cart Totals just to see the affect of not doing the extra calculations ...
Quote:
Shopping Cart - Show Totals
Show Totals Above Shopping Cart?
0= off
1= on: Items Weight Amount
2= on: Items Weight Amount, but no weight when 0
3= on: Items Amount
Re: Too many items in cart? Or is it too many attributes?
Parse Time: - Number of Queries: 3465 - Query Time: 0.72650301528931
Parse Time: - Number of Queries: 3148 - Query Time: 0.53565443077088
Parse Time: - Number of Queries: 1735 - Query Time: 0.20878478173828
The third time is if I close my loaded cart and open a new one with a single item.
I cannot get the parse time from the other (full) cart because it prevents me from getting to the footer of the page when it freezes up.
Re: Too many items in cart? Or is it too many attributes?
if i remove one item with a bunch of these attributes, I get a workable shopping cart again with these times:
Parse Time: - Number of Queries: 52059 - Query Time: 7.0231287233277
Parse Time: - Number of Queries: 53647 - Query Time: 7.1890023490295
Parse Time: - Number of Queries: 51087 - Query Time: 6.5328909668731
Three different times with the cart with the one less item... the final time is when i click on "checkout"