ID: 11895
Updated by: kalowsky
Old-Status: Open
Status: Feedback
Bug Type: ODBC related
Operating system: 
PHP Version: 4.0.6
Assigned To: 

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?



[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

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to