ID: 37605
Updated by: [EMAIL PROTECTED]
Reported By: randall dot carlson at navy dot mil
-Status: Open
+Status: Feedback
Bug Type: PDO related
Operating System: REL 4
PHP Version: 5.1.4
New Comment:
We still need a reproduce script.
Previous Comments:
------------------------------------------------------------------------
[2006-07-25 13:37:27] randall dot carlson at navy dot mil
I've been contacted by another user with the same issue. Please review
with laurinkus at gmail dot com.
------------------------------------------------------------------------
[2006-07-24 21:33:49] laurinkus at gmail dot com
Facing same problem with 5.1.4 on FreeBSD 5.1 and MySQL 5.1.11. Code
extract below:
function getOMXDailySnapshot($submarkets_id)
{
$db = Zend::registry('db');
$stm = $db->prepare('CALL omx_daily_snapshot(:submarket_id)');
$stm->bindValue('submarket_id',$submarkets_id);
$stm->execute();
$result = $stm->fetchAll();
return $result;
}
It seems to me that it is somehow related to result set length.
------------------------------------------------------------------------
[2006-06-28 01:00:02] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2006-06-20 14:44:42] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php5.2-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5.2-win32-latest.zip
Still can't reproduce.
------------------------------------------------------------------------
[2006-06-05 20:50:26] randall dot carlson at navy dot mil
Well, my problem involves database access with PDO, so I don't know how
to convey the problem without a database. As far as the script itself:
<?php
$pdo = new PDO("mysql:host=localhost;dbname=x","x","x");
$stmt = $pdo->prepare("call pdo_test()"/*"select dummy from
dummy;"*/);
$stmt->execute();
echo "<B>outputting...</B><BR>";
while ($rs = $stmt->fetch(PDO::FETCH_OBJ)) {
echo "output: ".$rs->dummy."<BR>";
}
echo "<BR><B>".date("r")."</B>";
?>
That is all of it, except for the MySQL stored procedure script:
create procedure pdo_test() begin select dummy from dummy; end;
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/37605
--
Edit this bug report at http://bugs.php.net/?id=37605&edit=1
