Edit report at http://bugs.php.net/bug.php?id=52090&edit=1
ID: 52090 Updated by: ras...@php.net Reported by: gsx1022 at gmail dot com Summary: mysql_fetch_assoc returns infinite number of records Status: Feedback Type: Bug Package: MySQL related Operating System: Linux x86 PHP Version: 5.3.2 New Comment: Can't afford? As in financially? There are multiple free virtualization mechanisms out there and the OS images are free. Setting up a clean vm on your existing machine is trivial and takes about 30 minutes, tops. Previous Comments: ------------------------------------------------------------------------ [2010-07-06 16:20:28] gsx1022 at gmail dot com In my current situation I cannot afford to set up a test box and try to compile the snapshot from php.net. However, I will do so as soon as I can. In the meantime here is the source-archive with all patches that I use, from the Ubuntu Repositories: http://archive.ubuntu.com/ubuntu/pool/main/p/php5/php5_5.3.2.orig.tar.gz Also, I can confirm that the same problem exists on an x64 box with the same software versions too. All other requested information (schema, versions) are provided in detail on the link in the description. ------------------------------------------------------------------------ [2010-06-23 01:44:41] johan...@php.net Please use a recent snapshot from our site, we don't know what kind of patches Ubuntu applies. Please provide the table schema and data you are querying. Whcih MySQL server version? ------------------------------------------------------------------------ [2010-06-16 13:19:23] gsx1022 at gmail dot com I am using the php5 package from the Ubuntu Linux APT repository. It seems to use libmysql. And yes, mysqli is also affected. ------------------------------------------------------------------------ [2010-06-16 03:51:33] ka...@php.net Do you use mysqlnd with ext/mysql or libmysql, in either case does it solve switching the lib? Is mysqli affected by this issue too on your machine? ------------------------------------------------------------------------ [2010-06-15 21:35:55] gsx1022 at gmail dot com Description: ------------ A MySQL query that should return 5 records returns an infinite number of records. It returns the 5 five records correctly, but then it returns them again, and again, and again... Other SELECT statements are fine, this is the only problematic one. Also, this query works from the MySQL console just fine. At first I thought it is an issue with Zend Framework but it turned out it is probably not. See this url for (much) more info (also detailed information to reproduce): http://framework.zend.com/issues/browse/ZF-9982 Test script: --------------- $c = mysql_connect('host', 'user', 'pass'); mysql_select_db('db', $c); $raw = mysql_query('SELECT `name`, `level`, `parent` FROM `allresources_view` ORDER BY `level` ASC'); while ($r = mysql_fetch_assoc($raw)) { var_dump($r); echo '<br /><br />'; } mysql_close($c); Expected result: ---------------- 5 records should have been returned from the database. Actual result: -------------- An infinite number of records are returned from the database. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=52090&edit=1