Bug #11765 Updated: Warning: MySQL: Unable to save result set in

ID: 11765 User Update by: root@byone.com Status: Open Bug Type: MySQL related Operating system: redhat-6.2 PHP Version: 4.0.6 Description: Warning: MySQL: Unable to save result set in I upgraded to mysql-3.23.39 and recompiled php-4.0.6 but nothing changed. Previous Comments: --------------------------------------------------------------------------- [2001-06-28 21:25:12] root@byone.com BTW : This error occur on ALL OF my scripts after I had upgraded my php from 4.0.3 to 4.0.6 --------------------------------------------------------------------------- [2001-06-28 21:21:26] root@byone.com Yes I use 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? --------------------------------------------------------------------------- [2001-06-28 13:16:05] sniper@php.net Try adding this lines after each mysql function: echo mysql_errno().": ".mysql_error()."<BR>"; This way you should get the reason why it doesn't work. And FYI: Use mysql_query() / mysql_select_db() instead of mysql_db_query(). --Jani --------------------------------------------------------------------------- [2001-06-27 23:37:47] root@byone.com 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 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 --------------------------------------------------------------------------- [2001-06-27 23:06:49] root@byone.com 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: Warning: MySQL: Unable to save result set in /path/to/sql.php3 on line 33 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. 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 . --------------------------------------------------------------------------- The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online. Full Bug description available at: http://bugs.php.net/?id=11765