ID: 12029 Updated by: mfischer Reported By: [EMAIL PROTECTED] Old Status: Open Status: Feedback Bug Type: MySQL related Operating System: Linux PHP Version: 4.0.6 New Comment:
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 -------------- Previous Comments: ------------------------------------------------------------------------ [2001-07-15 22:15:16] [EMAIL PROTECTED] WHY NOT OPEN??? ------------------------------------------------------------------------ [2001-07-11 04:00:15] [EMAIL PROTECTED] I'm getting the following error message when I execute a query (such as insert or delete or update but NOT to 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_select_db($db); mysql_query($sql); echo "<br>".mysql_errno().":".mysql_error()."<br>"; mysql_close(); ?> The result in browser is: Warning: MySQL: Unable to save result set in /home/0/admin/error.php on line 7 0: MySQL said NOTHING and the query was successful exectued by mysql. (I can find the query reselt in mysqldatabase) But why php generated an error? 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 for apache(libphp4.so) with the following configuration tag: ./configure --with-apxs=/usr/local/apache/bin/apxs \ --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 I configured php for commad line with the following configuration tag: ./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 compiled with th following configuration tag: ./configure --prefix=/usr/local/mysql \ --with-mysqld-user=mysql \ --with-charset=gb2312 \ --with-extra-charsets=all BTW : 1. The script is perfect on mysql-php-4.0.3pl1. 2. This error occurs on ALL OF my scripts after I had upgraded my php from 4.0.3 to 4.0.6. 3. I upgraded to mysql-3.23.39 and recompiled php-4.0.6 but nothing changed. ------------------------------------------------------------------------ [2001-07-11 02:57:46] [EMAIL PROTECTED] What is the configure line for PHP that use used? Derick ------------------------------------------------------------------------ [2001-07-10 21:48:04] [EMAIL PROTECTED] My apache is version 1.3.14 mod_log_mysql mod_auth_mysql mod_perl mod_ssl ./configure \ --with-layout=Apache \ --prefix=/usr/local/apache \ --enable-module=so \ --enable-module=vhost_alias \ --add-module=src/modules/extra/mod_log_mysql.c \ --enable-suexec \ --suexec-caller=99 \ --suexec-docroot=/home/0/admin/suexec \ --suexec-logfile=/usr/local/apache/logs/suexec.log \ --suexec-userdir= \ --suexec-safepath=/usr/local/exec \ --enable-module=ssl \ --activate-module=src/modules/auth_mysql/libauth_mysql.a \ --activate-module=src/modules/perl/libperl.a \ --enable-module=perl ------------------------------------------------------------------------ [2001-07-10 21:41:25] [EMAIL PROTECTED] I had read #12009 and #11765 I found that the same error may be generated by the configuration tag "--with-apxs" I recompiled php-4.0.6 just without "--with-apxs" and then ran the same script error.php(src posted in #12009) through the command line --- root@localhost # php ./error.php X-Powered-By: PHP/4.0.6 Content-type: text/html root@localhost # NO ERROR at all! ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=12029&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]
