After an upgrade from 1.7.1 to 1.8 i’m receiving the following error for several websites. The only website that is not giving this error is the ‘main’ website i added during the installation of 1.7.1.
Any suggestions?
SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘’ for column ‘idsite’ at row 1
Go to Piwik
Login
Backtrace:
#0 C:\piwik\core\ArchiveProcessing.php(691): Zend_Db_Adapter_Pdo_Abstract->exec(‘INSERT INTO pk_…’)
#1 C:\piwik\core\ArchiveProcessing.php(533): Piwik_ArchiveProcessing->loadNextIdarchive()
#2 C:\piwik\core\ArchiveProcessing.php(472): Piwik_ArchiveProcessing->initCompute()
#3 C:\piwik\core\Archive\Single.php(226): Piwik_ArchiveProcessing->launchArchiving()
#4 C:\piwik\core\Archive\Array\IndexedByDate.php(90): Piwik_Archive_Single->prepareArchive()
#5 C:\piwik\plugins\VisitsSummary\API.php(88): Piwik_Archive_Array_IndexedByDate->getDataTableFromNumeric(Array)
#6 [internal function]: Piwik_VisitsSummary_API->get(‘2’, ‘day’, ‘2012-05-02,2012…’, false, ‘nb_visits’)
#7 C:\piwik\core\API\Proxy.php(190): call_user_func_array(Array, Array)
#8 C:\piwik\plugins\API\API.php(986): Piwik_API_Proxy->call(‘Piwik_VisitsSum…’, ‘get’, Array)
#9 [internal function]: Piwik_API_API->get(‘2’, ‘day’, ‘2012-05-02,2012…’, false, ‘nb_visits’)
#10 C:\piwik\core\API\Proxy.php(190): call_user_func_array(Array, Array)
#11 C:\piwik\core\API\Request.php(128): Piwik_API_Proxy->call(‘Piwik_API_API’, ‘get’, Array)
#12 C:\piwik\core\ViewDataTable.php(421): Piwik_API_Request->process()
#13 C:\piwik\core\ViewDataTable\GenerateGraphData\ChartEvolution.php(109): Piwik_ViewDataTable->loadDataTableFromAPI()
#14 C:\piwik\core\ViewDataTable\GenerateGraphData.php(181): Piwik_ViewDataTable_GenerateGraphData_ChartEvolution->loadDataTableFromAPI()
#15 C:\piwik\core\Controller.php(247): Piwik_ViewDataTable_GenerateGraphData->main()
#16 C:\piwik\plugins\VisitsSummary\Controller.php(78): Piwik_Controller->getLastUnitGraphAcrossPlugins(‘VisitsSummary’, ‘getEvolutionGra…’, Array, Array, ‘Dit is een over…’)
#17 [internal function]: Piwik_VisitsSummary_Controller->getEvolutionGraph()
#18 C:\piwik\core\FrontController.php(138): call_user_func_array(Array, Array)
#19 C:\piwik\core\FrontController.php(159): Piwik_FrontController->dispatch(‘VisitsSummary’, ‘getEvolutionGra…’, Array)
#20 C:\piwik\core\ViewDataTable\GenerateGraphHTML.php(170): Piwik_FrontController->fetchDispatch(‘VisitsSummary’, ‘getEvolutionGra…’, Array)
#21 C:\piwik\core\ViewDataTable\GenerateGraphHTML.php(125): Piwik_ViewDataTable_GenerateGraphHTML->getGraphData()
#22 C:\piwik\core\ViewDataTable\GenerateGraphHTML.php(109): Piwik_ViewDataTable_GenerateGraphHTML->buildView()
#23 C:\piwik\core\Controller.php(247): Piwik_ViewDataTable_GenerateGraphHTML->main()
#24 C:\piwik\plugins\VisitsSummary\Controller.php(78): Piwik_Controller->getLastUnitGraphAcrossPlugins(‘VisitsSummary’, ‘getEvolutionGra…’, Array, Array, ‘Dit is een over…’)
#25 [internal function]: Piwik_VisitsSummary_Controller->getEvolutionGraph()
#26 C:\piwik\core\FrontController.php(138): call_user_func_array(Array, Array)
#27 C:\piwik\index.php(53): Piwik_FrontController->dispatch()
#28 {main}