ID: 32405 Updated by: [EMAIL PROTECTED] Reported By: paul at thehedron dot com -Status: Bogus +Status: Closed Bug Type: MySQLi related Operating System: Linux (fedora core 3) PHP Version: 5CVS-STABLE-2005-03-24 Assigned To: georg New Comment:
This bug has been fixed in CVS. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. Thank you for the report, and for helping us make PHP better. Thanks for support for fixing this bug on 64 bit platform. It is also fixed in the 5_0 branch. Previous Comments: ------------------------------------------------------------------------ [2005-03-30 09:32:18] [EMAIL PROTECTED] Update: The bug only occurs when connecting via TCP/IP - it's a protocol problem in MySQL (but not a PHP problem). I will analyze it and file a bug report on bugs.mysql.com ------------------------------------------------------------------------ [2005-03-29 11:47:01] [EMAIL PROTECTED] Can't repeat (user gave me access on this machine): mysql> use test; Database changed mysql> show tables; Empty set (0.00 sec) mysql> CREATE TABLE users ( -> user_id INT UNSIGNED NOT NULL AUTO_INCREMENT, -> lastname VARCHAR(50) NOT NULL, -> PRIMARY KEY(user_id)); Query OK, 0 rows affected (0.02 sec) mysql> insert into users value (0, 'Paul'), (0, 'Georg'); Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> quit [EMAIL PROTECTED] ~]$ cat 32405.php <?php $mysqli = new mysqli('localhost', 'georg', '', 'test'); if ($stmt = $mysqli->prepare("SELECT user_id, lastname FROM users")) { $stmt->execute(); $stmt->bind_result($col1, $col2); while ($stmt->fetch()) { printf("%s %s\n", $col1, $col2); } $stmt->close(); } $mysqli->close(); ?> [EMAIL PROTECTED] ~]$ php -f 32405.php 1 Paul 2 Georg ------------------------------------------------------------------------ [2005-03-23 23:48:48] [EMAIL PROTECTED] Georg, there are several reports open on mysqli already..can you finally fix the stuff or move the whole thing to sibe..PECL? ------------------------------------------------------------------------ [2005-03-22 20:20:48] paul at thehedron dot com Pulled down the recommended CVS snapshot, compiled and installed. Info shows PHP Version 5.0.4RC2-dev. Ran the same code and got the same result. ------------------------------------------------------------------------ [2005-03-22 00:10:41] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.0-win32-latest.zip ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/32405 -- Edit this bug report at http://bugs.php.net/?id=32405&edit=1
