#19488 [Com]: mysql_num_rows() randomly fails

ID: 19488 Comment by: chris@luxmail.lu Reported By: chris-php@bolt.cx Status: Bogus Bug Type: MySQL related Operating System: Linux 2.4.19-pre4 PHP Version: 4.2.3 New Comment: I have the same problem! Previous Comments: ------------------------------------------------------------------------ [2002-09-19 05:41:18] sniper@php.net Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. ------------------------------------------------------------------------ [2002-09-18 23:38:34] chris-php@bolt.cx 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 this bug report at http://bugs.php.net/?id=19488&edit=1