Errors after upgrading to 2.7.0

Support & Bugs
1

Notice: Undefined index: UndoPivotBySubtable in /piwik/core/Translate.php on line 173

Backtrace -->

#0 Piwik\Error::errorHandler(…) called at [/piwik/core/Translate.php:173]
#1 Piwik\Translate::getJavascriptTranslations(…) called at [/piwik/core/AssetManager.php:121]
#2 Piwik\AssetManager->getJsInclusionDirective(…) called at [/piwik/core/Twig.php:127]
#3 Piwik{closure}(…) called at [:]
#4 call_user_func_array(…) called at [/piwik/tmp/templates_c/0f/8c/ddf548419add16b559787b10c66a2fa883d0712af892300af23eff699f14.php:24]
#5 __TwigTemplate_0f8cddf548419add16b559787b10c66a2fa883d0712af892300af23eff699f14->doDisplay(…) called at [/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#6 Twig_Template->displayWithErrorHandling(…) called at [/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#7 Twig_Template->display(…) called at [/piwik/tmp/templates_c/4d/10/28a3473bc339679bdb8f85da82c7006e302d414ba9431351f3396f985aef.php:55]
#8 __TwigTemplate_4d1028a3473bc339679bdb8f85da82c7006e302d414ba9431351f3396f985aef->doDisplay(…) called at [/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#9 Twig_Template->displayWithErrorHandling(…) called at [/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#10 Twig_Template->display(…) called at [/piwik/vendor/twig/twig/lib/Twig/Template.php:264]
#11 Twig_Template->render(…) called at [/piwik/vendor/twig/twig/lib/Twig/Environment.php:292]
#12 Twig_Environment->render(…) called at [/piwik/core/View.php:263]
#13 Piwik\View->renderTwigTemplate(…) called at [/piwik/core/View.php:257]
#14 Piwik\View->render(…) called at [/piwik/plugins/Login/Controller.php:99]
#15 Piwik\Plugins\Login\Controller->login(…) called at [/piwik/plugins/Login/Controller.php:61]
#16 Piwik\Plugins\Login\Controller->index(…) called at [:]
#17 call_user_func_array(…) called at [/piwik/core/FrontController.php:577]
#18 Piwik\FrontController->doDispatch(…) called at [/piwik/core/FrontController.php:86]
#19 Piwik\FrontController->dispatch(…) called at [/piwik/core/Plugin/Controller.php:880]
#20 Piwik\Plugin\Controller->redirectToIndex(…) called at [/piwik/plugins/CoreHome/Controller.php:110]
#21 Piwik\Plugins\CoreHome\Controller->redirectToCoreHomeIndex(…) called at [:]
#22 call_user_func_array(…) called at [/piwik/core/FrontController.php:577]
#23 Piwik\FrontController->doDispatch(…) called at [/piwik/core/FrontController.php:86]
#24 Piwik\FrontController->dispatch(…) called at [/piwik/core/dispatch.php:34]
#25 require_once(…) called at [/piwik/index.php:46]

Notice: Undefined index: PivotBySubtable in /piwik/core/Translate.php on line 173

Backtrace -->

