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 .