My matomo is going crazy …
i activated allow_include_url_ in php.ini the other day, and i got some warnings/errors from matomo, then i deactivated it … but matomo keeps going crazy often the graphs are wrong or zero, the sites work fine, and visits are collected somewhere, and every now and then the graphs and everything else go back to working regularly, but a few hours later it can go back to zero …
What happen?
Hi,
If your visitor log is looking okay and the graphs are just delayed, please check if archiving is running successfully. If you have set up a cronjob, make sure it is running successfully. If you haven’t, you might want to do this now and disable browser archiving so that the reports are generated in the background instead of when you request them.
Cronjob looks okay…
INFO [2020-10-27 10:05:05] 97059 Done archiving!
INFO [2020-10-27 10:05:05] 97059 ---------------------------
INFO [2020-10-27 10:05:05] 97059 SUMMARY
INFO [2020-10-27 10:05:05] 97059 Processed 0 archives.
INFO [2020-10-27 10:05:05] 97059 Total API requests: 0
INFO [2020-10-27 10:05:05] 97059 done: 0 req, 2608 ms, no error
INFO [2020-10-27 10:05:05] 97059 Time elapsed: 2.608s
And now everything seems to work …
but I haven’t done much … so what happens?
No, sorry … it never works …
i looked on the laptop, but i realized now that when opening “all sites” it opens on october 12th … and october 12th it worked, if i move to october 27th all graphs are zero …
What is happening? Something looks broken, but I don’t understand what …
Still broken… suggestions?
I just did the 4.0.0-b4 update, I was hoping it would fix the situation … but it seems not … still all the graphs to zero … 
Please help 
Hi,
Maybe check the PHP error log or webserver log or tmp/logs/matomo.log (inside the Matomo directory) for errors.
The matomo logs are empty, but I found something in the php errors.
[25-Oct-2020 11:21:56 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[25-Oct-2020 11:35:08 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 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_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1784258', 1 => 28, 2 => '<CC><96><BE><91><E7>U<A9><ED>', 3 => '1063290', 4 => '1236741', 5 => '1063289', 6 => '2020-10-25 11:35:08', 7 => 'h5ztjt', 8 => 3, 9 => 30, 10 => 380, 11 => 515, 12 => 196, 13 => 1603594967607, 14 => '1063289', )
sudo grep "Matomo" /var/log/php-fpm/www-error.log
[25-Oct-2020 11:21:56 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[25-Oct-2020 11:35:08 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 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_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1784258', 1 => 28, 2 => '̖���U��', 3 => '1063290', 4 => '1236741', 5 => '1063289', 6 => '2020-10-25 11:35:08', 7 => 'h5ztjt', 8 => 3, 9 => 30, 10 => 380, 11 => 515, 12 => 196, 13 => 1603594967607, 14 => '1063289', )
[25-Oct-2020 17:46:15 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[25-Oct-2020 18:00:16 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[25-Oct-2020 18:05:00 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 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_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1787627', 1 => 17, 2 => 'ȧ�W���z', 3 => '1099958', 4 => '1099958', 5 => '1099957', 6 => '2020-10-25 18:05:00', 7 => 'QFZ0Db', 8 => 2, 9 => 4, 10 => 1602022801560, 11 => '1099957', )
[25-Oct-2020 20:48:14 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 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_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1789155', 1 => 36, 2 => 'b�F�\'SO`', 3 => '1010883', 4 => '1010883', 5 => '1010882', 6 => '2020-10-25 20:48:14', 7 => 'YKM7tM', 8 => 4, 9 => 57, 10 => 1604, 11 => 0, 12 => 4183, 13 => 1603332853549, 14 => '1010882', )
[25-Oct-2020 23:23:16 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 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_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1790999', 1 => 40, 2 => '���ȗ�', 3 => '392773', 4 => '392773', 5 => '392772', 6 => '2020-10-25 23:23:16', 7 => '4QgPLS', 8 => 2, 9 => 24, 10 => 1602022801613, 11 => '392772', )
[26-Oct-2020 02:57:01 UTC] Error in Matomo (tracker): An unexpected website was found in the request: website id was set to '24' .
[26-Oct-2020 06:12:45 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[26-Oct-2020 06:57:55 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[26-Oct-2020 09:39:58 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[26-Oct-2020 11:17:29 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 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_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1796622', 1 => 30, 2 => '����}V�', 3 => '1043607', 4 => '1253659', 5 => '1043606', 6 => '2020-10-26 11:17:29', 7 => 'SU7JuW', 8 => 3, 9 => 196, 10 => 1354, 11 => 1478, 12 => 244, 13 => 1603617560292, 14 => '1043606', )
[26-Oct-2020 16:02:19 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[26-Oct-2020 16:03:13 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[26-Oct-2020 16:04:37 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[26-Oct-2020 16:07:12 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[26-Oct-2020 16:11:09 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[26-Oct-2020 17:38:36 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[26-Oct-2020 18:09:06 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 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_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1799784', 1 => 34, 2 => '�(\\v��c', 3 => '823630', 4 => '823630', 5 => '823629', 6 => '2020-10-26 18:09:06', 7 => '5z89qF', 8 => 2, 9 => 13, 10 => 1602022801886, 11 => '823629', )
[26-Oct-2020 21:19:36 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[27-Oct-2020 08:52:18 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[27-Oct-2020 08:52:44 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[27-Oct-2020 10:00:12 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 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_processing, time_', 3 => '250875', 4 => 0, 5 => 0, 6 => '2020-10-27 10:00:12', 7 => 'uS1CPf', 8 => 1, 9 => 0, 10 => 399, 11 => 0, 12 => 257, 13 => 1602956721070, 14 => '101444', )
[27-Oct-2020 17:58:56 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[27-Oct-2020 18:58:29 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[27-Oct-2020 21:25:32 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[28-Oct-2020 02:50:22 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 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_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1815249', 1 => 36, 2 => 'iW��|���', 3 => '529188', 4 => '396099', 5 => '396098', 6 => '2020-10-28 02:50:22', 7 => 'xqvU2G', 8 => 5, 9 => 118, 10 => 690, 11 => 0, 12 => 1473, 13 => 1603842441828, 14 => '529187', )
[28-Oct-2020 02:56:18 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 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_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1815249', 1 => 36, 2 => 'iW��|���', 3 => '529188', 4 => '250875', 5 => '101444', 6 => '2020-10-28 02:56:18', 7 => '2QhBLT', 8 => 8, 9 => 261, 10 => 369, 11 => 0, 12 => 1473, 13 => 1603842441836, 14 => '529187', )
[28-Oct-2020 05:45:12 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[28-Oct-2020 08:15:46 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[28-Oct-2020 09:38:51 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[28-Oct-2020 09:39:24 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[28-Oct-2020 10:28:19 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 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_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1819109', 1 => 31, 2 => '�eB
���', 3 => '19739', 4 => '1200113', 5 => '19738', 6 => '2020-10-28 10:28:19', 7 => 'i1ffw2', 8 => 3, 9 => 57, 10 => 878, 11 => 820, 12 => 305, 13 => 1603611281786, 14 => '19738', )
[28-Oct-2020 10:28:50 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 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_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1819109', 1 => 31, 2 => '�eB
���', 3 => '19739', 4 => '2323', 5 => '2322', 6 => '2020-10-28 10:28:50', 7 => 'JQ9gKw', 8 => 5, 9 => 16, 10 => 878, 11 => 820, 12 => 305, 13 => 1603611281703, 14 => '19738', )
[28-Oct-2020 11:12:37 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[28-Oct-2020 15:34:02 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[28-Oct-2020 15:34:26 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[28-Oct-2020 16:44:23 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[28-Oct-2020 17:51:04 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 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_processing, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1822715', 1 => 11, 2 => 'iSJ;���', 3 => '493365', 4 => 0, 5 => 0, 6 => '2020-10-28 17:51:04', 7 => 'YNnVOt', 8 => 1, 9 => 0, 10 => 2634, 11 => 1602022801580, 12 => '493364', )
[29-Oct-2020 06:56:19 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[29-Oct-2020 10:33:47 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[29-Oct-2020 10:34:26 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[29-Oct-2020 13:45:34 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 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_processing, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1832181', 1 => 11, 2 => 'iSJ;���', 3 => '493365', 4 => 0, 5 => 0, 6 => '2020-10-29 13:45:34', 7 => 'KhRrEt', 8 => 1, 9 => 0, 10 => 2297, 11 => 1602022801604, 12 => '493364', )
[29-Oct-2020 16:46:23 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 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_processing, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1833715', 1 => 11, 2 => '��0���BB', 3 => '1056340', 4 => '1056340', 5 => '1056339', 6 => '2020-10-29 16:46:23', 7 => 'KosTfT', 8 => 2, 9 => 20, 10 => 4247, 11 => 1602022801449, 12 => '1056339', )
[29-Oct-2020 20:05:10 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[29-Oct-2020 21:42:36 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 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_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1836681', 1 => 6, 2 => '�P�jC�4�', 3 => '1273157', 4 => '1273157', 5 => '1273156', 6 => '2020-10-29 21:42:36', 7 => 'VFRxOd', 8 => 2, 9 => 660, 10 => 1602022801551, 11 => '1273156', )
[30-Oct-2020 02:55:49 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 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_processing, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1838908', 1 => 31, 2 => '��� �4�', 3 => '1270253', 4 => 0, 5 => 0, 6 => '2020-10-30 02:55:49', 7 => 'Rv92C9', 8 => 1, 9 => 0, 10 => 2787, 11 => 1602022801569, 12 => '1270252', )
[30-Oct-2020 03:16:48 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[30-Oct-2020 03:40:51 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[30-Oct-2020 05:27:38 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[30-Oct-2020 06:11:57 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 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_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1840284', 1 => 28, 2 => '\\z&=� �a', 3 => '552938', 4 => '1213979', 5 => '552937', 6 => '2020-10-30 06:11:57', 7 => 'C4UBrb', 8 => 3, 9 => 178, 10 => 1490, 11 => 511, 12 => 495, 13 => 1604019092973, 14 => '552937', )
[30-Oct-2020 06:13:10 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 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_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1840284', 1 => 28, 2 => '\\z&=� �a', 3 => '552938', 4 => '552938', 5 => '552937', 6 => '2020-10-30 06:13:10', 7 => 'MVRBM7', 8 => 4, 9 => 73, 10 => 1810, 11 => 511, 12 => 495, 13 => 1604019092949, 14 => '552937', )
[30-Oct-2020 07:27:56 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 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_processing, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1840769', 1 => 31, 2 => ':����� >', 3 => '1073029', 4 => '1073029', 5 => '1073028', 6 => '2020-10-30 07:27:56', 7 => 'UvbuBH', 8 => 2, 9 => 709, 10 => 1962, 11 => 1602022801541, 12 => '1073028', )
[30-Oct-2020 14:22:41 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[30-Oct-2020 18:29:54 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[30-Oct-2020 18:30:16 UTC] Error in Matomo (tracker): Invalid idSite: '0'
I started hunting for the site with id zero, although it seems strange to me that it exists because all my sites have their own id, and above all because I haven’t touched the matomo code for months.
However, if it exists, I will find it, for the moment I have added a security that if the matomo id is empty or zero, it does not include the code in the site.
The other errors I don’t understand them, but they could be due to vk, lately I upload some contents from vk, and sometimes in the titles and texts of vk there are emoticons, those strange signs should be them. But I want to keep them, because they also come out in search engines and when there is an emoticos my link stands out a lot … I would really like to keep them … But will they be the ones to create the matomo block?
In theory it shouldn’t be them, because I’ve been loading from vk for a few months too, but matomo crashed only the other day …
Anyway, can emoticons be understood in matomo?
For the rest, if I find and eliminate the error on id zero, will the graphs come baak work again?
Or will there be some cleaning in the database to do? How can I do it?
Even if I lose some data, it’s not a problem, but it needs to come back to work again.
I checked the source code in all my sites (a long and tedious job), I could not find any id 0 … 
Some more errors:
[02-Nov-2020 03:36:54 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[02-Nov-2020 08:33:01 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 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_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1877055', 1 => 28, 2 => '�%����A�', 3 => '1197776', 4 => '1197776', 5 => '1197775', 6 => '2020-11-02 08:33:01', 7 => 'vhAtgi', 8 => 2, 9 => 36, 10 => 860, 11 => 375, 12 => 132, 13 => 1604281041982, 14 => '1197775', )
[02-Nov-2020 14:45:08 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[02-Nov-2020 17:19:08 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[02-Nov-2020 19:56:57 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[02-Nov-2020 19:57:13 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[02-Nov-2020 20:04:44 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[02-Nov-2020 23:44:51 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[03-Nov-2020 01:48:54 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 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_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1888950', 1 => 36, 2 => '!��`\\笕', 3 => '805307', 4 => '805307', 5 => '805306', 6 => '2020-11-03 01:48:54', 7 => '7QfvY8', 8 => 3, 9 => 240, 10 => 179, 11 => 717, 12 => 305, 13 => 1604349748307, 14 => '805306', )
[03-Nov-2020 01:49:25 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 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_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1888950', 1 => 36, 2 => '!��`\\笕', 3 => '805307', 4 => '805307', 5 => '805306', 6 => '2020-11-03 01:49:25', 7 => 'yY5BxF', 8 => 4, 9 => 31, 10 => 500, 11 => 717, 12 => 305, 13 => 1604349716987, 14 => '805306', )
I just update a couple of plugin and matomo… hope it help
Still not working … what can I do?
This is strange, besides the usual errors today there is an error on the id 24 … which I think is a site that I deleted, and maybe it was cloned … 
[04-Nov-2020 00:55:51 UTC] Error in Matomo (tracker): An unexpected website was found in the request: website id was set to '24' .
[04-Nov-2020 00:58:16 UTC] Error in Matomo (tracker): An unexpected website was found in the request: website id was set to '24' .
[04-Nov-2020 00:59:51 UTC] Error in Matomo (tracker): An unexpected website was found in the request: website id was set to '24' .
[04-Nov-2020 01:00:29 UTC] Error in Matomo (tracker): An unexpected website was found in the request: website id was set to '24' .
[04-Nov-2020 02:01:53 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[04-Nov-2020 03:08:18 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 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_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1902712', 1 => 18, 2 => '$���U�', 3 => '539945', 4 => '0', 5 => '17562', 6 => '2020-11-04 03:08:18', 7 => '0LYdn5', 8 => 2, 9 => 30, 10 => 959, 11 => 2239, 12 => 504, 13 => 1604435000839, 14 => '539944', )
[04-Nov-2020 03:18:15 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 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_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1902712', 1 => 18, 2 => '$���U�', 3 => '539945', 4 => '725211', 5 => '725210', 6 => '2020-11-04 03:18:15', 7 => 'bVf8g2', 8 => 17, 9 => 16, 10 => 111, 11 => 2239, 12 => 504, 13 => 1604435000827, 14 => '539944', )
[04-Nov-2020 04:29:20 UTC] Error in Matomo (tracker): An unexpected website was found in the request: website id was set to '24' .
[04-Nov-2020 04:48:02 UTC] Error in Matomo (tracker): An unexpected website was found in the request: website id was set to '24' .
Can this block matomo?
Update
Stupid bing is looking for id 24…
Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/534+ (KHTML, like Gecko) BingPreview/1.0b
Last errors
[05-Nov-2020 02:18:40 UTC] Error in Matomo (tracker): Invalid idSite: '0'
[05-Nov-2020 05:14:26 UTC] Error in Matomo (tracker): An unexpected website was found in the request: website id was set to '24' .
[05-Nov-2020 06:00:41 UTC] Error in Matomo (tracker): An unexpected website was found in the request: website id was set to '24' .
[05-Nov-2020 12:23:43 UTC] Error in Matomo (tracker): An unexpected website was found in the request: website id was set to '24' .
[05-Nov-2020 12:24:12 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 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_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1917455', 1 => 36, 2 => 'ne#�,y ', 3 => '416614', 4 => 0, 5 => 0, 6 => '2020-11-05 12:24:12', 7 => '5JL15W', 8 => 1, 9 => 0, 10 => 2297, 11 => 2677, 12 => 476, 13 => 1604577555901, 14 => '416613', )
[05-Nov-2020 12:33:14 UTC] Error in Matomo (tracker): An unexpected website was found in the request: website id was set to '24' .
[05-Nov-2020 12:33:22 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 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_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1917456', 1 => 38, 2 => 'lE�' . "\0" . '�\\��', 3 => '203424', 4 => 0, 5 => 0, 6 => '2020-11-05 12:33:22', 7 => 'CtjFoT', 8 => 1, 9 => 0, 10 => 1540, 11 => 695, 12 => 319, 13 => 1604578176504, 14 => '203423', )
[05-Nov-2020 15:31:30 UTC] Error in Matomo (tracker): An unexpected website was found in the request: website id was set to '24' .
[05-Nov-2020 19:17:06 UTC] Error in Matomo (tracker): An unexpected website was found in the request: website id was set to '24' .
[05-Nov-2020 21:11:07 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 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_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '1917499', 1 => 36, 2 => '�i��8/dp', 3 => '1241916', 4 => 0, 5 => 0, 6 => '2020-11-05 21:11:06', 7 => 'jy7BLa', 8 => 1, 9 => 0, 10 => 61, 11 => 374, 12 => 162, 13 => 1604435426348, 14 => '1241915', )