ID: 11766
User Update by: [EMAIL PROTECTED]
Status: Open
Bug Type: MySQL related
Operating system: redhat-6.2
PHP Version: 4.0.6
Description: Unable to save result set in
I 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
database)
But why php generated an error?
This error occur on ALL OF my scripts after I had upgraded my php from 4.0.3 to 4.0.6
Previous Comments:
---------------------------------------------------------------------------
[2001-06-28 00:16:56] [EMAIL PROTECTED]
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 .
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=11766
--
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]
