With pdo_mysql driver a database error occurs in backend module

[Sebastian Hofer]

(1/4) #1481889220 TYPO3\CMS\Core\Session\Backend\Exception\SessionNotUpdatedException

Session with id 8d3d7c8d5a57fe7fdd489284d4da611a could not be updated: An exception occurred while executing 'UPDATE `be_sessions` SET `ses_id` = ?, `ses_data` = ?, `ses_userid` = ?, `ses_iplock` = ?, `ses_tstamp` = ? WHERE `ses_id` = ?' with params ["1df819b87b75b6df82c5e7e5bec4f056ff38c8683e9cda76a0c3b463e5985829", "a:1:{s:26:\"formProtectionSessionToken\";s:64:\"86710663151753cbbc6ab6dcf2739fdeb9a6e43dc181dcc57f1675334a326588\";}", 1, "[DISABLED]", 1657010204, "1df819b87b75b6df82c5e7e5bec4f056ff38c8683e9cda76a0c3b463e5985829"]: 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.

‌

This happens because of the

SHOW TABLES like 'nnrestapi_sessions’;

statement executed with

$connection->exec( $statement, $params );

instead of

$connection->fetchAll( $statement, $params );

‌

TYPO3 11.5
nng/nnrestapi 1.3.4

[David Bascom]

Fix issue #10 - with pdo_mysql driver a database error occurs in backend module

→ <<cset e35af4b9f74d>>

[David Bascom]

Thanks for reporting! Will be fixed in next release.
(see commit in dev-branch)