Errors After Installing Latest Version


(Bruce) #1

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’


(Bruce) #2

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.