News:

AbanteCart v1.4.2 is released.

Main Menu
support

Export timeout - 500 Internal Server Error

Started by raj@ad4u.co.uk, June 01, 2018, 05:06:49 PM

Previous topic - Next topic

raj@ad4u.co.uk

About 15,000 products on an A2HOSTING TURBO site -

Unlimited Websites
Unlimited Databases
Unlimited Storage
Unlimited Transfer
cPanel Control Panel
Free SSL & SSD
Turbo (Up To 20X Faster)
A2 Site Accelerator


Started getting the timeout errors, but the system still created the downloadable file.

Today we added about 3,000 more items. Now we get the timeout error but there is no downloadable file  :(


ERROR MESSAGE: Request Timeout
This request takes too long to process, it is timed out by the server. If it should not be timed out, please contact administrator of this web site to increase 'Connection Timeout'.

Is there a way to avoid this error?

Any other way to download all the product details (including SEO url)?


Just noticed the error log -
2018-06-01 22:35:14 - error: AbanteCart core v.1.2.12 Maximum execution time of 300 seconds exceeded in <b>/home/laptops2/public_html/core/lib/data.php</b> on line <b>272</b>

I have set max_execution_time to 60000 in php.ini (confirmed by phpinfo). Does Abantecart set the max_execution_time    to 300 somewhere in the code?

raj@ad4u.co.uk

Ok, the timeout is still there, but the system still creates a downloadable export file.

edit this file:
/core/lib/data.php

search for "300" and change to "3000" - ten times more execution time.


eCommerce Core

Export for 15k products in one run could be a bottleneck on smaller servers and short execution limits.

You can limit your export to range of IDs.
"If you're in the luckiest one per cent of humanity, you owe it to the rest of humanity to think about the other 99 per cent."
― Warren Buffett

abantecart

If you are technical, you can create a commandline script to export products or simple SQL query into CSV.
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Basara

Quote from: raj@ad4u.co.uk on June 01, 2018, 05:06:49 PM
I have set max_execution_time to 60000 in php.ini (confirmed by phpinfo). Does Abantecart set the max_execution_time    to 300 somewhere in the code?
Contact your hosting to increase max_execution_time

Forum Rules Code of conduct
AbanteCart.com 2010 -