Large Order - Fatal Error

[ksoup]

We have one order that refuses to go through (that we know of) over 40 items

When going to check out... consistantly the following error.

Fatal error: Maximum execution time of 30 seconds exceeded in /home2/store/public_html/includes/classes/db/mysql/query_factory.php on line 176


We logged in to try to force it... got the error above a few times
Hit the back button and check out again and get the following error.

Fatal error: Maximum execution time of 30 seconds exceeded in /home2/store/public_html/includes/functions/functions_prices.php on line 124


Does 1.3.6 require more resources or something? We were on 1.2.7d until the 6th with no problems (multiple items on large orders - no problems).


Which leads me to... we have the following setting:

// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'none');
define('DIR_FS_SQL_CACHE', '/enter/your/path/to/public_html_or_htdocs/and/zencart/here/zen/cache');

should this be different?

[DrByte]

What is the URL to the site?
Are these 40 products very attribute-intensive?
Is there any set list of steps to follow to reproduce the problem easily?
Who is your hosting company? What sort of server/plan are you on?

[ksoup]

The order had 43 items with one attribute.

I took out 5 items (38 total - and it went through). Does this help?

[DrByte]

Does 1.3.6 require more resources or something? We were on 1.2.7d until the 6th with no problems (multiple items on large orders - no problems).

There were changes, but mostly to speed things up, not slow it down.

Which leads me to... we have the following setting:

// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'none');
define('DIR_FS_SQL_CACHE', '/enter/your/path/to/public_html_or_htdocs/and/zencart/here/zen/cache');

should this be different?

That's fine. Changing it will make a difference, but that difference is little in the 1.3 series.
You could "try" changing it to "database" or to "file". If you choose "file" be sure to set the path correctly first. Don't make these changes during a busy time.

[ksoup]

When I was in her order and looked at the bottom...I saw number of queries 20893 and response time of 27.something seconds.

We are on a dedicated server
The only thing I could figure out was ... it was the amount of items in the cart.

During busy times... we have many orders of more than 40 items.

I did set it to database on both configs. :)

www.digitalscrapbookplace.com

[Kim]

Did you update your templates when you updated the Database? The parse times and queries should not be showing unless you expressly turned them on for debugging.

[ksoup]

We do have it on to see what the response time is :)

We upped the timeout to 90 seconds...

I have just tried a 75 piece order...each item had one attrib.
Fatal error: Maximum execution time of 90 seconds exceeded in /home2/store/public_html/includes/classes/db/mysql/query_factory.php on line 176

We put through several other orders of 61 items/ 51 items/

We are still testing....
Our store is huge... at what point will this become a real hassle?

[DrByte]

You are most likely running into bottleneck problems with the database. The checkout confirmation/completion process is the most intense hit on the database.

However, I've seen stores do what you're talking about with great ease on a host that's got a very well-tuned MySQL engine.

You'll need to increase that timeout a few times to find out what the threshold is for your server. Granted, after 30 seconds the customer is likely to throw up their hands. So the real issue is how to get your database tuned up a bit.


Zen Cart v1.4 (currently under development) has hugely reduced the number of queries required to do all of its functions. v1.3.x has some big improvements over v1.2.x. In the meantime, get your host to allocate more RAM to database processing or increase the PHP timeout.

[Ajeh]

I tried 49 products where there was a mix of Products, Virtual Products, Products with Attributes etc.

No page took longer than 4-5 seconds in the checkout ... The slowest page was the shopping cart itself ... went from 0.4 seconds to 4 - 8 seconds with everything loaded into it and all sideboxes on etc.

I would check to see what your server speeds are like just in navigating around to ensure that your php and MySQL settings are optimized well by your hosting company ...

I would also look at the indexes on your database to ensure that they are all optimized for your site ...

[yaby]

is there a way around this? i'm on 1.3.6 www.yabycosmetics.com and one customer keeps getting this error when accessing the shopping cart or checkout. is there a way to remove or view the list of the items from admin so i can edit the items?