Fehler nach Update von 1.0 auf 1.6


#1

Hallo Leute, ich hab grad das im Dashboard angebotene Update durchgeführt, urde auch alles sauber abgearbeitet, aber
Besucher in Echtzeit bringt folgenden Fehler:
Notice: Undefined index: visit_goal_buyer in /var/www/web131/html/analyse/plugins/Live/Visitor.php on line 425

Backtrace -->
#0 Piwik_ErrorHandler(…) called at [/var/www/web131/html/analyse/plugins/Live/Visitor.php:425]#1 Piwik_Live_Visitor->getVisitEcommerceStatus(…) called at [/var/www/web131/html/analyse/plugins/Live/Visitor.php:49]#2 Piwik_Live_Visitor->getAllVisitorDetails(…) called at [/var/www/web131/html/analyse/plugins/Live/API.php:154]#3 Piwik_Live_API->getCleanedVisitorsFromDetails(…) called at [/var/www/web131/html/analyse/plugins/Live/API.php:127]#4 Piwik_Live_API->getLastVisitsDetails(…) called at [:]#5 call_user_func_array(…) called at [/var/www/web131/html/analyse/core/API/Proxy.php:179]#6 Piwik_API_Proxy->call(…) called at [/var/www/web131/html/analyse/core/API/Request.php:121]#7 Piwik_API_Request->process(…) called at [/var/www/web131/html/analyse/plugins/Live/Controller.php:100]#8 Piwik_Live_Controller->getLastVisitsStart(…) called at [/var/www/web131/html/analyse/plugins/Live/Controller.php:30]#9 Piwik_Live_Controller->widget(…) called at [:]#10 call_user_func_array(…) called at [/var/www/web131/html/analyse/core/FrontController.php:132]#11 Piwik_FrontController->dispatch(…) called at [/var/www/web131/html/analyse/index.php:53]

Besuchslänge bringt:
Backtrace:

#0 /var/www/web131/html/analyse/core/ViewDataTable/Cloud.php(70): Piwik_ViewDataTable->checkStandardDataTable()
#1 /var/www/web131/html/analyse/core/Controller.php(146): Piwik_ViewDataTable_Cloud->main()
#2 /var/www/web131/html/analyse/plugins/VisitorInterest/Controller.php(40): Piwik_Controller->renderView(Object(Piwik_ViewDataTable_Cloud), false)
#3 /var/www/web131/html/analyse/core/FrontController.php(132): Piwik_VisitorInterest_Controller->getNumberOfVisitsPerVisitDuration()
#4 /var/www/web131/html/analyse/index.php(53): Piwik_FrontController->dispatch(Array, Array)
#5 {main}

Besuche nach Serverzeit bringt
Backtrace:

#0 /var/www/web131/html/analyse/libs/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare(’???SELECT???..’)
#1 /var/www/web131/html/analyse/libs/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Piwik_Db_Adapter_Mysqli), ‘???SELECT???..’)
#2 /var/www/web131/html/analyse/libs/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare(’???SELECT???..’)
#3 /var/www/web131/html/analyse/libs/Zend/Db/Adapter/Abstract.php(755): Zend_Db_Adapter_Abstract->query(’???SELECT???..’, Array)
#4 /var/www/web131/html/analyse/core/ArchiveProcessing/Day.php(98): Zend_Db_Adapter_Abstract->fetchRow(’???SELECT???..’, Array)
#5 /var/www/web131/html/analyse/core/Archive/Single.php(236): Piwik_ArchiveProcessing_Day->isThereSomeVisits()
#6 /var/www/web131/html/analyse/core/Archive/Single.php(253): Piwik_Archive_Single->prepareArchive()
#7 /var/www/web131/html/analyse/core/Archive/Single.php(499): Piwik_Archive_Single->get(‘VisitTime_serve…’, ‘blob’)
#8 /var/www/web131/html/analyse/plugins/VisitTime/API.php(34): Piwik_Archive_Single->getDataTable(‘VisitTime_serve…’)
#9 /var/www/web131/html/analyse/plugins/VisitTime/API.php(48): Piwik_VisitTime_API->getDataTable(‘VisitTime_serve…’, ‘1’, ‘day’, ‘yesterday’, false)
#10 /var/www/web131/html/analyse/core/API/Proxy.php(179): Piwik_VisitTime_API->getVisitInformationPerServerTime(‘1’, ‘day’, ‘yesterday’, false, ‘1’)
#11 /var/www/web131/html/analyse/core/API/Request.php(121): Piwik_API_Proxy->call(Array, Array)
#12 /var/www/web131/html/analyse/core/ViewDataTable.php(391): Piwik_API_Request->process(‘Piwik_VisitTime…’, ‘getVisitInforma…’, Array)
#13 /var/www/web131/html/analyse/core/ViewDataTable/GenerateGraphData.php(98): Piwik_ViewDataTable->loadDataTableFromAPI()
#14 /var/www/web131/html/analyse/core/Controller.php(146): Piwik_ViewDataTable_GenerateGraphData->main()
#15 /var/www/web131/html/analyse/plugins/VisitTime/Controller.php(42): Piwik_Controller->renderView()
#16 /var/www/web131/html/analyse/core/FrontController.php(132): Piwik_VisitTime_Controller->getVisitInformationPerServerTime(Object(Piwik_ViewDataTable_GenerateGraphData_ChartVerticalBar), false)
#17 /var/www/web131/html/analyse/core/FrontController.php(153): Piwik_FrontController->dispatch()
#18 /var/www/web131/html/analyse/core/ViewDataTable/GenerateGraphHTML.php(148): Piwik_FrontController->fetchDispatch(Array, Array)
#19 /var/www/web131/html/analyse/core/ViewDataTable/GenerateGraphHTML.php(108): Piwik_ViewDataTable_GenerateGraphHTML->getGraphData(‘VisitTime’, ‘getVisitInforma…’, Array)
#20 /var/www/web131/html/analyse/core/ViewDataTable/GenerateGraphHTML.php(92): Piwik_ViewDataTable_GenerateGraphHTML->buildView(‘VisitTime’, ‘getVisitInforma…’, Array)
#21 /var/www/web131/html/analyse/core/Controller.php(146): Piwik_ViewDataTable_GenerateGraphHTML->main()
#22 /var/www/web131/html/analyse/plugins/VisitTime/Controller.php(42): Piwik_Controller->renderView()
#23 /var/www/web131/html/analyse/core/FrontController.php(132): Piwik_VisitTime_Controller->getVisitInformationPerServerTime()
#24 /var/www/web131/html/analyse/index.php(53): Piwik_FrontController->dispatch(Object(Piwik_ViewDataTable_GenerateGraphHTML_ChartVerticalBar), false)
#25 {main}

Was kann ich tun??


(Peterbo) #2

Scheinbar ist beim Db-Upgrade etwas schief gelaufen.

Lösungsansätze:

  1. Dateien der neusten Version komplett neu hochladen und probieren

UPDATE `piwik_option` SET option_value = "1.0" WHERE option_name = "version_core";

auf der DB ausführen und Datenbank-Update wiederholen. Evtl. gab es bei einem bestimmten Schritt Probleme. Das DB-Update sollte im besten Fall über die Shell ausgeführt werden, da von 1.0 bis 1.6 einige Änderungen am Schema erfolgten und damit viel gerechnet werden muss (Stichwort execution_time).

~Peter