[PHP-DEV] PHP 4.0 Bug #6722 Updated: Not a valid MYSQL result resource / Lost connection to MySQL server during quer
ID: 6722
Updated by: cynic
Reported By: [EMAIL PROTECTED]
Old-Status: Feedback
Status: Closed
Bug Type: MySQL related
Assigned To:
Comments:
user feedback:
Ok, bug closed now with PHP 4.0.4 pl1 mysql 3.22.xxx
and apache 1.3.12.
No more problems were founded for 1 week now with
mysql commands.
Previous Comments:
---
[2001-01-13 00:24:07] [EMAIL PROTECTED]
have you experienced this error with newer versions of PHP?
---
[2000-09-13 18:38:09] [EMAIL PROTECTED]
we're using a Apache 1.3.12 Server + PHP 4.02 + MySQL on a Sun Ultra 250 - 256Mo RAM
Patched 106541-11
we have the same message while connecting/select_db/query/fetch_row
"Not a valid MYSQL result resource ..."
mysql_error($connection_id) gives us : "Lost connection to MySQL server during query"
we consult the bug reporting list and :
- when we make a gettype($connection_id) -> "resource"
- we tried to remove the second parameter ($connection_id) in query -> nothing came
In fact, the pb appears sometimes at every request and sometimes do not appears for
4/5 same requests.
It's very unregular !
Source :
");
echo("after query 2: " . gettype($cx_si) . "");
echo("st_si: " . gettype($st_si) . "");
echo("st_si: " . $st_si . "");
$temp = mysql_fetch_row($st_si);
?>
we made many recompilations with differents releases of apache(from 1.3.9 to 1.3.12),
php with 4.01pl2 and 4.0.2
the database is correctly installed/configured/database accessible from the external
the table's got an unique index and contains two records
we tried to make a select * from table where 1=1 and 2=2 ...
to make the select bigger -> nothing came
PHP Configuration : we followed strictly the configuration operations show in the page
installation for uniw static mode on www.php.net
We are now testing the dynamic mode ...
Please could you tell us if you have already noticed this problem before with such a
configuration ??
Thanks by advance.
Nicolas.
PHP.INI:
[PHP]
;;;
; About this file ;
;;;
; This file controls many aspects of PHP's behavior. In order for PHP to
; read it, it must be named 'php.ini'. PHP looks for it in the current
; working directory, in the path designated by the environment variable
; PHPRC, and in the path that was defined in compile time (in that order).
; Under Windows, the compile-time path is the Windows directory. The
; path in which the php.ini file is looked for can be overriden using
; the -c argument in command line mode.
;
; The syntax of the file is extremely simple. Whitespace and Lines
; beginning with a semicolon are silently ignored (as you probably guessed).
; Section headers (e.g. [Foo]) are also silently ignored, even though
; they might mean something in the future.
;
; Directives are specified using the following syntax:
; directive = value
; Directive names are *case sensitive* - foo=bar is different from FOO=bar.
;
; The value can be a string, a number, a PHP constant (e.g. E_ALL or M_PI), one
; of the INI constants (On, Off, True, False, Yes, No and None) or an expression
; (e.g. E_ALL & ~E_NOTICE), or a quoted string ("foo").
;
; Expressions in the INI file are limited to bitwise operators and parentheses:
; | bitwise OR
; & bitwise AND
; ~ bitwise NOT
; ! boolean NOT
;
; Boolean flags can be turned on using the values 1, On, True or Yes.
; They can be turned off using the values 0, Off, False or No.
;
; An empty string can be denoted by simply not writing anything after the equal
; sign, or by using the None keyword:
;
; foo = ; sets foo to an empty string
; foo = none ; sets foo to an empty string
; foo = "none"; sets foo to the string 'none'
;
; If you use constants in your value, and these constants belong to a dynamically
; loaded extension (either a PHP extension or a Zend extension), you may only
; use these constants *after* the line that loads the extension.
;
; All the values in the php.ini-dist file correspond to the builtin
; defaults (that is, if no php.ini is used, or if you delete these lines,
; the builtin defaults will be identical).
; Language Options ;
engine = On ; Enable the PHP scripting language engine
under Apache
short_open_tag = On ; allow the tags are recognized.
asp_tags= Off ; allow ASP-style <% %> tags
precision = 14 ; number of significant digits displayed in
floating point numbers
y2k_compliance = Off ; whether to be year 2000 compliant (will cause
problems with non y2k
[PHP-DEV] PHP 4.0 Bug #6722 Updated: Not a valid MYSQL result resource / Lost connection to MySQL server during quer
ID: 6722
Updated by: cynic
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Feedback
Bug Type: MySQL related
Assigned To:
Comments:
have you experienced this error with newer versions of PHP?
Previous Comments:
---
[2000-09-13 18:38:09] [EMAIL PROTECTED]
we're using a Apache 1.3.12 Server + PHP 4.02 + MySQL on a Sun Ultra 250 - 256Mo RAM
Patched 106541-11
we have the same message while connecting/select_db/query/fetch_row
"Not a valid MYSQL result resource ..."
mysql_error($connection_id) gives us : "Lost connection to MySQL server during query"
we consult the bug reporting list and :
- when we make a gettype($connection_id) -> "resource"
- we tried to remove the second parameter ($connection_id) in query -> nothing came
In fact, the pb appears sometimes at every request and sometimes do not appears for
4/5 same requests.
It's very unregular !
Source :
");
echo("after query 2: " . gettype($cx_si) . "");
echo("st_si: " . gettype($st_si) . "");
echo("st_si: " . $st_si . "");
$temp = mysql_fetch_row($st_si);
?>
we made many recompilations with differents releases of apache(from 1.3.9 to 1.3.12),
php with 4.01pl2 and 4.0.2
the database is correctly installed/configured/database accessible from the external
the table's got an unique index and contains two records
we tried to make a select * from table where 1=1 and 2=2 ...
to make the select bigger -> nothing came
PHP Configuration : we followed strictly the configuration operations show in the page
installation for uniw static mode on www.php.net
We are now testing the dynamic mode ...
Please could you tell us if you have already noticed this problem before with such a
configuration ??
Thanks by advance.
Nicolas.
PHP.INI:
[PHP]
;;;
; About this file ;
;;;
; This file controls many aspects of PHP's behavior. In order for PHP to
; read it, it must be named 'php.ini'. PHP looks for it in the current
; working directory, in the path designated by the environment variable
; PHPRC, and in the path that was defined in compile time (in that order).
; Under Windows, the compile-time path is the Windows directory. The
; path in which the php.ini file is looked for can be overriden using
; the -c argument in command line mode.
;
; The syntax of the file is extremely simple. Whitespace and Lines
; beginning with a semicolon are silently ignored (as you probably guessed).
; Section headers (e.g. [Foo]) are also silently ignored, even though
; they might mean something in the future.
;
; Directives are specified using the following syntax:
; directive = value
; Directive names are *case sensitive* - foo=bar is different from FOO=bar.
;
; The value can be a string, a number, a PHP constant (e.g. E_ALL or M_PI), one
; of the INI constants (On, Off, True, False, Yes, No and None) or an expression
; (e.g. E_ALL & ~E_NOTICE), or a quoted string ("foo").
;
; Expressions in the INI file are limited to bitwise operators and parentheses:
; | bitwise OR
; & bitwise AND
; ~ bitwise NOT
; ! boolean NOT
;
; Boolean flags can be turned on using the values 1, On, True or Yes.
; They can be turned off using the values 0, Off, False or No.
;
; An empty string can be denoted by simply not writing anything after the equal
; sign, or by using the None keyword:
;
; foo = ; sets foo to an empty string
; foo = none ; sets foo to an empty string
; foo = "none"; sets foo to the string 'none'
;
; If you use constants in your value, and these constants belong to a dynamically
; loaded extension (either a PHP extension or a Zend extension), you may only
; use these constants *after* the line that loads the extension.
;
; All the values in the php.ini-dist file correspond to the builtin
; defaults (that is, if no php.ini is used, or if you delete these lines,
; the builtin defaults will be identical).
; Language Options ;
engine = On ; Enable the PHP scripting language engine
under Apache
short_open_tag = On ; allow the tags are recognized.
asp_tags= Off ; allow ASP-style <% %> tags
precision = 14 ; number of significant digits displayed in
floating point numbers
y2k_compliance = Off ; whether to be year 2000 compliant (will cause
problems with non y2k compliant browsers)
output_buffering= Off ; Output buffering allows you to send header lines
(including cookies)
; even after you send body
content, in the price of slowing PHP's
