Pdo::mysql_attr_max_buffer_size

SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. ...

This one can be a royal pain to deal with.  Never stack statements to be executed in one go.  Nobody ever mentions this possibility in all the posts I've seen dealing with this error.

This example is a Zend Framework example but the theory is the same.

As in:

$sql = exec[$sql];
?>

This will run fine but PDO will balk with the 'unbuffered' error if you follow this with another query.

Instead do:

$sql = exec[$sql];

________số 8

$sql = exec[$sql];
?>

This one can be a royal pain to deal with.  Never stack statements to be executed in one go.  Nobody ever mentions this possibility in all the posts I've seen dealing with this error.0

Chủ Đề