SQLSTATE[22003]: Numeric value out of range: 1264

Support & Bugs
1

After Upgrading I am getting SQL Errors in my PHP logs:
Error query: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column ‘time_server’ 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_server, idaction_name) VALUES

I noticed it is similar to 306 just a different Column. My error happens while importing the log files. This causes the log file to not import all the way so I have incomplete data.

2

Hi,

This is the same issue as

Some browsers are reporting absurdly long page load times and at the moment Matomo just fails when trying to insert them