After 1.8 auto update


#1

After updating from 1.7.1 to 1.8 using the automatic update i started getting all these errors. There was another pic but I can only do 3 pics at a time.
The errors are as follows…
I enabled Anonymous access for testing… http://itwontwork.net/piwik

Last visits graph:


SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: '' for column 'date1' at row 1

Go to Piwik
Login

Backtrace:
#0 C:\Server\piwik\core\ArchiveProcessing.php(691): Zend_Db_Adapter_Pdo_Abstract->exec('INSERT INTO piw...')
#1 C:\Server\piwik\core\ArchiveProcessing.php(533): Piwik_ArchiveProcessing->loadNextIdarchive()
#2 C:\Server\piwik\core\ArchiveProcessing.php(472): Piwik_ArchiveProcessing->initCompute()
#3 C:\Server\piwik\core\Archive\Single.php(226): Piwik_ArchiveProcessing->launchArchiving()
#4 C:\Server\piwik\core\Archive\Array\IndexedByDate.php(90): Piwik_Archive_Single->prepareArchive()
#5 C:\Server\piwik\plugins\VisitsSummary\API.php(88): Piwik_Archive_Array_IndexedByDate->getDataTableFromNumeric(Array)
#6 [internal function]: Piwik_VisitsSummary_API->get('3', 'day', '2012-05-03,2012...', false, 'nb_visits')
#7 C:\Server\piwik\core\API\Proxy.php(190): call_user_func_array(Array, Array)
#8 C:\Server\piwik\plugins\API\API.php(986): Piwik_API_Proxy->call('Piwik_VisitsSum...', 'get', Array)
#9 [internal function]: Piwik_API_API->get('3', 'day', '2012-05-03,2012...', false, 'nb_visits')
#10 C:\Server\piwik\core\API\Proxy.php(190): call_user_func_array(Array, Array)
#11 C:\Server\piwik\core\API\Request.php(128): Piwik_API_Proxy->call('Piwik_API_API', 'get', Array)
#12 C:\Server\piwik\core\ViewDataTable.php(421): Piwik_API_Request->process()
#13 C:\Server\piwik\core\ViewDataTable\GenerateGraphData\ChartEvolution.php(109): Piwik_ViewDataTable->loadDataTableFromAPI()
#14 C:\Server\piwik\core\ViewDataTable\GenerateGraphData.php(181): Piwik_ViewDataTable_GenerateGraphData_ChartEvolution->loadDataTableFromAPI()
#15 C:\Server\piwik\core\Controller.php(247): Piwik_ViewDataTable_GenerateGraphData->main()
#16 C:\Server\piwik\plugins\VisitsSummary\Controller.php(78): Piwik_Controller->getLastUnitGraphAcrossPlugins('VisitsSummary', 'getEvolutionGra...', Array, Array, 'This is an over...')
#17 [internal function]: Piwik_VisitsSummary_Controller->getEvolutionGraph()
#18 C:\Server\piwik\core\FrontController.php(138): call_user_func_array(Array, Array)
#19 C:\Server\piwik\core\FrontController.php(159): Piwik_FrontController->dispatch('VisitsSummary', 'getEvolutionGra...', Array)
#20 C:\Server\piwik\core\ViewDataTable\GenerateGraphHTML.php(170): Piwik_FrontController->fetchDispatch('VisitsSummary', 'getEvolutionGra...', Array)
#21 C:\Server\piwik\core\ViewDataTable\GenerateGraphHTML.php(125): Piwik_ViewDataTable_GenerateGraphHTML->getGraphData()
#22 C:\Server\piwik\core\ViewDataTable\GenerateGraphHTML.php(109): Piwik_ViewDataTable_GenerateGraphHTML->buildView()
#23 C:\Server\piwik\core\Controller.php(247): Piwik_ViewDataTable_GenerateGraphHTML->main()
#24 C:\Server\piwik\plugins\VisitsSummary\Controller.php(78): Piwik_Controller->getLastUnitGraphAcrossPlugins('VisitsSummary', 'getEvolutionGra...', Array, Array, 'This is an over...')
#25 [internal function]: Piwik_VisitsSummary_Controller->getEvolutionGraph()
#26 C:\Server\piwik\core\FrontController.php(138): call_user_func_array(Array, Array)
#27 C:\Server\piwik\index.php(53): Piwik_FrontController->dispatch()
#28 {main}

Length of Visits:


Unexpected data type to render.

Go to Piwik
Login

