From: [EMAIL PROTECTED] Operating system: redhat-6.2 PHP version: 4.0.6 PHP Bug Type: MySQL related Bug description: Unable to save result set in I'm getting the following error message when I execute a query (such as insert or delete or update but not select) that doesn't produce any results: 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') "; mysql_connect("localhost",$db_pacc_user,$db_pacc_passwd); mysql_db_query($db,$sql); mysql_close(); ?> The result in browser is: Warning: MySQL: Unable to save result set in /home/0/admin/error.php on line 7 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. 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 root@localhost # I configured php with the following command: ./configure --with-mysql=/usr/local/mysql \ --enable-track-vars \ --with-gd=../../gd/gd1.3 \ --with-ftp \ --with-imap=../../mail/imap/imap-4.7c \ --enable-memory-limit \ --with-pgsql=/usr/local/pgsql 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 \ --with-extra-charsets=all ./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 . -- Edit Bug report at: http://bugs.php.net/?id=11766&edit=1 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]