Error when creating a new segment

Marie-Laure · December 4, 2023, 9:06am

I got this error after creating a new segment of visit:

WARNING: /libs/Zend/Db/Statement/Pdo.php(229): Warning - Array to string conversion - Matomo 5.0.0-rc8

Any idea on how to resolve this ?

heurteph-ei · December 4, 2023, 1:28pm

Hi @Marie-Laure
Thanks for the report. An issue has been reported on October, the 18th:

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)

KimCarolyn · December 4, 2023, 3:07pm

Hey @heurteph-ei ,

I’ve got the same error message. Does this mean the created segment won’t work correctly?

heurteph-ei · December 4, 2023, 3:31pm

Hi @KimCarolyn,
I don’t know if this bug impacts the segment creation / processing…
Maybe add a question as comment in the ticket…?

KimCarolyn · December 5, 2023, 2:21pm

Hi @heurteph-ei thank you for responding. I have added a question in the ticket.

heurteph-ei · December 6, 2023, 5:11pm

The reply :

Hi KimCarolyn it looks like the code that throws the error is checking whether an archive invalidation exists, so it seems unlikely that it would cause the segment data to be inaccurate, but it could potentially prevent a segment being updated - unfortunately it’s hard to tell without more investigation.

LaurentN · February 1, 2024, 9:50am

Hi, I’m also having the same issue as @KimCarolyn when creating a simple segment on a Matomo Cloud site (Acquisition Channel = search).

WARNING: /libs/Zend/Db/Statement/Pdo.php(229): Warning - Array to string conversion - Matomo 5.0.1 - 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)

Don’t know what to do here

Thanks for any idea

Good’day