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')

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:

  --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 \

MySQL is version 3.23.38 and PostgreSQL is version 7.1.2

and compiled with th following command:

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

  --enable-multibyte \
  --enable-unicode-conversion \
  --with-perl \
  --with-openssl=/usr/local/ssl \
  --enable-odbc \

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

Edit Bug report 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