2 Issues after 1.9 AUTO Update

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?

SOLUTION-

1- Took the root folder piwik is in and put a ~ after it.
2- Copied the Config folder to my desktop
3- Loaded the 1.9 version in the analytics folder
4- copied the config folder into the new analytics folder
5- ran the install but KEPT the old tables/data

Works GREAT now!

Doesn’t work for me, i’ve tried this solution many times.

If you see this error, it means the update script was not executed properly.

Run this SQL query to force piwik to re-run the update:

UPDATE piwik_option SET value=‘1.8.4’ WHERE name=‘version_core’