SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'visit_total_actions' at row 1

Support & Bugs
1

Following my upgrade to the latest version, I am getting the following problem when importing logs.

2014/12/06 11:28:11 [error] 2848#0: *29 FastCGI sent in stderr: "PHP message: Error in Piwik (tracker): Error query: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column ‘visit_total_actions’ at row 1 In query: UPDATE piwik_log_visit SET idvisitor = ?, visit_total_time = ?, visit_last_action_time = ?, visit_exit_idaction_url = ?, visit_total_actions = visit_total_actions + 1 , custom_var_k1 = ?, custom_var_v1 = ? WHERE idsite = ? AND idvisit = ? Parameters: array ( 0 => ‘&▒▒▒▒E▒’, 1 => 4852, 2 => ‘2014-11-30 19:18:36’, 3 => 277470, 4 => ‘Not-Bot’, 5 => ‘Mozilla/5.0 (Windows NT 6.3; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0’, 6 => 72, 7 => 21276112, )

Does anyone have any pointers on this problem ?

2

Hi there, thanks for the report. Can you please create an issue on: Issues · matomo-org/piwik · GitHub and we will definitely investigate!

3

I could confirm this issue… changing the column type to INT solve it!

4

Thanks for the report! I created an issue at Numeric value out of range: 1264 Out of range value for column 'visit_total_actions' at row 1 In query · Issue #6834 · matomo-org/piwik · GitHub