got the following error after updating. Grateful for any assistance.
/piwik/core/Plugin/Controller.php(688): Notice - Undefined index: enable_measure_piwik_usage_in_idsite - Piwik 2.14.0
got the following error after updating. Grateful for any assistance.
/piwik/core/Plugin/Controller.php(688): Notice - Undefined index: enable_measure_piwik_usage_in_idsite - Piwik 2.14.0
Hi there,
please reupload all your Piwik files as it looks some files were not uploaded properly
thanks Matt. I’ll have a crack and let you know what happens
for the record, this occurred after an automatic update.
Same problem here. After an auto update, I get a core error and 500 server error.
Same here: auto upgrade resulted in a blank screen and now i cannot login anymore. It keeps sending me back to the login screen
Hi guys
What is the error in your server error log file?
Error log below…
/home1/milesand/public_html/milesanderson.com/piwik/error_log:
[06-Nov-2015 12:23:05 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-06 11:53:05’ AND visit_last_action_time <= ‘2015-11-06 12:53:05’ AND idsite = ‘2’ AND idvisitor = ‘T�{�U’ ORDER BY visit_last_action_time DESC LIMIT 1
[06-Nov-2015 12:23:26 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-06 11:53:26’ AND visit_last_action_time <= ‘2015-11-06 12:53:26’ AND idsite = ‘2’ AND idvisitor = ‘T�{�U’ ORDER BY visit_last_action_time DESC LIMIT 1
[06-Nov-2015 12:23:46 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-06 11:53:46’ AND visit_last_action_time <= ‘2015-11-06 12:53:46’ AND idsite = ‘2’ AND idvisitor = ‘T�{�U’ ORDER BY visit_last_action_time DESC LIMIT 1
[06-Nov-2015 12:24:02 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-06 11:54:02’ AND visit_last_action_time <= ‘2015-11-06 12:54:02’ AND idsite = ‘2’ AND idvisitor = ‘T�{�U’ ORDER BY visit_last_action_time DESC LIMIT 1
[06-Nov-2015 12:24:12 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-06 11:54:12’ AND visit_last_action_time <= ‘2015-11-06 12:54:12’ AND idsite = ‘2’ AND idvisitor = ‘T�{�U’ ORDER BY visit_last_action_time DESC LIMIT 1
[06-Nov-2015 12:24:15 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-06 11:54:15’ AND visit_last_action_time <= ‘2015-11-06 12:54:15’ AND idsite = ‘2’ AND idvisitor = ‘T�{�U’ ORDER BY visit_last_action_time DESC LIMIT 1
[06-Nov-2015 12:24:29 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-06 11:54:28’ AND visit_last_action_time <= ‘2015-11-06 12:54:28’ AND idsite = ‘2’ AND idvisitor = ‘T�{�U’ ORDER BY visit_last_action_time DESC LIMIT 1
[06-Nov-2015 12:24:33 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-06 11:54:33’ AND visit_last_action_time <= ‘2015-11-06 12:54:33’ AND idsite = ‘2’ AND idvisitor = ‘T�{�U’ ORDER BY visit_last_action_time DESC LIMIT 1
[06-Nov-2015 12:24:39 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-06 11:54:39’ AND visit_last_action_time <= ‘2015-11-06 12:54:39’ AND idsite = ‘2’ AND idvisitor = ‘T�{�U’ ORDER BY visit_last_action_time DESC LIMIT 1
[06-Nov-2015 12:24:54 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-06 11:54:53’ AND visit_last_action_time <= ‘2015-11-06 12:54:53’ AND idsite = ‘2’ AND idvisitor = ‘T�{�U’ ORDER BY visit_last_action_time DESC LIMIT 1
[06-Nov-2015 12:24:57 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-06 11:54:57’ AND visit_last_action_time <= ‘2015-11-06 12:54:57’ AND idsite = ‘2’ AND idvisitor = ‘T�{�U’ ORDER BY visit_last_action_time DESC LIMIT 1
[06-Nov-2015 12:25:01 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-06 11:55:01’ AND visit_last_action_time <= ‘2015-11-06 12:55:01’ AND idsite = ‘2’ AND idvisitor = ‘T�{�U’ ORDER BY visit_last_action_time DESC LIMIT 1
[06-Nov-2015 12:25:05 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-06 11:55:05’ AND visit_last_action_time <= ‘2015-11-06 12:55:05’ AND idsite = ‘2’ AND idvisitor = ‘T�{�U’ ORDER BY visit_last_action_time DESC LIMIT 1
[06-Nov-2015 13:26:23 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-06 12:56:23’ AND visit_last_action_time <= ‘2015-11-06 13:56:23’ AND idsite = ‘1’ AND idvisitor = ‘��XCR̒’ ORDER BY visit_last_action_time DESC LIMIT 1
[06-Nov-2015 15:16:37 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-06 14:46:37’ AND visit_last_action_time <= ‘2015-11-06 15:46:37’ AND idsite = ‘2’ AND idvisitor = ‘T�{�U’ ORDER BY visit_last_action_time DESC LIMIT 1
[06-Nov-2015 20:22:46 UTC] Error in Piwik (tracker): Error query: fetchAll() failed: Unknown column ‘superuser_access’ in ‘where clause’ : SELECT login, email, token_auth FROM piwik_user WHERE superuser_access = 1 ORDER BY date_registered ASC
[06-Nov-2015 22:54:03 UTC] Error in Piwik (tracker): Error query: fetchAll() failed: Unknown column ‘superuser_access’ in ‘where clause’ : SELECT login, email, token_auth FROM piwik_user WHERE superuser_access = 1 ORDER BY date_registered ASC
[07-Nov-2015 00:55:49 UTC] Error in Piwik (tracker): Error query: fetchAll() failed: Unknown column ‘superuser_access’ in ‘where clause’ : SELECT login, email, token_auth FROM piwik_user WHERE superuser_access = 1 ORDER BY date_registered ASC
[07-Nov-2015 00:57:49 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-07 00:27:48’ AND visit_last_action_time <= ‘2015-11-07 01:27:48’ AND idsite = ‘2’ AND idvisitor = ‘T�{�U’ ORDER BY visit_last_action_time DESC LIMIT 1
[07-Nov-2015 01:35:53 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-07 01:05:53’ AND visit_last_action_time <= ‘2015-11-07 02:05:53’ AND idsite = ‘2’ AND idvisitor = ‘T�{�U’ ORDER BY visit_last_action_time DESC LIMIT 1
[07-Nov-2015 01:38:33 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-07 01:08:33’ AND visit_last_action_time <= ‘2015-11-07 02:08:33’ AND idsite = ‘2’ AND idvisitor = ‘T�{�U’ ORDER BY visit_last_action_time DESC LIMIT 1
[07-Nov-2015 14:22:35 UTC] Error in Piwik (tracker): Error query: fetchAll() failed: Unknown column ‘superuser_access’ in ‘where clause’ : SELECT login, email, token_auth FROM piwik_user WHERE superuser_access = 1 ORDER BY date_registered ASC
[07-Nov-2015 15:51:41 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-07 15:21:41’ AND visit_last_action_time <= ‘2015-11-07 16:21:41’ AND idsite = ‘1’ AND idvisitor = ‘߮�تQu’ ORDER BY visit_last_action_time DESC LIMIT 1
[07-Nov-2015 16:16:01 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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_events, visit_total_time, visit_total_actions, visit_total_searches , 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 piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-07 15:46:01’ AND visit_last_action_time <= ‘2015-11-07 16:46:01’ AND idsite = ‘1’ AND idvisitor = '߮�تQu’ ORDER BY visit_last_action_time DESC LIMIT 1
[07-Nov-2015 17:40:52 UTC] PHP Notice: Undefined property: Piwik\Tracker\GoalManager::$requestIsEcommerce in /home1/milesand/public_html/milesanderson.com/piwik/plugins/CoreHome/Columns/VisitGoalBuyer.php on line 113
[07-Nov-2015 17:40:52 UTC] Error in Piwik (tracker): Error query: fetchAll() failed: Unknown column ‘superuser_access’ in ‘where clause’ : SELECT login, email, token_auth FROM piwik_user WHERE superuser_access = 1 ORDER BY date_registered ASC
[07-Nov-2015 17:43:35 UTC] Error in Piwik (tracker): Error while resolving tracker.request.processors[2]. No entry or class found for ‘Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor’
[07-Nov-2015 17:47:52 UTC] PHP Notice: Undefined index: exclude_unknown_urls in /home1/milesand/public_html/milesanderson.com/piwik/plugins/SitesManager/SitesManager.php on line 121
[07-Nov-2015 17:47:52 UTC] Error in Piwik (tracker): Error query: fetch() failed: Unknown column ‘user_id’ in ‘field list’ : 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, visit_total_actions, visit_total_searches, visit_total_events, visit_total_time, 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 FROM piwik_log_visit WHERE visit_last_action_time >= ‘2015-11-07 17:17:52’ AND visit_last_action_time <= ‘2015-11-07 18:17:52’ AND idsite = ‘1’ AND idvisitor = ‘&�~-��!�’ ORDER BY visit_last_action_time DESC LIMIT 1
[07-Nov-2015 17:48:15 UTC] PHP Fatal error: Class ‘Piwik_Plugin’ not found in /home1/milesand/public_html/milesanderson.com/piwik/plugins/DoNotTrack/DoNotTrack.php on line 20
Today, downloaded the new version and uploaded all files to the PIWIK directory on my server. After this, nothing changed. Same error page.
Here is the FAQ that should help you: After the update, I get sql errors, I would like to try the update again. How do I force Piwik to re-upgrade the database from a past version? - Analytics Platform - Matomo
it looks like your problem is that some DB upgrades were not done as expected, at least as far back as ‘2.0.3’ release.