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. NP. --- Bug Database <[EMAIL PROTECTED]> a écrit : > 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 : > > <HTML> > <? > $cx_si = mysql_connect("localhost","root","toto"); > mysql_select_db("si",$cx_si); > $sql = "select * from USERS;"; > $st_si = mysql_query($sql); > echo("after : " . mysql_error($cx_si) . "<BR>"); > echo("after query 2: " . gettype($cx_si) . "<BR>"); > echo("st_si: " . gettype($st_si) . "<BR>"); > echo("st_si: " . $st_si . "<BR>"); > $temp = mysql_fetch_row($st_si); > ?> > </HTML> > > > 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 <? tag. otherwise, > only <?php and <script> 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 > ; output layer a bit. > ; You can enable output >buffering by in > runtime by calling the output > ; buffering functions, or >enable output > buffering for all files > ; by setting this directive to >On. > implicit_flush = Off ; Implicit flush tells PHP to > tell the output layer to flush itself > ; automatically after every >output block. > This is equivalent to > ; calling the PHP function >flush() after each > and every call to print() > ; or echo() and each and every >HTML block. > ; Turning this option on has >serious > performance implications, and > ; is generally recommended for >debugging > purposes === message truncated === ===== Nicolas PERRIN Consultant ODNS [EMAIL PROTECTED] [EMAIL PROTECTED] Tél: (33) 06.20.31.50.36 / (33) 01.64.80.90.90 __________________________________________________ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- 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]