ID: 12029
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Old Summary: "--with-apxs" can cause the error "MySQL: Unable to save result set in"
Status: Feedback
Bug Type: MySQL related
Operating System: Linux
PHP Version: 4.0.6
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[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!
------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found 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]