Backtrace:
#0 C:\Server\piwik\core\ViewDataTable\Cloud.php(74): Piwik_ViewDataTable->checkStandardDataTable()
#1 C:\Server\piwik\core\Controller.php(152): Piwik_ViewDataTable_Cloud->main()
#2 C:\Server\piwik\plugins\VisitorInterest\Controller.php(42): Piwik_Controller->renderView(Object(Piwik_ViewDataTable_Cloud), false)
#3 [internal function]: Piwik_VisitorInterest_Controller->getNumberOfVisitsPerVisitDuration()
#4 C:\Server\piwik\core\FrontController.php(138): call_user_func_array(Array, Array)
#5 C:\Server\piwik\index.php(53): Piwik_FrontController->dispatch()
#6 {main}

Visits by server time:



SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: '' for column 'date1' at row 1

Go to Piwik
Login

Backtrace:
#0 C:\Server\piwik\core\ArchiveProcessing.php(691): Zend_Db_Adapter_Pdo_Abstract->exec('INSERT INTO piw...')
#1 C:\Server\piwik\core\ArchiveProcessing.php(533): Piwik_ArchiveProcessing->loadNextIdarchive()
#2 C:\Server\piwik\core\ArchiveProcessing.php(472): Piwik_ArchiveProcessing->initCompute()
#3 C:\Server\piwik\core\Archive\Single.php(226): Piwik_ArchiveProcessing->launchArchiving()
#4 C:\Server\piwik\core\Archive\Single.php(256): Piwik_Archive_Single->prepareArchive()
#5 C:\Server\piwik\core\Archive\Single.php(514): Piwik_Archive_Single->get('VisitTime_serve...', 'blob', NULL)
#6 C:\Server\piwik\plugins\VisitTime\API.php(34): Piwik_Archive_Single->getDataTable('VisitTime_serve...')
#7 C:\Server\piwik\plugins\VisitTime\API.php(48): Piwik_VisitTime_API->getDataTable('VisitTime_serve...', '3', 'day', 'today', false)
#8 [internal function]: Piwik_VisitTime_API->getVisitInformationPerServerTime('3', 'day', 'today', false, '1')
#9 C:\Server\piwik\core\API\Proxy.php(190): call_user_func_array(Array, Array)
#10 C:\Server\piwik\core\API\Request.php(128): Piwik_API_Proxy->call('Piwik_VisitTime...', 'getVisitInforma...', Array)
#11 C:\Server\piwik\core\ViewDataTable.php(421): Piwik_API_Request->process()
#12 C:\Server\piwik\core\ViewDataTable\GenerateGraphData.php(181): Piwik_ViewDataTable->loadDataTableFromAPI()
#13 C:\Server\piwik\core\Controller.php(152): Piwik_ViewDataTable_GenerateGraphData->main()
#14 C:\Server\piwik\plugins\VisitTime\Controller.php(35): Piwik_Controller->renderView(Object(Piwik_ViewDataTable_GenerateGraphData_ChartVerticalBar), false)
#15 [internal function]: Piwik_VisitTime_Controller->getVisitInformationPerServerTime()
#16 C:\Server\piwik\core\FrontController.php(138): call_user_func_array(Array, Array)
#17 C:\Server\piwik\core\FrontController.php(159): Piwik_FrontController->dispatch('VisitTime', 'getVisitInforma...', Array)
#18 C:\Server\piwik\core\ViewDataTable\GenerateGraphHTML.php(170): Piwik_FrontController->fetchDispatch('VisitTime', 'getVisitInforma...', Array)
#19 C:\Server\piwik\core\ViewDataTable\GenerateGraphHTML.php(125): Piwik_ViewDataTable_GenerateGraphHTML->getGraphData()
#20 C:\Server\piwik\core\ViewDataTable\GenerateGraphHTML.php(109): Piwik_ViewDataTable_GenerateGraphHTML->buildView()
#21 C:\Server\piwik\core\Controller.php(152): Piwik_ViewDataTable_GenerateGraphHTML->main()
#22 C:\Server\piwik\plugins\VisitTime\Controller.php(35): Piwik_Controller->renderView(Object(Piwik_ViewDataTable_GenerateGraphHTML_ChartVerticalBar), false)
#23 [internal function]: Piwik_VisitTime_Controller->getVisitInformationPerServerTime()
#24 C:\Server\piwik\core\FrontController.php(138): call_user_func_array(Array, Array)
#25 C:\Server\piwik\index.php(53): Piwik_FrontController->dispatch()
#26 {main}


#2

I also just noticed that the World countries is blank


#3

…and tracking has stopped.


(Matthieu Aubry) #4

Thanks fr the report, please repalce your core/Archiveprocessin.php file with this one: http://dev.piwik.org/svn/trunk/core/ArchiveProcessing.php


(Matthieu Aubry) #5

Regarding the bug “Tracking has stopped” please see this thread: 301 Moved Permanently