#30592 [Opn]: not a valid MySQL-Link resource
| From: | v_shiray at ukr dot net | Date: | Thu, 28 Oct 2004 01:01:19 +0000 |
| Subject: | #30592 [Opn]: not a valid MySQL-Link resource | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-68417@lists.php.net to get a copy of this message | ||
ID: 30592
User updated by: v_shiray at ukr dot net
Reported By: v_shiray at ukr dot net
Status: Open
Bug Type: MySQL related
Operating System: Linux
PHP Version: 4.3.9
New Comment:
MySQL 4.0.20
Problem has been detected also with
PHP 4.3.8 and 5.0.2 on the same computer
RedHat 9.0, MySQL 3.23.58, PHP 4.3.9
Previous Comments:
------------------------------------------------------------------------
[2004-10-28 01:52:39] v_shiray at ukr dot net
Description:
------------
Below code has produced next output:
Current connections: Resource id #4, Resource id #4
PHP Warning: mysql_query(): 4 is not a valid MySQL-Link resource in
...
Tested on Linux Slackware 10.0
PHP Version => 4.3.9
System => Linux gate 2.4.27-lck3 #3 ðÔÎ á×Ç 13 01:00:30 EEST 2004 i686
Build Date => Sep 30 2004 23:01:51
Configure Command => './configure' '--prefix=/opt/php'
'--with-config-file-path=/opt/php/etc' '--disable-cgi'
'--enable-static' '--disable-shared' '--enable-sockets'
'--enable-ftp'
'--with-mysql=/usr' '--with-zlib=/usr'
PS. PHP 4.3.6 and 4.3.7 are not affected for this problem.
Reproduce code:
---------------
error_reporting(E_ALL);
$db1 = mysql_connect ('localhost', 'test', '1');
$db2 = mysql_connect ('localhost', 'test', '1');
echo "Current connections: $db1, $db2\n";
mysql_close($db2);
$db2 = 0;
mysql_query('SELECT 1+1', $db1);
Expected result:
----------------
Resource ID must be available with $db1
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=30592&edit=1