General error: 2014 Cannot execute queries while other unbuffered queries are active

[itaym02]

I have the following code:

$MyPdo->beginTransaction();
$MyPdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY,true);
$MyPdo->exec("update t1 set f1=1;update t2 set f1=2");
$MyPdo->commit ();

This is all I have, and still, I get:

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.

Any ideas how to fix this beside breaking it to single queries and doing some kind of cursor clean up in between each call?

[big_nerd]

I had the same error with my first PDO attempt, however I was using Zend Framework so the execution was a little different, but I can give you some suggestions, first I will give you a note from the manual, then you can see the attributes I added to end up getting it to work right.

Try this:

As per the PHP Manual,

When initializing the PHP statement Try:

$MyPdo = new PDO("mysql:dbname=dbname;host=some.ip", "user", "pass", array(
      PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true,
   ));

I also user some other PDO directives, PDO::ATTR_PERSISTENT and PDO::ATTR_LIMIT_PREPARES

$MyPdo = new PDO("mysql:dbname=dbname;host=some.ip", "user", "pass", array(
      PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true,
      PDO::ATTR_PERSISTENT => true,
      PDO::ATTR_LIMIT_PREPARES => true
   ));

If the above doesn't work out for you, you can try adding the other parameters using the same method as you have described.

// Your Method, if above doesnt work
$MyPdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY,true);
$MyPdo->setAttribute(PDO::ATTR_PERSISTENT,true);
$MyPdo->setAttribute(PDO::ATTR_LIMIT_PREPARES,true);

Best of luck

[itaym02]

No luck, I currently have to split the queries