Device Detection


#1

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:

DEBUG Piwik\Common[2014-06-09 18:28:11] [367b7] Exception: Error query: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'config_device_type' at row 1
DEBUG Piwik\Common[2014-06-09 18: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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
DEBUG Piwik\Common[2014-06-09 18:28:11] [367b7] 								Parameters: array (

(Matthieu Aubry) #2

Thanks, that’s a bug! Could you please create ticket in: http://dev.piwik.org/

By any chance, do you know the User-Agent that triggered this error?