|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #27987 mysqli prepared statements crash mysqld on second execution
Submitted: 2004-04-13 23:57 UTC Modified: 2004-04-15 04:50 UTC
From: laura at cs dot rmit dot edu dot au Assigned: edink (profile)
Status: Wont fix Package: MySQL related
PHP Version: 5CVS-2004-04-15 OS: windows xp
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Bug Type:
From: laura at cs dot rmit dot edu dot au
New email:
PHP Version: OS:


 [2004-04-13 23:57 UTC] laura at cs dot rmit dot edu dot au
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
(Example 1, OO style)

I suspect the problem is caused by a bug in older versions of the MySQL library, as documented here:
and here:

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:

Expected result:
Output as specified in the manual

Actual result:
MySQL server crash.


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2004-04-14 10:14 UTC]
Please try using this CVS snapshot:
For Windows:

 [2004-04-14 13:05 UTC] laura at cs dot rmit dot edu dot au
Installed snapshot, tested, still have same bug.
 [2004-04-14 22:25 UTC]
Edin, can you see if you can update the used mysql libs? (for mysqli..)
 [2004-04-15 04:50 UTC]
Sorry we are not able to upgrade the libs since mysql ab does not provide them.
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Mon Apr 15 15:01:29 2024 UTC