ID: 12029
Comment by: rami@eduix.com
Old Reported By: root@byone.com
Reported By: rami@eduix.com
Status: Suspended
Bug Type: MySQL related
Operating System: Linux
PHP Version: 4.0.6 and 4.1.0RC3
New Comment:
I'm pretty sure these unable to save result set are due to pgsql and
mysql co-existence in self-compiled php. Our service worked well
without problems for 8 months with only mysql compiled in, but php
started complaining this immediately when we compiled the pgsql in
also. So this looks like a true bug allright.
Previous Comments:
------------------------------------------------------------------------
[2001-11-27 02:23:32] mfischer@php.net
Suspended at user request.
------------------------------------------------------------------------
[2001-11-27 01:44:01] root@byone.com
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.
------------------------------------------------------------------------
[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
------------------------------------------------------------------------
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