ID: 11895 User Update by: [EMAIL PROTECTED] Old-Status: Feedback Status: Open Bug Type: ODBC related Operating system: win2k PHP Version: 4.0.6 Description: total crash of PHP After adding set_time_limit(60); the following is dumped to the web browser. Fatal error: Maximum execution time of 60 seconds exceeded in c:\websites\tig\sample_report2.php on line 49 and 'Program Error' box is popped up on the server (Dr Watson) saying 'Apache.exe has generated errors and will be .... ' When php is run as a CGI the error msg says that 'php.exe has generated...' Line 49 of the code is; $RS = odbc_exec($CON,$query); The weirdest bit is if I re-run the same query with the same variables (after the restart of apache) the query is nice and fast. I think SQL2000 is caching the results somehow. The variable is required and will be any number between 700 and 9999 Previous Comments: --------------------------------------------------------------------------- [2001-07-05 02:52:39] [EMAIL PROTECTED] Can you confirm that it crashes at around 60 seconds if you use set_time_limit(60); at the top of your script? Derick --------------------------------------------------------------------------- [2001-07-04 22:24:55] [EMAIL PROTECTED] an ODBC query that takes a long time to excute (> 30 sec) will crash php and requires apache to restart. This is when loading php as an apache modual or as a CGI apache 1.3.20 (win2k) php 4.0.6 (win2k) SQL2000 (win2k) The SQL2000 database has over 30 million records and is performing a scan (on indexed records) I'm more than willing to test code or help out to fix this btw --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=11895 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]