No default value on a field


#1

Hi All

I came across a whole swarm of these errors on our error logs. This started only after I upgraded to the latest Piwik version.
I’m guessing an alter table command should help this. What’s the default for the config_resolution in the piwik_log_visit table?

[Mon Oct 26 12:26:32 2015] [warn] [client 10.100.42.1] mod_fcgid: stderr: Error in Piwik (tracker): Error query: SQLSTATE[HY000]: General error: 1364 Field ‘config_resolution’ doesn’t have a default value In query: INSERT INTO piwik_log_visit (idvisitor, config_id, location_ip, custom_var_k1, custom_var_v1, custom_var_k2, custom_var_v2, config_device_model, config_device_type, config_os, config_os_version, config_device_brand, config_browser_version, config_browser_engine, config_browser_name, visit_total_events, 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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)


(Matthieu Aubry) #2

Hello Reuben

Can you please post all the unique error messages in a new issue @ Issues · matomo-org/piwik · GitHub

We will investigate the proper fix and let you know there on github