Error in live visitor area after updating to 1.5


#1

Hi,

after updating from 1.4 to 1.5 and applying the patch to Session.php to get Piwik running, i see this error box in the live visitors widget:

There is an error. Please report the message and full backtrace in the Piwik forums (please do a Search first as it might have been reported already!).

Notice: Undefined index: visit_goal_buyer in /var/www/vhosts/clubbi.de/subdom/piwik/plugins/Live/Visitor.php on line 425

Backtrace -->
#0 Piwik_ErrorHandler(8, 1 => ‘Undefined index: visit_goal_buyer’, 2 => ‘/var/www/vhosts/clubbi.de/subdom/piwik/plugins/Live/Visitor.php’, 3 => 425, 4 => array ()) called at [/var/www/vhosts/clubbi.de/subdom/piwik/plugins/Live/Visitor.php:425]#1 Piwik_Live_Visitor->getVisitEcommerceStatus(array () called at [/var/www/vhosts/clubbi.de/subdom/piwik/plugins/Live/Visitor.php:49]#2 Piwik_Live_Visitor->getAllVisitorDetails(array () called at [/var/www/vhosts/clubbi.de/subdom/piwik/plugins/Live/API.php:157]#3 Piwik_Live_API->getCleanedVisitorsFromDetails(array (0 => array (‘idvisit’ => ‘19894’, ‘idsite’ => ‘6’, ‘idvisitor’ => ‘ÓhGT-’, ‘visitor_localtime’ => ‘13:35:54’, ‘visitor_returning’ => ‘0’, ‘visitor_count_visits’ => ‘1’, ‘visit_first_action_time’ => ‘2011-06-23 11:34:43’, ‘visit_last_action_time’ => ‘2011-06-23 11:34:43’, ‘visit_exit_idaction_url’ => ‘10493’, ‘visit_exit_idaction_name’ => ‘10492’, ‘visit_entry_idaction_url’ => ‘10493’, ‘visit_entry_idaction_name’ => ‘10492’, ‘visit_total_actions’ => ‘1’, ‘visit_total_time’ => ‘0’, ‘visit_goal_converted’ => ‘0’, ‘referer_type’ => ‘2’, ‘referer_name’ => ‘Google’, ‘referer_url’ => ‘abschalten von anonymen anrufen - Пошук Google’, ‘referer_keyword’ => ‘abschalten von anonymen anrufen’, ‘config_id’ => ‘£ÅœÿÎ{ºÒ’, ‘config_os’ => ‘IPH’, ‘config_browser_name’ => ‘SF’, ‘config_browser_version’ => ‘5.0’, ‘config_resolution’ => ‘320x480’, '…#4 Piwik_Live_API->getLastVisitsDetails(‘6’, 1 => ‘day’, 2 => ‘today’, 3 => false, 4 => ‘10’, 5 => false, 6 => false) called at [:]#5 call_user_func_array(array (0 => Piwik_Live_API::__set_state(array()), 1 => ‘getLastVisitsDetails’), 1 => array (0 => ‘6’, 1 => ‘day’, 2 => ‘today’, 3 => false, 4 => ‘10’, 5 => false, 6 => false)) called at [/var/www/vhosts/clubbi.de/subdom/piwik/core/API/Proxy.php:179]#6 Piwik_API_Proxy->call(‘Piwik_Live_API’, 1 => ‘getLastVisitsDetails’, 2 => array (‘method’ => ‘Live.getLastVisitsDetails’, ‘idSite’ => ‘6’, ‘filter_limit’ => ‘10’, ‘format’ => ‘php’, ‘serialize’ => ‘0’, ‘disable_generic_filters’ => ‘1’, ‘module’ => ‘Live’, ‘action’ => ‘widget’, ‘widget’ => ‘1’, ‘period’ => ‘day’, ‘date’ => ‘today’)) called at [/var/www/vhosts/clubbi.de/subdom/piwik/core/API/Request.php:121]#7 Piwik_API_Request->process(array () called at [/var/www/vhosts/clubbi.de/subdom/piwik/plugins/Live/Controller.php:100]#8 Piwik_Live_Controller->getLastVisitsStart(true) called at [/var/www/vhosts/clubbi.de/subdom/piwik/plugins/Live/Controller.php:30]#9 Piwik_Live_Controller->widget(array () called at [:]#10 call_user_func_array(array (0 => Piwik_Live_Controller::__set_state(array(‘pluginName’ => ‘Live’, ‘strDate’ => ‘2011-06-23’, ‘date’ => Piwik_Date::__set_state(array(‘timestamp’ => 1308838282, ‘timezone’ => ‘UTC’)), ‘idSite’ => 6, ‘site’ => Piwik_Site::__set_state(array(‘id’ => 6)))), 1 => ‘widget’), 1 => array ()) called at [/var/www/vhosts/clubbi.de/subdom/piwik/core/FrontController.php:127]#11 Piwik_FrontController->dispatch(array () called at [/var/www/vhosts/clubbi.de/subdom/piwik/index.php:53]


(vipsoft) #2

The visit_goal_buyer column should have been added by the core/Updates/1.5-b1.php script. Refer to that, and execute the SQL manually to update your database schema.