php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
41 - 28 = ?
Subscribe to this entry?

 
 [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

Add a Patch

Pull Requests

Add a Pull Request

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: Wed Apr 24 09:01:28 2024 UTC