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]
