Hi
I am getting this error when I try to archive trace data to the database. I found these posts but there is no final solution.
[ SQLSTATE[22003]: Numeric value out of range: 1264 ]
[ https://github.com/matomo-org/matomo/issues/17035 ]
My current version is 4.15.0.
Any idea to solve?
| ERROR | Piwik\Tracker\Handler | 2024-01-10 15:49:20 UTC | 114e5 | Exception: /var/www/matomo/core/Tracker/Db/Pdo/Mysql.php(238): Error query: Error query: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column ‘time_transfer’ at row 1 In query: UPDATE matomo_log_link_visit_action SET time_network = ?, time_server = ?, time_transfer = ?, time_dom_processing = ?, time_dom_completion = ?, time_on_load = ? WHERE idlink_va = ? Parameters: array ( |
|---|---|---|---|---|
| ERROR | Piwik\Tracker\Handler | 2024-01-10 15:49:19 UTC | 7ddfd | ) [Query: , CLI mode: 0] |
| ERROR | Piwik\Tracker\Handler | 2024-01-10 15:49:19 UTC | 7ddfd | 6 => 1105937871, |
| ERROR | Piwik\Tracker\Handler | 2024-01-10 15:49:19 UTC | 7ddfd | 5 => 13, |
| ERROR | Piwik\Tracker\Handler | 2024-01-10 15:49:19 UTC | 7ddfd | 4 => 5131, |
| ERROR | Piwik\Tracker\Handler | 2024-01-10 15:49:19 UTC | 7ddfd | 3 => 252, |
| ERROR | Piwik\Tracker\Handler | 2024-01-10 15:49:19 UTC | 7ddfd | 2 => 1704627685435, |
| ERROR | Piwik\Tracker\Handler | 2024-01-10 15:49:19 UTC | 7ddfd | 1 => 92, |
| ERROR | Piwik\Tracker\Handler | 2024-01-10 15:49:19 UTC | 7ddfd | 0 => 208, |