ID: 42378 Updated by: [EMAIL PROTECTED] Reported By: jullrich at sans dot org -Status: Assigned +Status: Wont fix Bug Type: MySQLi related Operating System: Linux (CentOS 4.5) PHP Version: 5.2.3 Assigned To: andrey New Comment:
Hi, unfortunately that's a server side problem. I reproduce the problem if there is no store_result() call, so this is a workaround. The server sends wrong metadata which fools mysqli. Another workaround will be using mysqlnd instead of libmysql once 5.3 is released. mysqlnd handles this case well better and shows no problems. I have opened a bug report at bugs.mysql.com : (http://bugs.mysql.com/35558) Bug #35558 Wrong server metadata blows up the client Previous Comments: ------------------------------------------------------------------------ [2007-09-04 18:53:57] jullrich at sans dot org mysql version: 5.0.26-max-log mysql is running on a SUSE Enterprise server Version 10 (x86_64). ------------------------------------------------------------------------ [2007-09-04 18:22:08] uwendel at mysql dot com Bug is verified. I can reproduce it on a box with PHP5.2.4RC1-dev and MySQL 5.1.20-beta. ------------------------------------------------------------------------ [2007-09-04 16:50:12] uwendel at mysql dot com Thanks! May I also ask you for the MySQL Server version? I've written a test which reads 100 rows from a table which has a column that I use FORMAT() on. The test checks all *INT* types, FLOAT and DECIMAL. So far I have not been able to reproduce your problem with PHP 5_2 CVS and PHP 6. I'll give it another try with your table definition... ------------------------------------------------------------------------ [2007-09-03 18:55:58] jullrich at sans dot org as requested, the table definition: CREATE TABLE `trends` ( `targetport` int(11) NOT NULL default '0', `sources` double(17,4) default NULL, `current_sources` double(17,0) default NULL, `reports` double(17,4) default NULL, `current_reports` double(17,0) default NULL, `targets` double(17,4) default NULL, `current_targets` double(17,0) default NULL, `maxsources` int(11) default NULL, `maxtargets` int(11) default NULL, `maxreports` int(11) default NULL, `trend` float default NULL, PRIMARY KEY (`targetport`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ------------------------------------------------------------------------ [2007-09-03 14:52:13] uwendel at mysql dot com Can you add the table definition to the bug report? ------------------------------------------------------------------------ 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/42378 -- Edit this bug report at http://bugs.php.net/?id=42378&edit=1