|  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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
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-2023 The PHP Group
All rights reserved.
Last updated: Mon Feb 06 00:05:48 2023 UTC