Errors After Installing Latest Version

cqjb · September 25, 2014, 12:04am

Photo of problem: Piwik | treehopper | Flickr

Major problem after updating to new Piwik today, anyone can help me?

I tried searching for a solution and ran into different language posts etc, so posting here.

Main errors

WARN VisitsSummary[2014-09-24 20:59:27] [c718b] 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 /home/content/20/8334020/html/piwik/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->execute(Array)#1 /home/content/20/8334020/html/piwik/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)#2 /home/content/20/8334020/html/piwik/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’???SELECT???..’, Array)#3 /home/content/20/8334020/html/piwik/core/Db/Adapter/Pdo/Mysql.php(229): Zend_Db_Adapter_Pdo_Abstract->query(’???SELECT???..’, Array)#4 /home/content/20/8334020/html/piwik/plugins/Actions/Archiver.php(273): Piwik\Db\Adapter\Pdo\Mysql->query(’???SELECT???..’, Array)#5 /home/content/20/8334020/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/content/20/8334020/html/piwik/plugins/Actions/Archiver.php(93): Piwik\Plugins\Actions\Archiver->archiveDayActions(‘50000’)#7 /home/content/20/8334020/html/piwik/core/ArchiveProcessor/PluginsArchiver.php(100): Piwik\Plugins\Actions\Archiver->aggregateDayReport()#8 /home/content/20/8334020/html/piwik/core/ArchiveProcessor/Loader.php(119): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins(‘21’, ‘2’)#9 /home/content/20/8334020/html/piwik/core/ArchiveProcessor/Loader.php(73): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(false, false)#10 /home/content/20/8334020/html/piwik/core/Archive.php(801): Piwik\ArchiveProcessor\Loader->prepareArchive(‘VisitsSummary’)#11 /home/content/20/8334020/html/piwik/core/Archive.php(614): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day))#12 /home/content/20/8334020/html/piwik/core/Archive.php(556): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array)#13 /home/content/20/8334020/html/piwik/core/Archive.php(497): Piwik\Archive->getArchiveIds(Array)#14 /home/content/20/8334020/html/piwik/core/Archive.php(341): Piwik\Archive->get(Array, ‘numeric’)#15 /home/content/20/8334020/html/piwik/plugins/VisitsSummary/API.php(59): Piwik\Archive->getDataTableFromNumeric(Array)#16 [internal function]: Piwik\Plugins\VisitsSummary\API->get(‘4’, ‘day’, ‘2014-06-27,2014…’, false, ‘nb_visits’)#17 /home/content/20/8334020/html/piwik/core/API/Proxy.php(209): call_user_func_array(Array, Array)#18 /home/content/20/8334020/html/piwik/plugins/API/API.php(403): Piwik\API\Proxy->call(’\Piwik\Plugins…’, ‘get’, Array)#19 [internal function]: Piwik\Plugins\API\API->get(‘4’, ‘day’, ‘2014-06-27,2014…’, false, Array)#20 /home/content/20/8334020/html/piwik/core/API/Proxy.php(209): call_user_func_array(Array, Array)#21 /home/content/20/8334020/html/piwik/core/API/Request.php(216): Piwik\API\Proxy->call(’\Piwik\Plugins…’, ‘get’, Array)#22 /home/content/20/8334020/html/piwik/core/ViewDataTable/Request.php(48): Piwik\API\Request->process()#23 /home/content/20/8334020/html/piwik/core/Plugin/ViewDataTable.php(327): Piwik\ViewDataTable\Request->loadDataTableFromAPI(Array)#24 /home/content/20/8334020/html/piwik/core/Plugin/Visualization.php(166): Piwik\Plugin\ViewDataTable->loadDataTableFromAPI(Array)#25 /home/content/20/8334020/html/piwik/core/Plugin/ViewDataTable.php(414): Piwik\Plugin\Visualization->buildView()#26 /home/content/20/8334020/html/piwik/core/Plugin/Controller.php(248): Piwik\Plugin\ViewDataTable->render()#27 /home/content/20/8334020/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/content/20/8334020/html/piwik/core/FrontController.php(577): call_user_func_array(Array, Array)#30 /home/content/20/8334020/html/piwik/core/FrontController.php(86): Piwik\FrontController->doDispatch(NULL, NULL, NULL)#31 /home/content/20/8334020/html/piwik/core/dispatch.php(34): Piwik\FrontController->dispatch()#32 /home/content/20/8334020/html/piwik/index.php(46): require_once(’/home/content/2…’)#33 {main}

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_link_visit_action.idaction_content_name’ in ‘where clause’

