ID: 22651
Updated by: [EMAIL PROTECTED]
Reported By: craigs at abr dot com dot au
-Status: Open
+Status: Bogus
Bug Type: MySQL related
Operating System: Redhat Linux Adv Serv 2.1AS
PHP Version: 4.2.3
New Comment:
You guess wrong. The default link won't change
if the mysql_connect() fails. (of course not)
And as it's still that $LinkID, and no errors happened
for THAT one, then mysql_error() and mysql_errno() will of course print
nothing.
Previous Comments:
------------------------------------------------------------------------
[2003-03-11 22:52:34] craigs at abr dot com dot au
Calling mysql_errno or mysql_error after a failed
mysql_connect when there is an already existing
mysql connection resource does not return any
error message for the failed connect.
According to the doco, it would be expected to return
an error such as 'Unknown Mysql Server Host'.
I have searched the bug database, and bugs
2051 and 10291 report a related issue of mysql_error/errno
not reporting mysql_connect errors, however a review
of the change log reports support for mysql_connect errors
was added in 4.0.6.
A code segment that reproduces this bug follows
========================
$LinkID = mysql_connect("localhost","login","password");
mysql_select_db("mysql");
mysql_query("SELECT * FROM user");
$LinkID2 = mysql_connect("badserver","login","password");
echo "Mysql Error: ".mysql_errno()." - ".mysql_error()."\n";
==================
Expected result- Mysql Error: 2005 - Unknown MySQL Server Host
'badserver' (1)
Actual Result - Mysql Error: 0 -
Commenting out the first 3 lines and re running the script
returns the expected error of unknown server.
I would guess that the mysql_error functions use of a default
link resource of the last open resource is at fault, as none
is opened in the connect.
Cheers
Craig
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=22651&edit=1
