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

Device Detection Bug #5342

Closed
anonymous-matomo-user opened this issue Jun 12, 2014 · 3 comments
Closed

Device Detection Bug #5342

anonymous-matomo-user opened this issue Jun 12, 2014 · 3 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. duplicate For issues that already existed in our issue tracker and were reported previously. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Milestone

Comments

@anonymous-matomo-user
Copy link

I was asked to open a ticket for post http://forum.piwik.org/read.php?2,116626.

Does Device Detection only work if you have bots turned off? The progam produces an error when it tries to process a bot from the log files. I get the following error:
<pre>DEBUG Piwik\Common18:28:11 [Exception: Error query: SQLSTATEHY000: General error: 1366 Incorrect integer value: '' for column 'config_device_type' at row 1</pre>
<pre>DEBUG Piwik\Common18:28:11 [367b7] In query: INSERT INTO xx_log_visit (idsite, visitor_localtime, idvisitor, visitor_returning, visitor_count_visits, visitor_days_since_last, visitor_days_since_order, visitor_days_since_first, visit_first_action_time, visit_last_action_time, visit_entry_idaction_url, visit_entry_idaction_name, visit_exit_idaction_url, visit_exit_idaction_name, visit_total_actions, visit_total_searches, visit_total_events, visit_total_time, visit_goal_buyer, referer_type, referer_name, referer_url, referer_keyword, config_id, config_os, config_browser_name, config_browser_version, config_resolution, config_pdf, config_flash, config_java, config_director, config_quicktime, config_realplayer, config_windowsmedia, config_gears, config_silverlight, config_cookie, location_ip, location_browser_lang, custom_var_k1, custom_var_v1, custom_var_k2, custom_var_v2, custom_var_k3, custom_var_v3, custom_var_k4, custom_var_v4, custom_var_k5, custom_var_v5, visit_goal_converted, location_country, location_region, location_city, location_latitude, location_longitude, config_os_version, config_device_type, config_device_model, config_device_brand) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)</pre>
<pre>DEBUG Piwik\Common18:28:11 [367b7] Parameters: array (</pre>

@sgiehl
Copy link
Member

sgiehl commented Jun 12, 2014

Which version of Piwik are you using?

@anonymous-matomo-user
Copy link
Author

I'm using 2.3.0, but I also got the error in 2.2.0.

@mattab
Copy link
Member

mattab commented Aug 3, 2014

this was fixed in git master

@mattab mattab closed this as completed Aug 3, 2014
@mattab mattab added this to the Piwik 2.5.0 milestone Aug 3, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc. duplicate For issues that already existed in our issue tracker and were reported previously. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Projects
None yet
Development

No branches or pull requests

3 participants