#41997 [Opn->Fbk]: pdo_mysql: stored procedure call returning single rowset blocks future queries

ID: 41997 Updated by: uw@php.net Reported By: nitel_defect at yahoo dot com -Status: Open +Status: Feedback Bug Type: PDO related Operating System: Windows XP SP2 PHP Version: 5.2.3 Assigned To: johannes New Comment: Please try using this CVS snapshot: http://snaps.php.net/php5.3-latest.tar.gz For Windows (zip): http://snaps.php.net/win32/php5.3-win32-latest.zip For Windows (installer): http://snaps.php.net/win32/php5.3-win32-installer-latest.msi Previous Comments: ------------------------------------------------------------------------ [2008-05-22 17:32:37] uw@php.net The next PDO_MYSQLND release should fix this ------------------------------------------------------------------------ [2008-01-24 11:46:34] ben at stickyeyes dot com Just to add to this bug, I too experience this problem when trying to execute two stored procedures, one after the other. Unfortunately, the only work around I could get working, was to create a new PDO object for each query (attempting to clone an existing PDO object caused Apache to crash, but thats another bug for another day...) Sucks, but it works. Apache/2.2.4 (Win32) PHP/5.2.3 PDO Driver for MySQL, client library version 5.0.37 MySQL 5.1.22 ------------------------------------------------------------------------ [2008-01-22 13:28:59] felipe@php.net Reclassified: mysql -> pdo ------------------------------------------------------------------------ [2007-08-21 00:08:52] marpiotr at gmail dot com i seem to have the same problem on 5.1.6 on Fedora Core 6 ------------------------------------------------------------------------ [2007-07-16 18:06:49] nitel_defect at yahoo dot com http://www.kpsol.ro/php_pdo_mysql.dll ------------------------------------------------------------------------ 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/41997 -- Edit this bug report at http://bugs.php.net/?id=41997&edit=1