ID: 11765
User Update by: [EMAIL PROTECTED]
Status: Open
Bug Type: MySQL related
Operating system: redhat-6.2
PHP Version: 4.0.6
Description: Warning: MySQL: Unable to save result set in

I upgraded to mysql-3.23.39 and recompiled php-4.0.6 but nothing changed.

Previous Comments:

[2001-06-28 21:25:12] [EMAIL PROTECTED]

BTW : This error occur on ALL OF my scripts after I had upgraded my php from 4.0.3 to 


[2001-06-28 21:21:26] [EMAIL PROTECTED]

Yes I use Use mysql_query() / mysql_select_db() instead of mysql_db_query().
Both mysql_errno() and mysql_error() return NOTHING.
The query was successful exectued by mysql.(I can find the query reselt in mysql 
But why php generated an error?


[2001-06-28 13:16:05] [EMAIL PROTECTED]

Try adding this lines after each mysql function:

echo mysql_errno().": ".mysql_error()."<BR>";

This way you should get the reason why it doesn't work.

And FYI: Use mysql_query() / mysql_select_db()
instead of mysql_db_query().



[2001-06-27 23:37:47] [EMAIL PROTECTED]

The script(error.php) is :

$db_acc_user = "root";
$db_acc_passwd = "password";
$db = "pacc";
$sql = "INSERT INTO type (name, quota, pc, cn, office) VALUES ('Howard', '10', '1', 
'0', '1')";

The result in browser is:

Warning: MySQL: Unable to save result set in /home/0/admin/error.php on line 7

But I just found that NO error in command line

root@localhost # php ./error.php
X-Powered-By: PHP/4.0.6
Content-type: text/html


[2001-06-27 23:06:49] [EMAIL PROTECTED]

I'm getting the following error message when I execute a query (such as insert or 
or update but not select) that doesn't produce any results:

Warning: MySQL: Unable to save result set in /path/to/sql.php3
on line 33

MySQL said NOTHING and the query was successful executed.

I have set "display_errors = Off" in my php.ini, so no warnings should be shown
, but php script can not go on at the line where the Warnning should display.

I configured php with the following command:

./configure  --with-mysql=/usr/local/mysql --enable-track-vars 
--with-ftp --with-imap=../../mail/imap/imap-4.7c --enable-memory-limit

MySQL is version 3.23.38 and PostgreSQL is version 7.1.2 

and compiled with th following command:

./configure  --prefix=/usr/local/mysql --with-mysqld-user=mysql --with-charset=gb2312

./configure  --enable-multibyte --enable-unicode-conversion --with-perl
--with-openssl=/usr/local/ssl --enable-odbc --with-CXX

BTW : The script is perfect on mysql-php-4.0.3pl1 and postgreSQL-php-4.0.6 .


The remainder of the comments for this report are too long.
To view the rest of the comments, please
view the bug report online.

Full Bug description available at:

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to