[Resolved] Timeout with proper settings.

[ghjr]

I have a script that is writing an Excel file using the PEAR Spreadsheet_Excel_Writer package. Problem is the total file should have around 10,000 entries, but it only saves up to 5,990... and the script itself doesn't give me any errors. The error shows up when I try to open up the Excel file and it says its corrupt (although i can visualize the results).

The script runs for around 200 seconds, and I have set Apache's timeout to 500 and max_execution_time / max_input_time to 500 as well.

Is there something I'm missing out on here?

Cheers!

[lucasrd]

just an idea...you may have to check PHP's execution time too?

[ghjr]

Yup, those were setup correctly lucasrd, thanks!

It seems as if it is cutting the file when it reaches 2MB. Now I'm wondering if this has to do with Apache, PHP or the Pear Package. I'm gonna start looking into the conf files again, but does anyone have any ideas?

Cheers!

[ghjr]

Turns out this only happens on PHP5 and when you send the XLS file to the browser. If you just save it to the computer (not using the send function of the Spreadsheet_Excel_Writer class) then it works.

There already is a bug open for this on the Pear site: http://pear.php.net/bugs/bug.php?id=4247

Cheers!