php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #10132 mysql unable to store result set warning (not as in FAQ)
Submitted: 2001-04-03 06:37 UTC Modified: 2001-04-03 09:12 UTC
From: jules at acris dot co dot uk Assigned:
Status: Closed Package: MySQL related
PHP Version: 4.0.4pl1 OS: linux 2.2.14
Private report: No CVE-ID: None
 [2001-04-03 06:37 UTC] jules at acris dot co dot uk
I'm getting the following error message when I execute a query (such as an insert) that doesn't produce any results:

Warning: MySQL: Unable to save result set in /home/web/demo/panet/public/reg_emp_add.php3 on line 45

I have my php error showing level set at '5' in php3.ini, so no warnings should be shown at all anyway.

I configured php with the following command:

./configure --with-mysql=/usr --with-apxs --with-gd --enable-sockets --with-zlib --with-gnu-ld --enable-memory-limit

MySQL is version 3.23.33 and was installed from an RPM
packed by the MySQL development team.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-04-03 08:39 UTC] jules at acris dot co dot uk
I've been poking around the source code trying to find a soltion to this, and I'm not sure but think I may have found it.  As previously said I'm on MySQL 3.22.23:

From php_mysql.c line 83:

#if MYSQL_VERSION_ID < 32224
#define PHP_MYSQL_VALID_RESULT(mysql)           \
        (mysql_num_fields(mysql)>0)
#else
#define PHP_MYSQL_VALID_RESULT(mysql)           \
        (mysql_field_count(mysql)>0)
#endif

From the MySQL manual 'Upgrading from 3.22 to 3.23':

mysql_num_fields() can no longer be used on a MYSQL* object (it's now a function that takes MYSQL_RES* as an argument. You should now use mysql_field_count() instead. 

My guess based on this is that the 32224 should be changed to 32223 (I have located at least one other individual experiencing the same problem with the same version of mysql).

 [2001-04-03 08:49 UTC] jules at acris dot co dot uk
Err.. ignore me.  That change might or might not be necessary, but that isn't the version of mysql I'm on.  Back to the drawing board...?
 [2001-04-03 09:12 UTC] sniper@php.net
Are you using PHP 3? Or as you have selected: 4.0.4pl1 ??
If former, please upgrade.

If problem persists after upgrade, reopen this bug report
with shortest possible example script which can be used 
to reproduce this.

--Jani

 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Mar 29 01:01:28 2024 UTC