#27987 [Opn->Asn]: mysqli prepared statements crash mysqld on second execution

ID: 27987 Updated by: sniper@php.net Reported By: laura at cs dot rmit dot edu dot au -Status: Open +Status: Assigned Bug Type: MySQL related Operating System: windows xp -PHP Version: 5.0.0RC1 +PHP Version: 5CVS-2004-04-15 -Assigned To: +Assigned To: edink New Comment: Edin, can you see if you can update the used mysql libs? (for mysqli..) Previous Comments: ------------------------------------------------------------------------ [2004-04-14 13:05:23] laura at cs dot rmit dot edu dot au Installed snapshot, tested, still have same bug. ------------------------------------------------------------------------ [2004-04-14 10:14:01] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip ------------------------------------------------------------------------ [2004-04-13 23:57:52] laura at cs dot rmit dot edu dot au Description: ------------ When using a mysqli prepared statement, first execution works. Second execution crashes the MySQL server. This is using PHP5RC1 and MySQL 5.0.0 alpha max and the sample code given at http://www.php.net/manual/en/function.mysqli-prepare.php (Example 1, OO style) I suspect the problem is caused by a bug in older versions of the MySQL library, as documented here: http://bugs.mysql.com/bug.php?id=2099 and here: http://bugs.mysql.com/bug.php?id=1663 This bug has been fixed in newer versions of the library from MySQL but I would guess the PHP5 version is based on an older (pre January) version of the library. Reproduce code: --------------- http://www.php.net/manual/en/function.mysqli-prepare.php Expected result: ---------------- Output as specified in the manual Actual result: -------------- MySQL server crash. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=27987&edit=1