Author Topic: Export timeout - 500 Internal Server Error  (Read 3846 times)

Offline raj@ad4u.co.uk

  • Newbie
  • *
  • Posts: 24
  • Karma: +5/-0
    • View Profile
Export timeout - 500 Internal Server Error
« 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?
« Last Edit: June 01, 2018, 05:44:57 PM by raj@ad4u.co.uk »

Offline raj@ad4u.co.uk

  • Newbie
  • *
  • Posts: 24
  • Karma: +5/-0
    • View Profile
SOLVED: Export timeout - 500 Internal Server Error
« Reply #1 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.


Offline eCommerce Core

  • Administrator
  • Hero Member
  • *****
  • Posts: 1602
  • Karma: +93/-1
    • View Profile
Re: Export timeout - 500 Internal Server Error
« Reply #2 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.
“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

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4358
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: Export timeout - 500 Internal Server Error
« Reply #3 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.
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

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: Export timeout - 500 Internal Server Error
« Reply #4 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

 

Powered by SMFPacks Social Login Mod