WARNING: /libs/Zend/Db/Statement/Pdo.php(229)

Wai_K_Chiu · March 8, 2024, 8:08am

I received 11 times the same warming:

WARNING: /libs/Zend/Db/Statement/Pdo.php(229): Warning - Array to string conversion - Matomo 5.0.2 - Please report this message in the Matomo forums: https ://forum.matomo.org (please do a search first as it might have been reported already) (Module: API, Action: get, Method: API.get, In CLI mode: false)

There are many somular post in the forum but none of them does give explanation of how to fix it

heurteph-ei · March 14, 2024, 1:46pm

Hi @Wai_K_Chiu
It seems this has been reported:

github.com/matomo-org/matomo

Warning - Array to string conversion in Pdo.php(229) from DataAccess/Model.php

opened 10:12PM - 17 Oct 23 UTC

tsteur

Bug

Saw below warning in Matomo 5 in our logs. Unsure if this is new to Matomo 5 or …has happened before in Matomo 4. Looking at `core/DataAccess/Model.php(914)` maybe there's an issue when eg `$idSite` is an array or so? Unfortunately, I don't have more information > WARNING CoreAdminHome[2023-10-02 21:21:08 UTC] [d2480 /libs/Zend/Db/Statement/Pdo.php(229): Warning - Array to string conversion - Matomo 5.0.0-rc4 - Please report this message in the Matomo forums: https://forum.matomo.org (please do a search first as it might have been reported already) [internal function]: Piwik\ErrorHandler::errorHandler(),#1/libs/Zend/Db/Statement/Pdo.php(229),#2/libs/Zend/Db/Statement.php(300),#3/libs/Zend/Db/Adapter/Abstract.php(479),#4/libs/Zend/Db/Adapter/Pdo/Abstract.php(238),#5/core/Db/Adapter/Pdo/Mysql.php(325),#6/libs/Zend/Db/Adapter/Abstract.php(827),#7/core/Db.php(344),#8/core/DataAccess/Model.php(914),#9/core/ArchiveProcessor/Loader.php(530)

You can follow the issue resolution on the GitHub ticket…