Bug #70167 [Opn->Fbk]: Cannot execute queries while other unbuffered queries are active

Edit report at https://bugs.php.net/bug.php?id=70167&edit=1 ID: 70167 Updated by: requinix@php.net Reported by: hiren at aspl dot in Summary: Cannot execute queries while other unbuffered queries are active -Status: Open +Status: Feedback Type: Bug Package: PDO MySQL Operating System: Linux PHP Version: Irrelevant Block user comment: N Private report: N New Comment: Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. Previous Comments: ------------------------------------------------------------------------ [2015-07-30 06:49:48] hiren at aspl dot in Below is MySQL version: mysql Ver 14.14 Distrib 5.5.43, for Linux (x86_64) using readline 5.1 ------------------------------------------------------------------------ [2015-07-30 06:44:31] hiren at aspl dot in Description: ------------ Error is: 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 attribute. Environment: PHP 5.5.25 mysqlnd 5.0.11-dev - 20120503 - $Id: 15d5c781cfcad91193dceae1d2cdd127674ddb3e $ PDO (1.0.4dev) pdo_mysql (1.0.2) Symfony 1.4 Doctrine 1.2.4 I already tried with setting PDO::MYSQL_ATTR_USE_BUFFERED_QUERY but seems not working and still facing the error. It seems to be having some issue with mysqlnd native library. Apart I made sure that PDO library is using mysqlnd native library and not the other one: php -r "var_dump(function_exists('mysqli_get_client_stats'));" bool(true) Please help. Many thanks. ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=70167&edit=1