#41997 [Opn]: 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 Bug Type: PDO related Operating System: Windows XP SP2 PHP Version: 5.2.3 -Assigned To: +Assigned To: johannes New Comment: The next PDO_MYSQLND release should fix this Previous Comments: ------------------------------------------------------------------------ [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 ------------------------------------------------------------------------ [2007-07-16 17:30:00] temposeb at free dot fr I encounter exactly the same bug for many months. Environment : Win2000 Pro SP4, Apache 2.2, PHP 5.2.4-dev (Build Date Jul 11 2007 20:03:23), MySQL 5.1.20-beta-community-nt-debug (same thing with MySQL 5.0.x). nitel_defect, where can we find the hacked DLL ? http://source.hackthissite.org/svn/trunk/PDO/php_pdo_mysql.dll is actually DOWN. Thx. ------------------------------------------------------------------------ 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