#34550 [Bgs-Opn]: database connections dissappears at custom session handlers
ID: 34550
User updated by: rudy dot metzger at pareto dot nl
Reported By: rudy dot metzger at pareto dot nl
-Status: Bogus
+Status: Open
Bug Type: Session related
Operating System: Redhat ES 3
PHP Version: 5.0.5
New Comment:
Sorry to be such a pain in the a$$, but i cannot agree to this. I did
more tests and updated my page at http://parlnx01.pareto.nl/phpbug/
with more info. Maybe it was a misunderstanding/misinterpretation of my
error report.
Please have a look again at the url, as this error is 100%
reproduceable for me, on various platforms with various MySQL version.
So it seems to be a bug of PHP (the mysqli extension?).
Previous Comments:
[2005-09-20 11:14:51] [EMAIL PROTECTED]
Sorry, but your problem does not imply a bug in PHP itself. For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system is not the
appropriate forum for asking support questions. Due to the volume
of reports we can not explain in detail here why your report is not
a bug. The support channels will be able to provide an explanation
for you.
Thank you for your interest in PHP.
[2005-09-20 10:47:45] rudy dot metzger at pareto dot nl
Same problem with the snapshot version, see output below:
-
The link identifier after connect. it is validbr
object(mysqli)#3 (0) {
}
Ping of the DB. Returns true, we can ping itbr
bool(true)
PHP Warning: session_start(): Cannot send session cookie - headers
already sent by (output started at
/var/www/zwizzle/zcm/public/test.php:36) in
/var/www/zwizzle/zcm/public/test.php on line 22
PHP Warning: session_start(): Cannot send session cache limiter -
headers already sent (output started at
/var/www/zwizzle/zcm/public/test.php:36) in
/var/www/zwizzle/zcm/public/test.php on line 22
Writing, now it goes wrong! ping returns NULL, which is undefined!br
PHP Warning: Couldn't fetch mysqli in
/var/www/zwizzle/zcm/public/test.php on line 61
NULL
---
The problem is the NULL in the very last line
I am using for MySQL
MySQL-shared-standard-4.1.14-0.rhel3
MySQL-devel-standard-4.1.14-0.rhel3
and my linux is
Linux www1.zwizzle.nl 2.4.21-32.0.1.ELsmp #1 SMP Tue May 17 17:52:23
EDT 2005 i686 i686 i386 GNU/Linux
(Redhat ES3)
Configured with
./configure --with-apxs2 --with-mysqli=/usr/bin/mysql_config --with-gd
--with-zlib --with-openssl --enable-pcntl --with-curl
--enable-mbstring
I reinstalled php-5.0.4 again, and everything works again (the NULL is
then boolean(true))
[2005-09-19 17:39:13] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php5-STABLE-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5.0-win32-latest.zip
Works perfectly fine here.
[2005-09-19 17:20:58] rudy dot metzger at pareto dot nl
fixed, was still in the process of setting it up. sorry
[2005-09-19 17:09:37] [EMAIL PROTECTED]
403 Forbidden
You don't have permission to access /phpbug/ on this server.
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/34550
--
Edit this bug report at http://bugs.php.net/?id=34550edit=1
#34550 [Fbk-Opn]: database connections dissappears at custom session handlers
ID: 34550
User updated by: rudy dot metzger at pareto dot nl
Reported By: rudy dot metzger at pareto dot nl
-Status: Feedback
+Status: Open
Bug Type: Session related
Operating System: Redhat ES 3
PHP Version: 5.0.5
New Comment:
Same problem with the snapshot version, see output below:
-
The link identifier after connect. it is validbr
object(mysqli)#3 (0) {
}
Ping of the DB. Returns true, we can ping itbr
bool(true)
PHP Warning: session_start(): Cannot send session cookie - headers
already sent by (output started at
/var/www/zwizzle/zcm/public/test.php:36) in
/var/www/zwizzle/zcm/public/test.php on line 22
PHP Warning: session_start(): Cannot send session cache limiter -
headers already sent (output started at
/var/www/zwizzle/zcm/public/test.php:36) in
/var/www/zwizzle/zcm/public/test.php on line 22
Writing, now it goes wrong! ping returns NULL, which is undefined!br
PHP Warning: Couldn't fetch mysqli in
/var/www/zwizzle/zcm/public/test.php on line 61
NULL
---
The problem is the NULL in the very last line
I am using for MySQL
MySQL-shared-standard-4.1.14-0.rhel3
MySQL-devel-standard-4.1.14-0.rhel3
and my linux is
Linux www1.zwizzle.nl 2.4.21-32.0.1.ELsmp #1 SMP Tue May 17 17:52:23
EDT 2005 i686 i686 i386 GNU/Linux
(Redhat ES3)
Configured with
./configure --with-apxs2 --with-mysqli=/usr/bin/mysql_config --with-gd
--with-zlib --with-openssl --enable-pcntl --with-curl
--enable-mbstring
I reinstalled php-5.0.4 again, and everything works again (the NULL is
then boolean(true))
Previous Comments:
[2005-09-19 17:39:13] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php5-STABLE-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5.0-win32-latest.zip
Works perfectly fine here.
[2005-09-19 17:20:58] rudy dot metzger at pareto dot nl
fixed, was still in the process of setting it up. sorry
[2005-09-19 17:09:37] [EMAIL PROTECTED]
403 Forbidden
You don't have permission to access /phpbug/ on this server.
[2005-09-19 17:05:42] rudy dot metzger at pareto dot nl
Description:
When using customer session handlers, the database connection during
the write is no longer valid (when using mysqli).
Reproduce code:
---
http://parlnx01.pareto.nl/phpbug
Expected result:
a valid database connection. in above case, a return value of TRUE from
the ping. Curios is that ping should return true/false, but acutally we
got NULL.
Actual result:
--
a lost database connection, ping returns NULL. it is also impossible to
execute queries or issue statements (no DB connection anymore).
--
Edit this bug report at http://bugs.php.net/?id=34550edit=1
#34550 [NEW]: database connections dissappears at custom session handlers
From: rudy dot metzger at pareto dot nl Operating system: Redhat ES 3 PHP version: 5.0.5 PHP Bug Type: Session related Bug description: database connections dissappears at custom session handlers Description: When using customer session handlers, the database connection during the write is no longer valid (when using mysqli). Reproduce code: --- http://parlnx01.pareto.nl/phpbug Expected result: a valid database connection. in above case, a return value of TRUE from the ping. Curios is that ping should return true/false, but acutally we got NULL. Actual result: -- a lost database connection, ping returns NULL. it is also impossible to execute queries or issue statements (no DB connection anymore). -- Edit bug report at http://bugs.php.net/?id=34550edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=34550r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=34550r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=34550r=trysnapshot51 Fixed in CVS:http://bugs.php.net/fix.php?id=34550r=fixedcvs Fixed in release:http://bugs.php.net/fix.php?id=34550r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=34550r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=34550r=needscript Try newer version: http://bugs.php.net/fix.php?id=34550r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=34550r=support Expected behavior: http://bugs.php.net/fix.php?id=34550r=notwrong Not enough info: http://bugs.php.net/fix.php?id=34550r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=34550r=submittedtwice register_globals:http://bugs.php.net/fix.php?id=34550r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=34550r=php3 Daylight Savings:http://bugs.php.net/fix.php?id=34550r=dst IIS Stability: http://bugs.php.net/fix.php?id=34550r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=34550r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=34550r=float No Zend Extensions: http://bugs.php.net/fix.php?id=34550r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=34550r=mysqlcfg
#34550 [Fbk-Opn]: database connections dissappears at custom session handlers
ID: 34550 User updated by: rudy dot metzger at pareto dot nl Reported By: rudy dot metzger at pareto dot nl -Status: Feedback +Status: Open Bug Type: Session related Operating System: Redhat ES 3 PHP Version: 5.0.5 New Comment: fixed, was still in the process of setting it up. sorry Previous Comments: [2005-09-19 17:09:37] [EMAIL PROTECTED] 403 Forbidden You don't have permission to access /phpbug/ on this server. [2005-09-19 17:05:42] rudy dot metzger at pareto dot nl Description: When using customer session handlers, the database connection during the write is no longer valid (when using mysqli). Reproduce code: --- http://parlnx01.pareto.nl/phpbug Expected result: a valid database connection. in above case, a return value of TRUE from the ping. Curios is that ping should return true/false, but acutally we got NULL. Actual result: -- a lost database connection, ping returns NULL. it is also impossible to execute queries or issue statements (no DB connection anymore). -- Edit this bug report at http://bugs.php.net/?id=34550edit=1
#29215 [Bgs-Opn]: mysql_file_type returns bogus data
ID: 29215 User updated by: rudy dot metzger at xs4all dot nl Reported By: rudy dot metzger at xs4all dot nl -Status: Bogus +Status: Open Bug Type: MySQL related Operating System: Linux RH ES 3 PHP Version: 5.0.0 New Comment: parlnx03 select version(); +-+ | version() | +-+ | 4.1.3-beta-standard-log | +-+ 1 row in set (0.00 sec) parlnx03 show create table test; +---++ | Table | Create Table | +---++ | test | CREATE TABLE `test` ( `a` varchar(50) default NULL, `b` int(11) default NULL, `c` datetime default NULL, `d` float default NULL, `e` text ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +---++ 1 row in set (0.00 sec) parlnx03 Do not insert any data into the table (in practise, it does not matter if you insert data or not, the result will be the same) [command] php --version PHP 5.0.0 (cli) (built: Jul 16 2004 13:57:08) Copyright (c) 1997-2004 The PHP Group Zend Engine v2.0.0, Copyright (c) 1998-2004 Zend Technologies ?php $dbh = mysql_connect( 'localhost', 'myself', 'mypwd' ); mysql_select_db( 'test' ); $sql = SELECT a, b, c, d, e FROM test LIMIT 1; $res = mysql_unbuffered_query( $sql, $dbh ); echo Following is off by one index!\n; echo mysql_field_type( $res, 0 ). - should be A, but is B\n; echo mysql_field_type( $res, 1 ). - should be B, but is C\n; echo mysql_field_type( $res, 2 ). - should be C, but is D\n; echo mysql_field_type( $res, 3 ). - should be D, but is E\n; echo mysql_field_type( $res, 4 ). ALWAYS real; echo NOTE: A is missing!\n; mysql_free_result( $res ); mysql_close( $dbh ); ? SCRIPT OUTPUT -- [command] php db.php Following is off by one index! int - should be A, but is B datetime - should be B, but is C real - should be C, but is D blob - should be D, but is E real ALWAYS real NOTE: A is missing! END OUTPUT - As you can see, the output is off by one index (actually, the first field should be -1). The last field is always real (cannot mapped anymore, because index is off). At MySQL 4.1.2 alpha the last one was random (real, unknown, ..) An easy way to reproduce: 1) create the table 2) modify the script with your userid/pwd 3) run the script Happy debugging! And hope I could be of some help. Cheerio /rudy Previous Comments: [2004-07-16 18:35:58] [EMAIL PROTECTED] Please use actual mysql version for server and client (4.1.3-beta). If you will be able to reproduce the bug, send a reproducable and short testscript (including create table statement, and insert statement, output of client and server version) and reopen this bug. [2004-07-16 16:30:42] rudy dot metzger at xs4all dot nl Description: mysql_file_type() returns bogus data. PHP 5.0.0 mysql desc zpm_auth; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | userid | varchar(20) | | PRI | | | | username | varchar(50) | YES | | NULL| | | password | varchar(32) | YES | | NULL| | | creusr | varchar(32) | | | | | | credat | datetime| | | -00-00 00:00:00 | | | modusr | varchar(32) | | | | | | moddat | datetime| | | -00-00 00:00:00 | | +--+-+--+-+-+---+ 7 rows in set (0.00 sec) mysql select version(); +--+ | version()| +--+ | 4.1.2-alpha-standard-log | +--+ 1 row in set (0.00 sec) mysql $sql = SELECT userid FROM zpm_auth LIMIT 1; $res = mysql_query( $sql, $this-DBH() ); $this-EvaluateCommand( $res, false, true, $sql ); $colType = mysql_field_type( $res, 0 ); die( $colType
#29215 [Fbk-Csd]: mysql_file_type returns bogus data
ID: 29215 User updated by: rudy dot metzger at xs4all dot nl Reported By: rudy dot metzger at xs4all dot nl -Status: Feedback +Status: Closed Bug Type: MySQL related Operating System: Linux RH ES 3 PHP Version: 5.0.0 New Comment: Darn, I used an old Mysql-shared library of 4.0.18, although I had server/client/devel of 4.1 installed. Removed the old shared rpms and compiled PHP anew and now it works flawlessly! Sorry to raise this bogus Bug!!! But thanx alot for your quick response and reaction, great work! Cheerio /rudy Previous Comments: [2004-07-19 16:31:36] [EMAIL PROTECTED] Works fine here! What does mysql_get_client_info() returns on your machine? [2004-07-19 15:47:45] rudy dot metzger at xs4all dot nl parlnx03 select version(); +-+ | version() | +-+ | 4.1.3-beta-standard-log | +-+ 1 row in set (0.00 sec) parlnx03 show create table test; +---++ | Table | Create Table | +---++ | test | CREATE TABLE `test` ( `a` varchar(50) default NULL, `b` int(11) default NULL, `c` datetime default NULL, `d` float default NULL, `e` text ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +---++ 1 row in set (0.00 sec) parlnx03 Do not insert any data into the table (in practise, it does not matter if you insert data or not, the result will be the same) [command] php --version PHP 5.0.0 (cli) (built: Jul 16 2004 13:57:08) Copyright (c) 1997-2004 The PHP Group Zend Engine v2.0.0, Copyright (c) 1998-2004 Zend Technologies ?php $dbh = mysql_connect( 'localhost', 'myself', 'mypwd' ); mysql_select_db( 'test' ); $sql = SELECT a, b, c, d, e FROM test LIMIT 1; $res = mysql_unbuffered_query( $sql, $dbh ); echo Following is off by one index!\n; echo mysql_field_type( $res, 0 ). - should be A, but is B\n; echo mysql_field_type( $res, 1 ). - should be B, but is C\n; echo mysql_field_type( $res, 2 ). - should be C, but is D\n; echo mysql_field_type( $res, 3 ). - should be D, but is E\n; echo mysql_field_type( $res, 4 ). ALWAYS real; echo NOTE: A is missing!\n; mysql_free_result( $res ); mysql_close( $dbh ); ? SCRIPT OUTPUT -- [command] php db.php Following is off by one index! int - should be A, but is B datetime - should be B, but is C real - should be C, but is D blob - should be D, but is E real ALWAYS real NOTE: A is missing! END OUTPUT - As you can see, the output is off by one index (actually, the first field should be -1). The last field is always real (cannot mapped anymore, because index is off). At MySQL 4.1.2 alpha the last one was random (real, unknown, ..) An easy way to reproduce: 1) create the table 2) modify the script with your userid/pwd 3) run the script Happy debugging! And hope I could be of some help. Cheerio /rudy [2004-07-16 18:35:58] [EMAIL PROTECTED] Please use actual mysql version for server and client (4.1.3-beta). If you will be able to reproduce the bug, send a reproducable and short testscript (including create table statement, and insert statement, output of client and server version) and reopen this bug. [2004-07-16 16:30:42] rudy dot metzger at xs4all dot nl Description: mysql_file_type() returns bogus data. PHP 5.0.0 mysql desc zpm_auth; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | userid | varchar(20) | | PRI | | | | username | varchar(50) | YES | | NULL| | | password | varchar(32) | YES | | NULL| | | creusr | varchar(32) | | | | | | credat | datetime| | | -00-00 00:00:00 | | | modusr | varchar(32) | | | | | | moddat
Bug #16957: Scripts do not seem to run
From: [EMAIL PROTECTED] Operating system: PowerMac os 8.6 PHP version: 4.2.0 PHP Bug Type: *General Issues Bug description: Scripts do not seem to run I have scripts that run fine in windows environment but don't seem to be processed in a Mac environment. -- Edit bug report at http://bugs.php.net/?id=16957edit=1 -- Fixed in CVS:http://bugs.php.net/fix.php?id=16957r=fixedcvs Fixed in release:http://bugs.php.net/fix.php?id=16957r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=16957r=needtrace Try newer version: http://bugs.php.net/fix.php?id=16957r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=16957r=support Expected behavior: http://bugs.php.net/fix.php?id=16957r=notwrong Not enough info: http://bugs.php.net/fix.php?id=16957r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=16957r=submittedtwice
