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 and 4.1.0RC3
New Comment:
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?
Previous Comments:
------------------------------------------------------------------------
[2001-11-20 22:01:56] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
Relevant information merged from 11765 (bogus now):
[2001-06-27 23:06:49] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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] [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.
------------------------------------------------------------------------
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
--
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]
