Bug #12029 Updated: "--with-apxs" can cause the error "MySQL: Unable to save result set in"

ID: 12029 User updated by: root@byone.com Reported By: root@byone.com Old Status: Feedback Status: Open Bug Type: MySQL related Operating System: Linux PHP Version: 4.0.6 and 4.1.0RC3 New Comment: I had upgraded mysql and recompiled php-4.1.0RC3 as "./configure" but still nothing changed. I think the error may relate to my apache-1.3.14. Unfortunately my job was changed, and now I have got no time to update my apache and other modules, sometime or other I will update them all, I wish all would be fine at that time. So if someone others didn't meet this problem, close this thread. THX for support. Previous Comments: ------------------------------------------------------------------------ [2001-11-21 04:40:26] mfischer@php.net Maybe this is related to multibyte support some sort of? Can you try to minimize as much ./configure options as possible (at best, use no option at all, mysql support is auto-builtin) and see if it works? Also, can you try against another MySQL Server version? Can you try an --enable-debug build? ------------------------------------------------------------------------ [2001-11-20 22:01:56] root@byone.com Yes , I tried. Nothing changed. Maybe there r some errors with my Apache or conflict with some other modules. Maybe not. ------------------------------------------------------------------------ [2001-11-20 19:25:56] mfischer@php.net Relevant information merged from 11765 (bogus now): [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 . [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-11-20 19:22:36] mfischer@php.net Hmm .. weird. Can you give it a try with latest RC http://www.php.net/~zeev/php-4.1.0RC3.tar.gz Feedback. Information from 12009 (now bogus): ---------------- mysql_query("INSERT INTO intranet (login,imie_nazwisko,haslo) VALUES ('milewskij','','657998')"); './configure' '--prefix=/usr' '--with-apxs=/usr/bin/apxs' '--with-regex=system' '--with-config-file-path=/etc/php4/apache' '--enable-calendar' '--without-dom' '--enable-filepro' '--enable-ftp' '--enable-sysvsem--enable-sysvshm' '--enable-track-vars' '--enable-trans-sid' '--disable-static' '--with-gd' '--with-mm' '--with-mysql=/usr/local/mysql' '--with-pcre-regex=/usr' '--enable-sockets' '--with-ttf' '--with-yp' '--with-zlib' '--with-jpeg-dir=/usr' '--with-png-dir=/usr' it crashes on INSERT and DELETE query (not on SELECT) I read FAQ and that recompiling with path to mySQL will solve the problem, but it doesn't the same script running on redhat 7 with PHP 4.0.2 and the same mySQL and mod_auth_mysql returns no error please help me as soon as you can Jakub Formela phpinfo: http://new.pharmag.pl script with error http://new.pharmag.pl/strony/run/konw_users.php?rodzaj=intranet -------------- ------------------------------------------------------------------------ [2001-07-15 22:15:16] root@byone.com WHY NOT OPEN??? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/?id=12029 Edit this bug report at http://bugs.php.net/?id=12029&edit=1