Nope, happened to me as well. Using TYPO3 piwikintegration extension, but same error:
Error query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘location_browser_lang’ in ‘field list’
In query: SELECT visit_last_action_time, visit_first_action_time, idvisitor, idvisit, user_id, visit_exit_idaction_url, visit_exit_idaction_name, visitor_returning, visitor_days_since_first, visitor_days_since_order, visitor_count_visits, visit_goal_buyer, location_country, location_region, location_city, location_latitude, location_longitude, referer_name, referer_keyword, referer_type, location_ip, location_browser_lang, visit_total_time, visit_total_searches, visit_total_actions , 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 FROM user_piwikintegration_log_visit WHERE visit_last_action_time >= ? AND visit_last_action_time <= ? AND idsite = ? AND idvisitor = ? ORDER BY visit_last_action_time DESC LIMIT 1 Parameters: array ( 0 => ‘2015-06-09 09:30:04’, 1 => ‘2015-06-09 10:30:04’, 2 => 1, 3 => ‘˲% Ak’, )
When I checked the table user_piwikintegration_log_visit, I could see that there was already a column exactly as Matt described - varchar(20) and not null.
Without this functioning, I have no stats at all
Any input is appreciated!
-Scott.
UPDATE: I activated UserLanguage and the new error is:
Error in Piwik (tracker): Error query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘config_device_brand’ in ‘field list’ In query: INSERT INTO user_piwikintegration_log_visit (idvisitor, config_id, location_ip, config_device_brand, config_device_model, config_device_type, config_os, config_browser_version, config_browser_name, location_browser_lang, config_browser_engine, config_os_version, visitor_localtime, visitor_days_since_last, location_provider, location_country, referer_url, referer_type, visit_total_time, visitor_days_since_first, visitor_days_since_order, visitor_returning, visit_last_action_time, visit_goal_converted, visit_first_action_time, visit_goal_buyer, visitor_count_visits, visit_entry_idaction_name, referer_keyword, referer_name, visit_total_searches, visit_total_actions, visit_entry_idaction_url, visit_exit_idaction_name, visit_exit_idaction_url, idsite) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => ‘˲% Ak’, 1 => ‘X▒▒G▒▒’, 2 => ‘E
’ . “\0” . ‘’ . “\0” . ‘’, 3 => ‘’, 4 => ‘’, 5 => 0, 6 => ‘WIN’, 7 => ‘43.0’, 8 => ‘CH’, 9 => ‘en-us’, 10 => ‘Blink’, 11 => ‘8.1’, 12 => ‘04:18:25’, 13 => ‘0’, 14 => ‘sk.ca’, 15 => ‘us’, 16 => ‘http://mydomain.ca/index.php?id=930’, 17 => 1, 18 => 0, 19 => ‘0’, 20 => 0, 21 => 0, 22 => ‘2015-06-09 10:18:59’, 23 => 0, 24 => ‘2015-06-09 10:18:59’, 25 => 0, 26 => 1, 27 => 15, 28 => ‘’, 29 => ‘’, 30 => 0, 31 => 1, 32 => 2, 33 => 15, 34 => 2, 35 => 1, )
… The only “config” column I have is “config_id” - I don’t have
config_device_brand, config_device_model, config_device_type, config_os, config_browser_version, config_browser_name, config_browser_engine, config_os_version,
UPDATE2: config_*** is tied to DeviceDetection plugin -> disable it and you’re golden