ID: 22348
Updated by: [EMAIL PROTECTED]
Reported By: jayc_lawrence at hotmail dot com
-Status: Closed
+Status: Bogus
Bug Type: MSSQL related
Operating System: Windows 2000 SP3
PHP Version: 4.2.3
New Comment:
Yes, this is pretty much bogus. (not php bug after all..*phew* :)
Previous Comments:
------------------------------------------------------------------------
[2003-02-21 08:23:39] jayc_lawrence at hotmail dot com
This is no longer relevant.
------------------------------------------------------------------------
[2003-02-21 08:12:16] jayc_lawrence at hotmail dot com
Apologies.. i have sorted the problem, i was getting an execution time
out which i assumed was the query timeout... this is not the case. I
found the entry max_execution_time which appears to resolve my issue.
So am i right in saying there are two timeouts, one for php rendering
the page and the other for the return of records from a query of mssql
(mssql.timeout).
Sorry for the inconvenience.
------------------------------------------------------------------------
[2003-02-21 05:04:00] jayc_lawrence at hotmail dot com
Ok it says 90, so why are my queries timing out after 30 secs. Im going
to recreate the database and see if my problem still occurs. However as
i dont get any problems in query analyser, it is my assumption that
there is something up with my code or php.
------------------------------------------------------------------------
[2003-02-21 03:50:16] [EMAIL PROTECTED]
What does this output:
<?php echo ini_get('mssql.timeout'); ?>
------------------------------------------------------------------------
[2003-02-21 03:22:08] jayc_lawrence at hotmail dot com
Basically, ive tried changing the mssql.timeout to more than 30 seconds
(even though i thought the default was 60?) as i have a query that
works in query analyser, but gets a timeout on the php page. I changed
it to 90, and it still timed out after 30 seconds. So i checked to see
if php was reading php.ini, so i changed error_reporting to E_NOTICE to
see if it successfully set it, and that worked. However mssql.timeout
still doesnt.
Ive restarted iis, rebooted the server... everything.. i dont believe
this is the mssql server, ive checked all i can with that, and i dont
use the windows odbc, i use the php_mssql.dll and also have php_gd.dll
enabled.
Im a bit stuck with this one, and wonder if theres a solution other
than upgrading to the latest version..
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=22348&edit=1
