|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #57540 Problem - Error number 2014 - PDO, MySQL 5.0.33, ZF 0.7.0, PHP 5.2.1
Submitted: 2007-02-21 14:01 UTC Modified: 2008-09-12 13:13 UTC
From: drpajak at wp dot pl Assigned:
Status: Closed Package: PDO_MYSQL (PECL)
PHP Version: 5.2.1 OS: XP +SP2
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: drpajak at wp dot pl
New email:
PHP Version: OS:


 [2007-02-21 14:01 UTC] drpajak at wp dot pl
PDO + ZF + Stored Procedure

Problem with execution two (or more) stored procedure in one function

Reproduce code:
$sql='CALL porcedure_1(1)';
$db = Zend::registry('db');	
$stmt = $db -> prepare($sql);
$stmt -> execute();
$row = $stmt->fetch();

$sql='CALL porcedure_2(1)';
$stmt = $db -> prepare($sql);
$stmt -> execute();
$row = $stmt->fetch();


Expected result:
results array

Actual result:
PDOException Object ( [message:protected] => SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2007-02-21 14:04 UTC] drpajak at wp dot pl
 [2007-02-21 15:35 UTC] drpajak at wp dot pl
I think, this is a problem with stored procedure +PDO beacause
when I make that:

$sql='SELECT * FROM table';
$db = Zend::registry('db');	
$stmt = $db -> prepare($sql);
$stmt -> execute();
$row = $stmt->fetch();

$sql='CALL porcedure_2(1)';
$stmt = $db -> prepare($sql);
$stmt -> execute();
$row = $stmt->fetch();

work everything 

when stored procedure is on first place - it doesn't work

ps - i apologize for my English
 [2007-02-22 10:30 UTC] drpajak at wp dot pl

i maked a class

class connectDB
        private static $dbConn;
	private function __construct ()

        public static function setConnection ( )
	   $config = Zend::registry('config');
   	   self::$dbConn = Zend_Db::factory($config->db->adapter, $config->db->config->asArray());
	   return self::$dbConn; 

and before executing a procedure i make new db connection

$db = connectDB::setConnection() ;

it's work

I know it is not fairest solution, but I don't find better solution
 [2008-09-12 13:13 UTC] johannes at schlueters dot de
This bug has been fixed in CVS.

In case this was a documentation problem, the fix will show up at the
end of next Sunday (CET) on

In case this was a website problem, the change will show
up on the website in short time.
Thank you for the report, and for helping us make PECL better.

Should be fixed with 5.3 when using mysqlnd (--with-pdo-mysql=mysqlnd or official PHP windows builds)
PHP Copyright © 2001-2022 The PHP Group
All rights reserved.
Last updated: Tue Aug 16 01:05:45 2022 UTC