php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #22348 MSSQL.Timeout cannot be changed from default value.
Submitted: 2003-02-21 03:22 UTC Modified: 2003-02-21 09:29 UTC
From: jayc_lawrence at hotmail dot com Assigned:
Status: Not a bug Package: MSSQL related
PHP Version: 4.2.3 OS: Windows 2000 SP3
Private report: No CVE-ID: None
 [2003-02-21 03:22 UTC] 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..



Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-02-21 03:50 UTC] sniper@php.net
What does this output:

<?php echo ini_get('mssql.timeout'); ?>


 [2003-02-21 05:04 UTC] 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 08:12 UTC] 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 08:23 UTC] jayc_lawrence at hotmail dot com
This is no longer relevant.
 [2003-02-21 09:29 UTC] sniper@php.net
Yes, this is pretty much bogus.  (not php bug after all..*phew* :)

 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Mon Oct 14 04:01:27 2024 UTC