Project

General

Profile

Actions

Bug #82686

closed

MySQL error when running OptimizeDatabaseTableTask with pdo_mysql driver

Added by Alexander Stehlik over 6 years ago. Updated about 4 years ago.

Status:
Closed
Priority:
Should have
Category:
scheduler
Target version:
-
Start date:
2017-10-06
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
8
PHP Version:
7.1
Tags:
Complexity:
Is Regression:
Sprint Focus:

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.

Actions

Also available in: Atom PDF