Error 1:
On the dashboard under "Visits Overview (With Graph):
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_visit.location_continent’ in ‘field list’
Go to Piwik
Login
Backtrace:
Error 2: Under “Visitors in Real-time”
There is an error. Please report the message (Piwik 1.9) and full backtrace in the Piwik forums (please do a Search first as it might have been reported already!).
Notice: Undefined index: location_continent in /var/www/vhosts/sbsbattery.com/httpdocs/analytics/plugins/Live/Visitor.php on line 217
Backtrace -->
#0 Piwik_ErrorHandler(…) called at [/var/www/vhosts/sbsbattery.com/httpdocs/analytics/plugins/Live/Visitor.php:217]
#1 Piwik_Live_Visitor->getContinent(…) called at [/var/www/vhosts/sbsbattery.com/httpdocs/analytics/plugins/Live/Visitor.php:76]
#2 Piwik_Live_Visitor->getAllVisitorDetails(…) called at [/var/www/vhosts/sbsbattery.com/httpdocs/analytics/plugins/Live/API.php:163]
#3 Piwik_Live_API->getCleanedVisitorsFromDetails(…) called at [/var/www/vhosts/sbsbattery.com/httpdocs/analytics/plugins/Live/API.php:132]
#4 Piwik_Live_API->getLastVisitsDetails(…) called at [:]
#5 call_user_func_array(…) called at [/var/www/vhosts/sbsbattery.com/httpdocs/analytics/core/API/Proxy.php:190]
#6 Piwik_API_Proxy->call(…) called at [/var/www/vhosts/sbsbattery.com/httpdocs/analytics/core/API/Request.php:128]
#7 Piwik_API_Request->process(…) called at [/var/www/vhosts/sbsbattery.com/httpdocs/analytics/plugins/Live/Controller.php:96]
#8 Piwik_Live_Controller->getLastVisitsStart(…) called at [/var/www/vhosts/sbsbattery.com/httpdocs/analytics/plugins/Live/Controller.php:29]
#9 Piwik_Live_Controller->widget(…) called at [:]
#10 call_user_func_array(…) called at [/var/www/vhosts/sbsbattery.com/httpdocs/analytics/core/FrontController.php:138]
#11 Piwik_FrontController->dispatch(…) called at [/var/www/vhosts/sbsbattery.com/httpdocs/analytics/index.php:53]
How do we fix this issue?