101 reputation
3
bio website twitter.com/jeemusu
location Japan
age 30
visits member for 2 years, 1 month
seen Mar 3 at 3:35

.


Jul
19
comment PHP script times out after 60 seconds on Apache
Enabled logging, and found that it wasn't the scripts timing out at all. It was the PEAR extension the previous developer had implemented choking when the xls file sizes got big. Thanks for the help :)
Jul
19
comment PHP script times out after 60 seconds on Apache
It's definately the while loop in the php thats timing out. With the original behavior, the while loops takes the output of the database and loops through each of the 5000 odd records adding them all into 1 xls file, and timing out before finishing. However if I change it to run two consecutive while loops (building 2 files of 2500 records each), it executes without timing out.
Jul
19
revised PHP script times out after 60 seconds on Apache
added 2 characters in body
Jul
19
revised PHP script times out after 60 seconds on Apache
deleted 55 characters in body
Jul
19
comment PHP script times out after 60 seconds on Apache
Unfortunately, the apache error_log doesn't show anything for the times the script was executed.The php.ini shows that error_log isn't defined, and I can't find anything that looks like a php log on the server. I was hoping to solve this without rebooting the server, but It seems that I may not be that lucky.
Jul
19
awarded  Editor
Jul
19
revised PHP script times out after 60 seconds on Apache
deleted 55 characters in body
Jul
19
asked PHP script times out after 60 seconds on Apache
Jul
18
awarded  Supporter
Jul
11
awarded  Autobiographer