Error after update


#1

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


(Matthieu Aubry) #2

Hi there,

please reupload all your Piwik files as it looks some files were not uploaded properly


#3

thanks Matt. I’ll have a crack and let you know what happens


#4

for the record, this occurred after an automatic update.


#5

Same problem here. After an auto update, I get a core error and 500 server error.


#6

Same here: auto upgrade resulted in a blank screen and now i cannot login anymore. It keeps sending me back to the login screen :confused:


(Matthieu Aubry) #7

Hi guys
What is the error in your server error log file?


#8

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


#9

Today, downloaded the new version and uploaded all files to the PIWIK directory on my server. After this, nothing changed. Same error page.


(Matthieu Aubry) #10

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.