AbanteCart Community

Shopping Cart Operations => Support => Topic started by: raj@ad4u.co.uk on June 01, 2018, 05:06:49 PM

Title: Export timeout - 500 Internal Server Error
Post by: raj@ad4u.co.uk on June 01, 2018, 05:06:49 PM
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?
Title: SOLVED: Export timeout - 500 Internal Server Error
Post by: raj@ad4u.co.uk on June 01, 2018, 06:35:16 PM
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.

Title: Re: Export timeout - 500 Internal Server Error
Post by: eCommerce Core on June 02, 2018, 02:40:20 PM
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.
Title: Re: Export timeout - 500 Internal Server Error
Post by: abantecart on June 02, 2018, 02:46:23 PM
If you are technical, you can create a commandline script to export products or simple SQL query into CSV.
Title: Re: Export timeout - 500 Internal Server Error
Post by: Basara on June 04, 2018, 02:06:52 AM
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