2 Issues after 1.9 AUTO Update

Support & Bugs
1

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?

2

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!

3

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

4

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’