ID: 11895 Updated by: kalowsky Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Feedback Bug Type: ODBC related Operating system: PHP Version: 4.0.6 Assigned To: Comments: any chance you can post a sample db (small schema), and a sample script for us to try? Previous Comments: --------------------------------------------------------------------------- [2001-07-05 03:12:00] [EMAIL PROTECTED] 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:websitestigsample_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 --------------------------------------------------------------------------- [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 --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=11895&edit=2 -- 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]
