Failed to get data from API


#1

I’ve just installed Piwik, and it doesn’t work (look at the screenshot).

copied error:

WARN VisitsSummary[2014-08-26 15:49:19] [d772a] Failed to get data from API: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_link_visit_action.custom_var_v5’ in ‘field list’#0 /home/ghb/public_html/piwik/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->execute(Array)#1 /home/<my_user_name>/public_html/piwik/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)#2 /home/<my_user_name>/public_html/piwik/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array)#3 /home/<my_user_name>/public_html/piwik/core/Db/Adapter/Pdo/Mysql.php(229): Zend_Db_Adapter_Pdo_Abstract->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array)#4 /home/<my_user_name>/public_html/piwik/plugins/Actions/Archiver.php(273): Piwik\Db\Adapter\Pdo\Mysql->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array)#5 /home/<my_user_name>/public_html/piwik/plugins/Actions/Archiver.php(247): Piwik\Plugins\Actions\Archiver->archiveDayQueryProcess(‘log_action.name…’, Array, 'log_link_visit…’, ’12 DESC, name…’, ‘log_action.idac…’, ‘idaction_name’, Object(Piwik\RankingQuery))#6 /home/<my_user_name>/public_html/piwik/plugins/Actions/Archiver.php(93): Piwik\Plugins\Actions\Archiver->archiveDayActions(‘50000’)#7 /home/<my_user_name>/public_html/piwik/core/ArchiveProcessor/PluginsArchiver.php(100): Piwik\Plugins\Actions\Archiver->aggregateDayReport()#8 /home/<my_user_name>/public_html/piwik/core/ArchiveProcessor/Loader.php(119): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins(‘3’, ‘0’)#9 /home/<my_user_name>/public_html/piwik/core/ArchiveProcessor/Loader.php(73): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(false, false)#10 /home/<my_user_name>/public_html/piwik/core/Archive.php(801): Piwik\ArchiveProcessor\Loader->prepareArchive(‘VisitsSummary’)#11 /home/<my_user_name>/public_html/piwik/core/Archive.php(614): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day))#12 /home/<my_user_name>/public_html/piwik/core/Archive.php(556): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array)#13 /home/<my_user_name>/public_html/piwik/core/Archive.php(497): Piwik\Archive->getArchiveIds(Array)#14 /home/<my_user_name>/public_html/piwik/core/Archive.php(341): Piwik\Archive->get(Array, ‘numeric’)#15 /home/<my_user_name>/public_html/piwik/plugins/VisitsSummary/API.php(59): Piwik\Archive->getDataTableFromNumeric(Array)#16 [internal function]: Piwik\Plugins\VisitsSummary\API->get(‘1’, ‘day’, ‘2014-07-28,2014…’, false, ‘nb_visits’)#17 /home/<my_user_name>/public_html/piwik/core/API/Proxy.php(209): call_user_func_array(Array, Array)#18 /home/<my_user_name>/public_html/piwik/plugins/API/API.php(360): Piwik\API\Proxy->call(’\Piwik\Plugins\…’, ‘get’, Array)#19 [internal function]: Piwik\Plugins\API\API->get(‘1’, ‘day’, ‘2014-07-28,2014…’, false, ‘nb_visits’)#20 /home/<my_user_name>/public_html/piwik/core/API/Proxy.php(209): call_user_func_array(Array, Array)#21 /home/<my_user_name>/public_html/piwik/core/API/Request.php(215): Piwik\API\Proxy->call(’\Piwik\Plugins\…’, ‘get’, Array)#22 /home/<my_user_name>/public_html/piwik/core/ViewDataTable/Request.php(48): Piwik\API\Request->process()#23 /home/<my_user_name>/public_html/piwik/core/Plugin/ViewDataTable.php(322): Piwik\ViewDataTable\Request->loadDataTableFromAPI(Array)#24 /home/<my_user_name>/public_html/piwik/core/Plugin/Visualization.php(166): Piwik\Plugin\ViewDataTable->loadDataTableFromAPI(Array)#25 /home/<my_user_name>/public_html/piwik/core/Plugin/ViewDataTable.php(409): Piwik\Plugin\Visualization->buildView()#26 /home/<my_user_name>/public_html/piwik/core/Plugin/Controller.php(248): Piwik\Plugin\ViewDataTable->render()#27 /home/<my_user_name>/public_html/piwik/plugins/VisitsSummary/Controller.php(100): Piwik\Plugin\Controller->renderView(Object(Piwik\Plugins\CoreVisualizations\Visualizations\JqplotGraph\Evolution))#28 [internal function]: Piwik\Plugins\VisitsSummary\Controller->getEvolutionGraph()#29 /home/<my_user_name>/public_html/piwik/core/FrontController.php(576): call_user_func_array(Array, Array)#30 /home/<my_user_name>/public_html/piwik/core/FrontController.php(86): Piwik\FrontController->doDispatch(NULL, NULL, NULL)#31 /home/<my_user_name>/public_html/piwik/core/dispatch.php(34): Piwik\FrontController->dispatch()#32 /home/<my_user_name>/public_html/piwik/index.php(47): require_once(’/home/u36803944…’)#33 {main}

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_link_visit_action.custom_var_v5’ in ‘field list’


(Kuba Bomba) #2

Hi!

Try to install Piwik once again. Maybe something went wrong (column for custom_var_v5 should be successfully added during installation)?


#3

Thanks, re-installing Piwik helped, but I often see the message “Oops… there was a problem during the request. Maybe the server had a temporary issue, or maybe you requested a report with too much data. Please try again. If this error occurs repeatedly please contact your Piwik administrator for assistance.” is is because of low-power server?


(Kuba Bomba) #4

Try to set up cron archiving.


(Matthieu Aubry) #5

Cron archiving: How to Set up Auto-Archiving of Your Reports - Analytics Platform - Matomo

Also check your server error log file for an error message (then look in FAQ for this error)