Bug #11560 Updated: to many sessions are generated when using set_session_save_handler with mysql

ID: 11560 User Update by: martin@gamingeye.com Status: Open Bug Type: *Session related Operating system: Red Hat 7.0 PHP Version: 4.0.5 Description: to many sessions are generated when using set_session_save_handler with mysql Using a session_handler like this one: http://gateway.digitaria.com/~chris/php/mysql_session_handler/mysql_session_handler.phps Using a mySQL-database. Have the following configure './configure' '--with-mysql' '--with-apache=../apache_1.3.20' '--enable-track-vars' '--enable-trans-sid' '--enable-ftp' '-disable-debug' The problem: I have noticed that if you use set_session_save_handler with mysql and you don’t accept cookies and there is a broken image on the page, PHP generates to many sessions: This is an example code that generates this error (named test.php3): <?php mysql_connect ("localhost", "user", "pass"); include("the session file like the one linked above"); session_start(); ?> <img src="fdsafdsaf.jpg"> <?php // count the number of sessions stored in the database $numsessions = mysql_num_rows(mysql_query("select * from sessions")); echo $ numsessions; ?> <br> <a href="test.php3">test</a> Notice how the number of sessions are added, but you still have your same session id. What happens is that PHP generates a number of session ids, that are never used. This problem doesn’t occur if you have cookies enabled, or don’t uses set_session_save_handler. I have also noticed that the image doesn't need to be broken, It can also be a gif and only contain a transparent colour. This generates the same error. Previous Comments: --------------------------------------------------------------------------- [2001-06-19 11:01:09] martin@gamingeye.com Using a session_handler like this one: http://gateway.digitaria.com/~chris/php/mysql_session_handler/mysql_session_handler.phps Using a mySQL-database. Have the following configure './configure' '--with-mysql' '--with-apache=../apache_1.3.20' '--enable-track-vars' '--enable-trans-sid' '--enable-ftp' '-disable-debug' The problem: I have noticed that if you use set_session_save_handler with mysql and you don’t accept cookies and there is a broken image on the page, PHP generates to many sessions: This is an example code that generates this error (named test.php3): <?php mysql_connect ("localhost", "user", "pass"); include("the session file like the one linked above"); session_start(); ?> <img src="fdsafdsaf.jpg"> <?php // count the number of sessions stored in the database $numsessions = mysql_num_rows(mysql_query("select * from sessions")); echo $ numsessions; ?> <br> <a href="test.php3">test</a> Notice how the number of sessions are added, but you still have your same session id. What happens is that PHP generates a number of session ids, that are never used. This problem doesn’t occur if you have cookies enabled, or don’t uses set_session_save_handler. --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=11560