Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Numeric value out of rang 'visit_total_interactions' #11181

Closed
obi12341 opened this issue Jan 12, 2017 · 2 comments
Closed

Numeric value out of rang 'visit_total_interactions' #11181

obi12341 opened this issue Jan 12, 2017 · 2 comments
Labels
duplicate For issues that already existed in our issue tracker and were reported previously.

Comments

@obi12341
Copy link

obi12341 commented Jan 12, 2017 •
edited

Hello,
we are using Log Analytics with a very huge nginx access log and are running into this error after ~ 5.000.000 lines:

"NOTICE: PHP message: Error in Piwik (tracker): Error query: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'visit_total_interactions' at row 1 In query: UPDATE piwik_log_visit SET idvisitor = ?, visit_last_action_time = ?, visit_exit_idaction_url = ?, visit_total_actions = visit_total_actions + 1 , visit_total_interactions = visit_total_interactions + 1 , visit_total_time = ? WHERE idsite = ? AND idvisit = ? Parameters: array ( 0 => 'u�����', 1 => '2017-01-09 13:35:58', 2 => 35211, 3 => 52493, 4 => 1, 5 => 61694, )"

Piwik Version 3.0.0 (official piwik docker)

Seems like the field visit_total_interactions is too small.
Any way to solve this problem?

Best regards,

obi12341
@obi12341
Copy link
Author

obi12341 commented Jan 12, 2017 •
edited

changing the column from smallint to int(11) fixed the problem.
ALTER TABLE piwik.piwik_log_visit MODIFY COLUMN visit_total_interactions int(11) unsigned DEFAULT 0 NULL;

@mattab
Copy link
Member

mattab commented Feb 18, 2017

Thanks for report. will be fixed in Piwik 4 in #11086

@mattab mattab closed this as completed Feb 18, 2017
@mattab mattab added answered For when a question was asked and we referred to forum or answered it. duplicate For issues that already existed in our issue tracker and were reported previously. and removed answered For when a question was asked and we referred to forum or answered it. labels Feb 18, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
duplicate For issues that already existed in our issue tracker and were reported previously.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@obi12341 @mattab