php's max_execution_time to 3000
post_max_size 256M
memory_limit 768M
but I still get this error at 300 seconds:
An error has occurred during the export. Below the information received from the server.
Status error: 500
Status message: error
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'.
I have a lot of orders so any of the order related export templates had this issue of quitting after 300 seconds. All the other export templates completed the export relatively quick.
I did a test to see if it does timesout in a different file on the same site. I put a test.php file in the base directory and ran it, and it lasted at least 525 seconds:
<?php
$executionStartTime = microtime(true);
echo date('h:i:s')."\n" ;
if (ob_get_level() == 0) ob_start();
for ($i = 0; $i<105; $i++){
echo "<br> ".$i*5;
echo str_pad('',4096)."\n";
ob_flush();
flush();
sleep(5);
}
echo "Done.";
ob_end_flush();
echo date('h:i:s');
$executionEndTime = microtime(true);
$seconds = $executionEndTime - $executionStartTime;
echo "This script took $seconds to execute.";
?>
I assume it would keep executing until 3000 seconds like I set my server to.
I read this document:
https://rolandd.com/documentation/ro-csvi/manage-timeouts
but it seems like that is more geared towards import and not exporting
Went in to the template itself and I changed the template limits to :
Override System Limits? Yes
Maximum Execution Time: 3000
Maximum Amount Of Memory: 768M
But it still didn't work.
For reference, my joomla sql database is 23MB zipped and 135MB extracted.