php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #4987 MySQL Warning: Unable to save result set
Submitted: 2000-06-12 18:05 UTC Modified: 2000-08-18 19:10 UTC
From: brian at netkick dot com Assigned:
Status: Closed Package: MySQL related
PHP Version: 4.0.0 Release OS: Redhat 6.1
Private report: No CVE-ID: None
 [2000-06-12 18:05 UTC] brian at netkick dot com
Everytime I run a mysql INSERT/UPDATE query using PHP4 I am receiving the following error message:

Warning: MySQL: Unable to save result set in
(file name) on (line number)

I have tried running the same script on another machine running PHP4 and do not get this warning message.  I have seen this same problem reported many times on the message boards, but never an answer for what is causing it.  Myself and others would appreciate if you could look into this as soon as possible.  Thanks for the hard work!

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-07-20 21:10 UTC] mrobinso at cvs dot php dot net
Please provide the version of mysql you are using, how
it was installed (source/rpm),a copy of the ./configure
line used to compile php.


 [2000-08-08 22:55 UTC] waldschrott@php.net
When MySQL is unable to save a result set, it has reached its predinied table limits. not a php bug.
 [2000-08-09 00:11 UTC] mrobinso@php.net
Actually, this problem was dealt with several times,
the most verbose being bug report # 4759.

More than likely, php4 was compiled with the bundled mysql
client, and some other application on the system is
using mysql's client (for example, php3, auth-mysql,
something like that, hence a conflict. See bug report
# 4759.

Adding the path to the mysql flag:

--with-mysql=/path/to/mysql

usually does the trick.
 [2000-08-09 07:26 UTC] waldschrott@php.net
marking dup 4759
 [2000-08-18 19:10 UTC] sniper@php.net
No feedback.

--Jani
 
PHP Copyright © 2001-2026 The PHP Group
All rights reserved.
Last updated: Sun Jun 28 01:00:01 2026 UTC