php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #11766 Unable to save result set in
Submitted: 2001-06-28 00:16 UTC Modified: 2001-06-30 13:51 UTC
From: postmaster at pmlh dot com Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 4.0.6 OS: redhat-6.2
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: postmaster at pmlh dot com
New email:
PHP Version: OS:

 

 [2001-06-28 00:16 UTC] postmaster at pmlh dot 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:

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


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.

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 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 .



Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-06-28 21:27 UTC] postmaster at pmlh dot com
I use mysql_query() / mysql_select_db() instead of mysql_db_query().

Both mysql_errno() and mysql_error() return NOTHING.

The query was successful exectued by mysql.(I can find the query reselt in mysql database)

But why php generated an error?

This error occur on ALL OF my scripts after I had upgraded my php from 4.0.3 to 4.0.6

 [2001-06-28 21:36 UTC] postmaster at pmlh dot com
This is same to #11765 please close();

 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Mar 28 14:01:29 2024 UTC