note 55299 added to function.mssql-get-last-message
| From: | NOjewlfSPAM at NOattSPAM dot net | Date: | Fri, 29 Jul 2005 14:48:02 +0000 |
| Subject: | note 55299 added to function.mssql-get-last-message | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-92727@lists.php.net to get a copy of this message | ||
As Klaus pointed out earlier, the command MSSQL_GET_LAST_MESSAGE() only returns the last line of an
error message and that may not be enough for debugging.
I had a failing MSSQL_QUERY returning "the statement has been terminated" via
MSSQL_GET_LAST_MESSAGE() so I tried Klaus' technique to get more information.
Unfortunately, the connection to the database was also being broken, keeping Klaus' technique
from looking up the error number.
The solution to my case was to increase the PHP timeout for MSSQL queries from the default 60
seconds to 300 by adding this to PHP.INI:
mssql.timeout = 300
----
Submitter IP: 12.160.245.96
----
Manual Page -- http://www.php.net/manual/en/function.mssql-get-last-message.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+55299
Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+55299&report=yes&reason=added+to+the+manual
Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+55299&report=yes&reason=bad+code
Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+55299&report=yes&reason=spam
Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+55299&report=yes&reason=useless
Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+55299&report=yes&reason=non-english
Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+55299&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+55299&report=yes
Search -- http://master.php.net/manage/user-notes.php