Issue Bug Closed

#82686MySQL error when running OptimizeDatabaseTableTask with pdo_mysql driver

Alexander Stehlik 10/06/17, 11:11 updated 02/27/20, 12:41

Description

When using the pdo_mysql database driver you get the following error when you execute the Optimize MySQL database tables (scheduler) task:

> 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.

It works fine with the mysqli driver.

Reviews 3