MySQL failure piwiik 2.7.0 update


#1

Hello,

Im getting this message in different tabs.

WARN CoreHome[2014-10-03 11:20:45] [f4ff6] Failed to get data from API: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_link_visit_action.idaction_content_name’ in ‘where clause’#0 /homepages/28/d314552651/htdocs/cmsanalytic/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->execute(Array)#1 /homepages/28/d314552651/htdocs/cmsanalytic/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)#2 /homepages/28/d314552651/htdocs/cmsanalytic/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array)#3 /homepages/28/d314552651/htdocs/cmsanalytic/core/Db/Adapter/Pdo/Mysql.php(229): Zend_Db_Adapter_Pdo_Abstract->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array)#4 /homepages/28/d314552651/htdocs/cmsanalytic/plugins/Actions/Archiver.php(273): Piwik\Db\Adapter\Pdo\Mysql->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array)#5 /homepages/28/d314552651/htdocs/cmsanalytic/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 /homepages/28/d314552651/htdocs/cmsanalytic/plugins/Actions/Archiver.php(93): Piwik\Plugins\Actions\Archiver->archiveDayActions(‘50000’)#7 /homepages/28/d314552651/htdocs/cmsanalytic/core/ArchiveProcessor/PluginsArchiver.php(100): Piwik\Plugins\Actions\Archiver->aggregateDayReport()#8 /homepages/28/d314552651/htdocs/cmsanalytic/core/ArchiveProcessor/Loader.php(119): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins(‘4’, ‘0’)#9 /homepages/28/d314552651/htdocs/cmsanalytic/core/ArchiveProcessor/Loader.php(73): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(false, false)#10 /homepages/28/d314552651/htdocs/cmsanalytic/core/Archive.php(801): Piwik\ArchiveProcessor\Loader->prepareArchive(‘Referrers’)#11 /homepages/28/d314552651/htdocs/cmsanalytic/core/Archive.php(614): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day))#12 /homepages/28/d314552651/htdocs/cmsanalytic/core/Archive.php(556): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array)#13 /homepages/28/d314552651/htdocs/cmsanalytic/core/Archive.php(497): Piwik\Archive->getArchiveIds(Array)#14 /homepages/28/d314552651/htdocs/cmsanalytic/core/Archive.php(368): Piwik\Archive->get(‘Referrers_searc…’, ‘blob’, NULL)#15 /homepages/28/d314552651/htdocs/cmsanalytic/core/Archive.php(459): Piwik\Archive->getDataTable(‘Referrers_searc…’, NULL)#16 /homepages/28/d314552651/htdocs/cmsanalytic/plugins/Referrers/API.php(45): Piwik\Archive::getDataTableFromArchive(‘Referrers_searc…’, ‘1’, ‘day’, ‘2014-10-03’, false, false, NULL)#17 /homepages/28/d314552651/htdocs/cmsanalytic/plugins/Referrers/API.php(138): Piwik\Plugins\Referrers\API->getDataTable(‘Referrers_searc…’, ‘1’, ‘day’, ‘2014-10-03’, false, false)#18 [internal function]: Piwik\Plugins\Referrers\API->getKeywords(‘1’, ‘day’, ‘2014-10-03’, false, false)#19 /homepages/28/d314552651/htdocs/cmsanalytic/core/API/Proxy.php(209): call_user_func_array(Array, Array)#20 /homepages/28/d314552651/htdocs/cmsanalytic/core/API/Request.php(216): Piwik\API\Proxy->call(’\Piwik\Plugins\…’, ‘getKeywords’, Array)#21 /homepages/28/d314552651/htdocs/cmsanalytic/core/ViewDataTable/Request.php(48): Piwik\API\Request->process()#22 /homepages/28/d314552651/htdocs/cmsanalytic/core/Plugin/ViewDataTable.php(327): Piwik\ViewDataTable\Request->loadDataTableFromAPI(Array)#23 /homepages/28/d314552651/htdocs/cmsanalytic/core/Plugin/Visualization.php(166): Piwik\Plugin\ViewDataTable->loadDataTableFromAPI(Array)#24 /homepages/28/d314552651/htdocs/cmsanalytic/core/Plugin/ViewDataTable.php(414): Piwik\Plugin\Visualization->buildView()#25 /homepages/28/d314552651/htdocs/cmsanalytic/core/Plugin/Report.php(298): Piwik\Plugin\ViewDataTable->render()#26 /homepages/28/d314552651/htdocs/cmsanalytic/plugins/CoreHome/Controller.php(78): Piwik\Plugin\Report->render()#27 [internal function]: Piwik\Plugins\CoreHome\Controller->renderReportWidget(‘Referrers’, ‘getKeywords’)#28 /homepages/28/d314552651/htdocs/cmsanalytic/core/FrontController.php(577): call_user_func_array(Array, Array)#29 /homepages/28/d314552651/htdocs/cmsanalytic/core/FrontController.php(86): Piwik\FrontController->doDispatch(NULL, NULL, NULL)#30 /homepages/28/d314552651/htdocs/cmsanalytic/core/dispatch.php(34): Piwik\FrontController->dispatch()#31 /homepages/28/d314552651/htdocs/cmsanalytic/index.php(46): require_once(’/homepages/28/d…’)#32 {main}
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_link_visit_action.idaction_content_name’ in ‘where clause’

Thx

Andreas


(Alexander) #2

active the plugin Contents

© Matt