ID: 29283
User updated by: divisor at ad69 dot com
Reported By: divisor at ad69 dot com
Status: Open
Bug Type: MySQL related
Operating System: FreeBSD 4.10
PHP Version: 5.0.0
New Comment:
sorry I've accidently provided wrong mysql version
of course it's mysql 4.1.3 beta
Previous Comments:
------------------------------------------------------------------------
[2004-07-20 20:15:49] divisor at ad69 dot com
Description:
------------
The problem is in CLI as well as in apache module
I have mysql 4.3.1 and php 5.0.0 installed, use mysqli interface to
work with mysql.
In different scripts in different places (mostly random) I get the
following error:
1) Warning message: Statement isn't valid anymore
2) Statetment result contains no data
Reproduce code:
---------------
appears in randomly different places, all like this:
($DB is mysqli object)
if ($stmt=$DB->prepare("select something from table where name=?")) {
$stmt->bind_param('s',$name);
$stmt->execute();
Expected result:
----------------
The same code worked fine on the second server running FreeBSD 5.2.1
without any problems. The main difference between 2 servers I think
that the first one (where bug appears) is a productional server with
many requests to apache/php/mysql, the second one is a development
server with no usage.
Actual result:
--------------
get Warning: Statement isn't valid anymore message and statetment isn't
executed
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=29283&edit=1
