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

SQL errors: Incorrect integer value: 'undefined' for column 'time_since_load' #13097

Closed
tchwpkgorg opened this issue Jun 24, 2018 · 2 comments
Closed

SQL errors: Incorrect integer value: 'undefined' for column 'time_since_load' #13097

tchwpkgorg opened this issue Jun 24, 2018 · 2 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org.
Milestone
3.8.0

Comments

@tchwpkgorg
Copy link

tchwpkgorg commented Jun 24, 2018 •
edited

I'm getting hundreds of Error query: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'undefined' for column 'time_since_load' with Matomo 3.5.1 running on Ubuntu 18.04 (PHP 7.2.5, Apache 2.4.29, MySQL server 5.7.22):

[Sat Jun 23 20:21:50.360091 2018] [proxy_fcgi:error] [pid 5247:tid 139715835094784] [client 157.37.120.61:14819] AH01071: Got error 'PHP message: Error in Matomo (tracker): Error query: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'undefined' for column 'time_since_load' at row 1 In query: INSERT INTO matomo_log_hsr_event (idloghsr,time_since_load,event_type,idselector,x,y,idhsrblob) VALUES(?,?,?,?,?,?,?) Parameters: array ( 0 => '35978', 1 => 'undefined', 2 => 12, 3 => '15986', 4 => '0', 5 => '540', 6 => NULL, )\n', referer: https://enbraun.example.com/v2/index.php?page=edit_time

[Sat Jun 23 20:21:54.786001 2018] [proxy_fcgi:error] [pid 5247:tid 139715843487488] [client 157.37.120.61:14817] AH01071: Got error 'PHP message: Error in Matomo (tracker): Error query: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'undefined' for column 'time_since_load' at row 1 In query: INSERT INTO matomo_log_hsr_event (idloghsr,time_since_load,event_type,idselector,x,y,idhsrblob) VALUES(?,?,?,?,?,?,?) Parameters: array ( 0 => '35978', 1 => 'undefined', 2 => 12, 3 => '15986', 4 => '0', 5 => '499', 6 => NULL, )\n', referer: https://enbraun.example.com/v2/index.php?page=edit_time

[Sat Jun 23 20:21:55.585545 2018] [proxy_fcgi:error] [pid 5247:tid 139715843487488] [client 157.37.120.61:14821] AH01071: Got error 'PHP message: Error in Matomo (tracker): Error query: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'undefined' for column 'time_since_load' at row 1 In query: INSERT INTO matomo_log_hsr_event (idloghsr,time_since_load,event_type,idselector,x,y,idhsrblob) VALUES(?,?,?,?,?,?,?) Parameters: array ( 0 => '35978', 1 => 'undefined', 2 => 12, 3 => '15986', 4 => '0', 5 => '499', 6 => NULL, )\n', referer: https://enbraun.example.com/v2/index.php?page=edit_time

[Sat Jun 23 22:11:31.793884 2018] [proxy_fcgi:error] [pid 5312:tid 139715784689408] [client 185.17.127.226:55867] AH01071: Got error 'PHP message: Error in Matomo (tracker): Error query: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'undefined' for column 'time_since_load' at row 1 In query: INSERT INTO matomo_log_hsr_event (idloghsr,time_since_load,event_type,idselector,x,y,idhsrblob) VALUES(?,?,?,?,?,?,?) Parameters: array ( 0 => '35999', 1 => 'undefined', 2 => 12, 3 => '17346', 4 => '0', 5 => '6', 6 => NULL, )\n', referer: https://timereports.example.com/v2/index.php?page=projects_report

[Sat Jun 23 22:11:31.865527 2018] [proxy_fcgi:error] [pid 5247:tid 139715809892096] [client 185.17.127.226:55330] AH01071: Got error 'PHP message: Error in Matomo (tracker): Error query: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'undefined' for column 'time_since_load' at row 1 In query: INSERT INTO matomo_log_hsr_event (idloghsr,time_since_load,event_type,idselector,x,y,idhsrblob) VALUES(?,?,?,?,?,?,?) Parameters: array ( 0 => '35999', 1 => 'undefined', 2 => 12, 3 => '17346', 4 => '0', 5 => '6', 6 => NULL, )\n', referer: https://timereports.example.com/v2/index.php?page=projects_report

[Sat Jun 23 22:11:33.190518 2018] [proxy_fcgi:error] [pid 5312:tid 139715784689408] [client 185.17.127.226:55867] AH01071: Got error 'PHP message: Error in Matomo (tracker): Error query: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'undefined' for column 'time_since_load' at row 1 In query: INSERT INTO matomo_log_hsr_event (idloghsr,time_since_load,event_type,idselector,x,y,idhsrblob) VALUES(?,?,?,?,?,?,?) Parameters: array ( 0 => '35999', 1 => 'undefined', 2 => 12, 3 => '17346', 4 => '0', 5 => '36', 6 => NULL, )\n', referer: https://timereports.example.com/v2/index.php?page=projects_report

[Sat Jun 23 22:11:33.252043 2018] [proxy_fcgi:error] [pid 5247:tid 139715809892096] [client 185.17.127.226:55330] AH01071: Got error 'PHP message: Error in Matomo (tracker): Error query: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'undefined' for column 'time_since_load' at row 1 In query: INSERT INTO matomo_log_hsr_event (idloghsr,time_since_load,event_type,idselector,x,y,idhsrblob) VALUES(?,?,?,?,?,?,?) Parameters: array ( 0 => '35999', 1 => 'undefined', 2 => 12, 3 => '17346', 4 => '0', 5 => '36', 6 => NULL, )\n', referer: https://timereports.example.com/v2/index.php?page=projects_report
@sgiehl sgiehl added the not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org. label Jun 24, 2018
@sgiehl
Copy link
Member

sgiehl commented Jun 24, 2018

this is related to #13098

@mattab mattab changed the title hundreds of Error query: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'undefined' for column 'time_since_load' SQL errors: Incorrect integer value: 'undefined' for column 'time_since_load' + Out of range value for column 'time_on_page' Oct 3, 2018
@mattab mattab added Bug For errors / faults / flaws / inconsistencies etc. and removed not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org. labels Oct 3, 2018
@mattab mattab added this to the 3.7.0 milestone Oct 3, 2018
@mattab mattab changed the title SQL errors: Incorrect integer value: 'undefined' for column 'time_since_load' + Out of range value for column 'time_on_page' SQL errors: Incorrect integer value: 'undefined' for column 'time_since_load' Oct 3, 2018
@mattab mattab added the not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org. label Oct 3, 2018
@tsteur
Copy link
Member

tsteur commented Oct 4, 2018

@mattab I think we can close this issue? We have internally an issue for that. We're still waiting for exact steps and browser info to reproduce this

@mattab mattab closed this as completed Oct 4, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug For errors / faults / flaws / inconsistencies etc. not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org.
Projects
None yet
Milestone
3.8.0
Development

No branches or pull requests
4 participants
@tsteur @mattab @tchwpkgorg @sgiehl