Warnings on php logs - anything to worry about or need action?

Bluebird63 · March 15, 2021, 10:51pm

I’m getting these results on my log, the first one frequently, second one not so much (since Matomo 4 upagrade);

PHP Warning: trim() expects parameter 1 to be string, array given in C:\inetpub\wwwroot\piwik\core\Tracker\GoalManager.php

and

Error in Matomo (tracker): Error query: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column ‘time_transfer’ at row 1 In query: INSERT INTO matomo_log_link_visit_action (idvisit, idsite, idvisitor, idaction_url, idaction_url_ref, idaction_name_ref, server_time, idpageview, pageview_position, time_spent_ref_action, time_dom_completion, time_dom_processing, time_network, time_on_load, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

anything i need to do here? Has my db not updated properly?

Lukas · March 16, 2021, 10:18am

Hi,

The latter sounds a lot like

github.com/matomo-org/matomo

don't try to insert unrealistically high values for time_transfer and other performance metrics

opened 10:28AM - 31 Dec 20 UTC

closed 08:10PM - 23 Jun 21 UTC

Findus23

Bug Help wanted not-in-changelog

see https://forum.matomo.org/t/512m-of-memory-limit-is-it-too-little/40047/5 …No page takes 50 years to load, so I guess Matomo should not try to insert invalid values. > [28-Dec-2020 07:09:09 UTC] Error in Matomo (tracker): Error query: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'time_transfer' at row 1 In query: INSERT INTO matomo2_log_link_visit_action (idvisit, idsite, idvisitor, idaction_url, idaction_url_ref, idaction_name_ref, server_time, idpageview, pageview_position, time_spent_ref_action, time_dom_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '620729', 1 => 23, 2 => '&� ��V� ', 3 => '122626', 4 => '122626', 5 => '122625', 6 => '2020-12-28 07:09:09', 7 => 'qDEDCT', 8 => 3, 9 => 185, 10 => 874, 11 => 2180, 12 => 283, 13 => 1608938301263, 14 => '122625', ) Then again it would be interesting to know where they come from.

For the former I don’t have a clue. Do you by chance use ecommerce tracking?
As the only trim() in this file I can find are related to that:

github.com

matomo-org/matomo/blob/4493012f3ad24dc9b773ec7212ca2f38e41ac57c/core/Tracker/GoalManager.php#L565-L575

      
        
            $actionsToLookup[] = array(trim($sku), Action::TYPE_ECOMMERCE_ITEM_SKU);
            $actionsToLookup[] = array(trim($name), Action::TYPE_ECOMMERCE_ITEM_NAME);
            
            
// Only one category
            if (!is_array($category)) {
                $actionsToLookup[] = array(trim($category), Action::TYPE_ECOMMERCE_ITEM_CATEGORY);
            } // Multiple categories
            else {
                $countCategories = 0;
                foreach ($category as $productCategory) {
                    $productCategory = trim($productCategory);