php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #19488 mysql_num_rows() randomly fails
Submitted: 2002-09-18 23:38 UTC Modified: 2002-09-19 05:41 UTC
From: chris-php at bolt dot cx Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 4.2.3 OS: Linux 2.4.19-pre4
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: chris-php at bolt dot cx
New email:
PHP Version: OS:

 

 [2002-09-18 23:38 UTC] chris-php at bolt dot 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-09-19 05:41 UTC] 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-10-15 11:36 UTC] chris at luxmail dot lu 
I have the same problem!
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Fri May 09 12:01:28 2025 UTC