I’m running Piwik 3.0.1 (upgraded to 3.0.2 today) and just realized that my upgrade to MySQL 5.7 a couple of days ago started to prevent Piwik from logging visits. The errors are like this:
[Thu Mar 02 09:08:05.913094 2017] [:error] [pid 6312] [client 46.223.59.40:51104] Error in Piwik (tracker): Error query: SQLSTATE[HY000]: General error: 1364 Field 'location_browser_lang' doesn't have a default value In query: INSERT INTO piwik_log_visit (idvisitor, config_id, location_ip, idsite, visit_first_action_time, visit_goal_buyer, visit_goal_converted, visit_last_action_time, visitor_days_since_first, visitor_days_since_order, visitor_returning, visitor_count_visits, visit_entry_idaction_name, visit_entry_idaction_url, visit_exit_idaction_name, visit_exit_idaction_url, visit_total_actions, visit_total_interactions, visit_total_searches, referer_keyword, referer_name, referer_type, referer_url, config_browser_engine, config_browser_name, config_browser_version, config_device_brand, config_device_model, config_device_type, config_os, config_os_version, visit_total_events, visitor_localtime, visitor_days_since_last, config_resolution, config_cookie, config_director, config_flash, config_gears, config_java, config_pdf, config_quicktime, config_realplayer, config_silverlight, config_windowsmedia, visit_total_time, location_country, location_provider) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => 'X\xa7i\x17\xcf\x04\x8a"', 1 => '\x14?\x1fA\xfd\x890#', 2 => '.\xdf;(', 3 => 1, 4 => '2017-03-02 08:08:05', 5 => 0, 6 => 0, 7 => '2017-03-02 08:08:05', 8 => '7', 9 => 0, 10 => 1, 11 => 5, 12 => 8988, 13 => 192, 14 => 8988, 15 => 192, 16 => 1, 17 => 1, 18 => 0, 19 => NULL, 20 => NULL, 21 => 1, 22 => 'https://www.paragon-es.de/contact', 23 => 'WebKit', 24 => 'SF', 25 => '10.0', 26 => '', 27 => '', 28 => 0, 29 => 'MAC', 30 => '10.12', 31 => 0, 32 => '09:08:05', 33 => '0', 34 => '2560x1440', 35 => 1, 36 => 0, 37 => 0, 38 => 0, 39 => 1, 40 => 1, 41 => 0, 42 => 0, 43 => 0, 44 => 0, 45 => 0, 46 => 'de', 47 => 'kabel-badenwuerttemberg.de', ), referer: https://www.paragon-es.de/imprint
I saw a few old issues about that topic and all are closed and state that the bugs are fixed. So I wonder why they are still present here. Has Piwik missed a db upgrade at one point here? If so, what can I do to fix this?