#0 Piwik\Error::errorHandler(…) called at [/piwik/core/Translate.php:173]
#1 Piwik\Translate::getJavascriptTranslations(…) called at [/piwik/core/AssetManager.php:121]
#2 Piwik\AssetManager->getJsInclusionDirective(…) called at [/piwik/core/Twig.php:127]
#3 Piwik{closure}(…) called at [:]
#4 call_user_func_array(…) called at [/piwik/tmp/templates_c/0f/8c/ddf548419add16b559787b10c66a2fa883d0712af892300af23eff699f14.php:24]
#5 __TwigTemplate_0f8cddf548419add16b559787b10c66a2fa883d0712af892300af23eff699f14->doDisplay(…) called at [/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#6 Twig_Template->displayWithErrorHandling(…) called at [/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#7 Twig_Template->display(…) called at [/piwik/tmp/templates_c/4d/10/28a3473bc339679bdb8f85da82c7006e302d414ba9431351f3396f985aef.php:55]
#8 __TwigTemplate_4d1028a3473bc339679bdb8f85da82c7006e302d414ba9431351f3396f985aef->doDisplay(…) called at [/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#9 Twig_Template->displayWithErrorHandling(…) called at [/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#10 Twig_Template->display(…) called at [/piwik/vendor/twig/twig/lib/Twig/Template.php:264]
#11 Twig_Template->render(…) called at [/piwik/vendor/twig/twig/lib/Twig/Environment.php:292]
#12 Twig_Environment->render(…) called at [/piwik/core/View.php:263]
#13 Piwik\View->renderTwigTemplate(…) called at [/piwik/core/View.php:257]
#14 Piwik\View->render(…) called at [/piwik/plugins/Login/Controller.php:99]
#15 Piwik\Plugins\Login\Controller->login(…) called at [/piwik/plugins/Login/Controller.php:61]
#16 Piwik\Plugins\Login\Controller->index(…) called at [:]
#17 call_user_func_array(…) called at [/piwik/core/FrontController.php:577]
#18 Piwik\FrontController->doDispatch(…) called at [/piwik/core/FrontController.php:86]
#19 Piwik\FrontController->dispatch(…) called at [/piwik/core/Plugin/Controller.php:880]
#20 Piwik\Plugin\Controller->redirectToIndex(…) called at [/piwik/plugins/CoreHome/Controller.php:110]
#21 Piwik\Plugins\CoreHome\Controller->redirectToCoreHomeIndex(…) called at [:]
#22 call_user_func_array(…) called at [/piwik/core/FrontController.php:577]
#23 Piwik\FrontController->doDispatch(…) called at [/piwik/core/FrontController.php:86]
#24 Piwik\FrontController->dispatch(…) called at [/piwik/core/dispatch.php:34]
#25 require_once(…) called at [/piwik/index.php:46]

2

I have the same probleme after upgrading to version 2.7.0. See after the backtrace :

There is an error. Please report the message (Piwik 2.7.0) and full backtrace in the Piwik forums (please do a Search first as it might have been reported already!).

Notice: Undefined index: UserId in /home/meteolai/public_html/piwik/core/Translate.php on line 173

Backtrace -->

#0 Piwik\Error::errorHandler(…) called at [/home/meteolai/public_html/piwik/core/Translate.php:173]
#1 Piwik\Translate::getJavascriptTranslations(…) called at [/home/meteolai/public_html/piwik/core/AssetManager.php:121]
#2 Piwik\AssetManager->getJsInclusionDirective(…) called at [/home/meteolai/public_html/piwik/core/Twig.php:127]
#3 Piwik\Twig->Piwik{closure}(…) called at [:]
#4 call_user_func_array(…) called at [/home/meteolai/public_html/piwik/tmp/templates_c/ba/82/d06aa6839b43746b9fe7065ce1cd742c182bd1a7a773fbb4e52f2e833774.php:24]
#5 __TwigTemplate_ba82d06aa6839b43746b9fe7065ce1cd742c182bd1a7a773fbb4e52f2e833774->doDisplay(…) called at [/home/meteolai/public_html/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#6 Twig_Template->displayWithErrorHandling(…) called at [/home/meteolai/public_html/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#7 Twig_Template->display(…) called at [/home/meteolai/public_html/piwik/tmp/templates_c/67/d8/d521661f990a01f5014c82f1dc5553429cbaf9206370ceb7695ba9f87e5f.php:121]
#8 __TwigTemplate_67d8d521661f990a01f5014c82f1dc5553429cbaf9206370ceb7695ba9f87e5f->block_head(…) called at [/home/meteolai/public_html/piwik/vendor/twig/twig/lib/Twig/Template.php:144]
#9 Twig_Template->displayBlock(…) called at [/home/meteolai/public_html/piwik/tmp/templates_c/67/d8/d521661f990a01f5014c82f1dc5553429cbaf9206370ceb7695ba9f87e5f.php:30]
#10 __TwigTemplate_67d8d521661f990a01f5014c82f1dc5553429cbaf9206370ceb7695ba9f87e5f->doDisplay(…) called at [/home/meteolai/public_html/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#11 Twig_Template->displayWithErrorHandling(…) called at [/home/meteolai/public_html/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#12 Twig_Template->display(…) called at [/home/meteolai/public_html/piwik/tmp/templates_c/4f/0e/8ee7c989bfce71697d6fcf76720b18a2ae596b9e30efecaca4a5d84d0b91.php:25]
#13 __TwigTemplate_4f0e8ee7c989bfce71697d6fcf76720b18a2ae596b9e30efecaca4a5d84d0b91->doDisplay(…) called at [/home/meteolai/public_html/piwik/vendor/twig/twig/lib/Twig/Template.php:279]
#14 Twig_Template->displayWithErrorHandling(…) called at [/home/meteolai/public_html/piwik/vendor/twig/twig/lib/Twig/Template.php:253]
#15 Twig_Template->display(…) called at [/home/meteolai/public_html/piwik/vendor/twig/twig/lib/Twig/Template.php:264]
#16 Twig_Template->render(…) called at [/home/meteolai/public_html/piwik/vendor/twig/twig/lib/Twig/Environment.php:292]
#17 Twig_Environment->render(…) called at [/home/meteolai/public_html/piwik/core/View.php:263]
#18 Piwik\View->renderTwigTemplate(…) called at [/home/meteolai/public_html/piwik/core/View.php:257]
#19 Piwik\View->render(…) called at [/home/meteolai/public_html/piwik/plugins/CoreHome/Controller.php:169]
#20 Piwik\Plugins\CoreHome\Controller->index(…) called at [:]
#21 call_user_func_array(…) called at [/home/meteolai/public_html/piwik/core/FrontController.php:577]
#22 Piwik\FrontController->doDispatch(…) called at [/home/meteolai/public_html/piwik/core/FrontController.php:86]
#23 Piwik\FrontController->dispatch(…) called at [/home/meteolai/public_html/piwik/core/dispatch.php:34]
#24 require_once(…) called at [/home/meteolai/public_html/piwik/index.php:46]

