ID: 36949 User updated by: jax at student dot unibe dot ch Reported By: jax at student dot unibe dot ch -Status: Feedback +Status: Open Bug Type: MySQLi related Operating System: Gentoo Linux PHP Version: 5.1.2 New Comment:
Ok i installed PHP 5.1.3 RC3 from CVS and problem persists: [EMAIL PROTECTED]: cli # ./php --version PHP 5.1.3RC3 (cli) (built: Apr 11 2006 00:27:07) Copyright (c) 1997-2006 The PHP Group Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies [EMAIL PROTECTED]: cli # ./php test.php 2006-04-11 00:38:02<br>2006-04-11 00:38:02<br> Warning: mysqli::close(): Couldn't fetch mysqli in /root/php5.1-200604102030/sapi/cli/test.php on line 35 test.php contained exact code mentioned in first post. Previous Comments: ------------------------------------------------------------------------ [2006-04-10 12:03:16] [EMAIL PROTECTED] You don't need to INSTALL it, just run your test script from the compiled dir: sapi/cli/php test.php ------------------------------------------------------------------------ [2006-04-05 12:42:40] jax at student dot unibe dot ch I cannot currently install CVS PHP on the production server, perhaps somebody could please test this and feedback so we can resolve this issue. Thank you in advance. Gabe Jackson ------------------------------------------------------------------------ [2006-04-02 16:00:00] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5.1-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.1-win32-latest.zip ------------------------------------------------------------------------ [2006-04-02 15:14:56] jax at student dot unibe dot ch Description: ------------ Test Case for mysqli->fetch_object bug class A and class B contain the exact same code Using mysqli->fetch_object causes warning when the destructor of B is called (mysqli->close()): Warning: mysqli::close() [function.close]: Couldn't fetch mysqli in /home/path/to/php/test.php on line 56 (destructor of B) If mysqli->fetch_assoc is used instead of fetch_object, it works fine. Replace $row = $result->fetch_object(); echo $row->my_time; With $row = $result->fetch_assoc(); echo $row['my_time']; to test something must be wrong with fetch_object Reproduce code: --------------- class A { private $mysqli; public function __construct() { $this->mysqli = new mysqli("localhost", "u", "p", "test"); $result = $this->mysqli->query("SELECT NOW() AS my_time"); // -------- Line Causing Problem ------ $row = $result->fetch_object(); echo $row->my_time."<br>"; $result->close(); } public function __destruct() { $this->mysqli->close(); } } class B { private $mysqli; public function __construct() { $this->mysqli = new mysqli("localhost", "u", "p", "test"); $result = $this->mysqli->query("SELECT NOW() AS my_time"); // -------- Line Causing Problem -------- $row = $result->fetch_object(); echo $row->my_time."<br>"; $result->close(); } public function __destruct() { $this->mysqli->close(); } } $A = new A(); $B = new B(); Expected result: ---------------- $this->mysqli->close() should work without throwing an error Actual result: -------------- 2006-04-02 15:01:36 2006-04-02 15:01:36 Warning: mysqli::close() [function.close]: Couldn't fetch mysqli in /home/path/to/test.php on line 56 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=36949&edit=1