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

go to bug id or search bugs for

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
View Developer Edit
 [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