3

Delete files in tmp/* and refresh, it should fix it!

4

Did it, and was able to log in without error messages, but now I get errors for some of the sites that use this installation (multi-site setup in this case).

Here is the error when I click onto “All websites”

API returned an error: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_link_visit_action.idaction_content_name’ in ‘where clause’ at Pdo.php:234

And here is what shows up in windows like Visits, Keywords, Search Engines, Browsers, etc. when I chek individual sites:

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

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

5

An update:

I have deleted all files, copied 2.7.0 over (kept config), got same thing. Then I deleted all archive tables from the database, and now I get errors for all sites. This tells me that the installtion has trouble with archiving which is set to YES.

Any suggestion?

Thanks

6

I have deleted all files in /tmp but i have always the same problem.

7

have same issue, tmp folder fix dose not work.

8

Question:

Which script upgrades the database when needed during an install of the new version? I would like to rerun it.

Thanks

9

I found an FAQ answering my question:

http://piwik.org/faq/how-to-update/faq_179/

and the above has helped 100% in fixing my problem. Now I know that the problem was caused by this:

  1. I upgraded from 2.6.1 to 2.7.0
  2. I had a problem as reported in the initial post
  3. I copied 2.6.1 over the 2.7.0 installation (keep in mind that the database stayed upgraded to 2.7.0)
  4. Got suggestion for deleting stuff in TMP - after I copied 2.6.1 files over - which could not fully help

My conclusion is that I ended up with 2.7.0 database while using 2.6.1 installation. Copying 2.7.0 did not fully help, but rerunning a database upgrade again (based on the FAQ from the above) resolved the problem and put things in line.

Thanks

10

@pwkuser thanks for following up and explaining!

If you experience this issue as well, first try to Activate the Contents plugin. If this does not work see previous message from @pwkuser

11

I tried a bunch of things first after getting the same errors in upgrading from 2.6.2 to 2.7.0, but eventually followed these steps.

  1. Put piwik into maintenance mode.
  2. Backed up my server’s piwik directory.
  3. Deleted every item in the server’s piwik directory but the config folder.
  4. Downloaded and unzipped 2.7.0 version of piwik to my local PC.
  5. Re-zipped all files excluding the config folder.
  6. Uploaded the zip file to server and unzipped in piwik directory
  7. Deleted everything in the /tmp directory
  8. Reset the database version (in my case 2.6.2) using this faq
  9. Updated the database using the command line running this command twice 

php /home/hestfamily/he-st.com/p/console core:update

There may be erroneous steps, but this seemed to be what worked.

12

Hi all, I’ve founded a way to fix the problem:

  1. setted the maintenance mode flag into my piwik config file
  2. in table “piwik_options” I have changed the “option_value” corresponding to the “version_core” record from 2.7.0 to 2.6.1
  3. from the terminal I have performed a core:update command (like specified in this thread)
  4. finally after the login, piwik suggest me to perform an other update
    Now I don’t have any of the problem reported into this thread.

Sorry for my poor english,
Best regards

13

Hi,

I updated this morning to 2.7.0 and now my inbox is full of failed cron archive jobs ;|
peterpitone’s fix worked for me and apparently fixed the sql issues. Thanks man!

Cheers,
Lukas