#19488 [NEW]: mysql_num_rows() randomly fails

From: chris-php@bolt.cx Operating system: Linux 2.4.19-pre4 PHP version: 4.2.3 PHP Bug Type: MySQL related Bug description: mysql_num_rows() randomly fails mysql_num_rows() is randomly failing for me on any script with any SQL query. mysql_query() doesn't return false, and mysql_error() and mysql_errno() return nothing. Happens on both 4.2.2 and 4.2.3. I checked all SQL queries that this happens with and they run fine on the database server(s). The exact error message I get is: [18-Sep-2002 21:31:46] PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/shared/sql.lib on line 99 (taken from the error_log) The same thing seems to be happening on bugs.php.net. When I search for something, I randomly get the following errors: Warning: mysql_numrows(): 4 is not a valid MySQL result resource in /local/Web/sites/php-bugs-web/search.php on line 119 Warning: mysql_fetch_array(): 4 is not a valid MySQL result resource in /local/Web/sites/php-bugs-web/search.php on line 139 -- Edit bug report at http://bugs.php.net/?id=19488&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=19488&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=19488&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=19488&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=19488&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=19488&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=19488&r=support Expected behavior: http://bugs.php.net/fix.php?id=19488&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=19488&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=19488&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=19488&r=globals