WARN CoreHome[2014-09-24 20:59:26] [e57f8] 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 /home/content/20/8334020/html/piwik/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->execute(Array)#1 /home/content/20/8334020/html/piwik/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)#2 /home/content/20/8334020/html/piwik/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’???SELECT???..’, Array)#3 /home/content/20/8334020/html/piwik/core/Db/Adapter/Pdo/Mysql.php(229): Zend_Db_Adapter_Pdo_Abstract->query(’???SELECT???..’, Array)#4 /home/content/20/8334020/html/piwik/plugins/Actions/Archiver.php(273): Piwik\Db\Adapter\Pdo\Mysql->query(’???SELECT???..’, Array)#5 /home/content/20/8334020/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/content/20/8334020/html/piwik/plugins/Actions/Archiver.php(93): Piwik\Plugins\Actions\Archiver->archiveDayActions(‘50000’)#7 /home/content/20/8334020/html/piwik/core/ArchiveProcessor/PluginsArchiver.php(100): Piwik\Plugins\Actions\Archiver->aggregateDayReport()#8 /home/content/20/8334020/html/piwik/core/ArchiveProcessor/Loader.php(119): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins(‘21’, ‘2’)#9 /home/content/20/8334020/html/piwik/core/ArchiveProcessor/Loader.php(73): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(false, false)#10 /home/content/20/8334020/html/piwik/core/Archive.php(801): Piwik\ArchiveProcessor\Loader->prepareArchive(‘UserSettings’)#11 /home/content/20/8334020/html/piwik/core/Archive.php(614): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day))#12 /home/content/20/8334020/html/piwik/core/Archive.php(556): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array)#13 /home/content/20/8334020/html/piwik/core/Archive.php(497): Piwik\Archive->getArchiveIds(Array)#14 /home/content/20/8334020/html/piwik/core/Archive.php(368): Piwik\Archive->get(‘UserSettings_br…’, ‘blob’, NULL)#15 /home/content/20/8334020/html/piwik/plugins/UserSettings/API.php(33): Piwik\Archive->getDataTable(‘UserSettings_br…’)#16 /home/content/20/8334020/html/piwik/plugins/UserSettings/API.php(132): Piwik\Plugins\UserSettings\API->getDataTable(‘UserSettings_br…’, ‘4’, ‘day’, ‘2014-09-24’, false)#17 /home/content/20/8334020/html/piwik/plugins/UserSettings/API.php(144): Piwik\Plugins\UserSettings\API->getBrowserTable(‘4’, ‘day’, ‘2014-09-24’, false)#18 [internal function]: Piwik\Plugins\UserSettings\API->getBrowser(‘4’, ‘day’, ‘2014-09-24’, false)#19 /home/content/20/8334020/html/piwik/core/API/Proxy.php(209): call_user_func_array(Array, Array)#20 /home/content/20/8334020/html/piwik/core/API/Request.php(216): Piwik\API\Proxy->call(’\Piwik\Plugins…’, ‘getBrowser’, Array)#21 /home/content/20/8334020/html/piwik/core/ViewDataTable/Request.php(48): Piwik\API\Request->process()#22 /home/content/20/8334020/html/piwik/core/Plugin/ViewDataTable.php(327): Piwik\ViewDataTable\Request->loadDataTableFromAPI(Array)#23 /home/content/20/8334020/html/piwik/core/Plugin/Visualization.php(166): Piwik\Plugin\ViewDataTable->loadDataTableFromAPI(Array)#24 /home/content/20/8334020/html/piwik/core/Plugin/ViewDataTable.php(414): Piwik\Plugin\Visualization->buildView()#25 /home/content/20/8334020/html/piwik/core/Plugin/Report.php(298): Piwik\Plugin\ViewDataTable->render()#26 /home/content/20/8334020/html/piwik/plugins/CoreHome/Controller.php(78): Piwik\Plugin\Report->render()#27 [internal function]: Piwik\Plugins\CoreHome\Controller->renderReportWidget(‘UserSettings’, ‘getBrowser’)#28 /home/content/20/8334020/html/piwik/core/FrontController.php(577): call_user_func_array(Array, Array)#29 /home/content/20/8334020/html/piwik/core/FrontController.php(86): Piwik\FrontController->doDispatch(NULL, NULL, NULL)#30 /home/content/20/8334020/html/piwik/core/dispatch.php(34): Piwik\FrontController->dispatch()#31 /home/content/20/8334020/html/piwik/index.php(46): require_once(’/home/content/2…’)#32 {main}

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_link_visit_action.idaction_content_name’ in ‘where clause’

cqjb · September 25, 2014, 1:51am

I deleted entire ‘piwik’ folder on my site, all files.
Downloaded latest release, reuploaded all files to my server, ‘piwik’ folder (Had to use binary mode on my CuteFTP) as three files had issues.
Reinstalled the entire Piwik (it asked me to) from the main location URL where I open Piwik… logged in… and realigned all the database, user/password, etc.

After install all seems to be fine, so far. If not I will report back.