Upgraded to 2.14; Undefined index: config_browser_name

Hi,

I’ve just updated my piwik to 2.14 from 2.13.1 and it has stopped working. the warnings it generates i will post below.

i updated my installation manually, using these instructions:

https://piwik.org/docs/update/#the-manual-three-step-update

and then ran the data base upgrade when i logged in. piwik broke at this point, and so i tried re-running the database upgrade following the instructions here:

https://piwik.org/faq/how-to-update/#faq_179

but my piwik installation is still broken, and makes many error messages when i log in. i haven’t been able to find any other posts referencing this issue, nor could i find anything about it in the issue tracker.

does anyone have any ideas how i could fix this?

with thanks

error messages:

ERROR: Failed to get data from API: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_visit.location_browser_lang’ in ‘field list’ #0 /home/jaspservices/services.jasp-stats.org/piwik/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/jaspservices/services.jasp-stats.org/piwik/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /home/jaspservices/services.jasp-stats.org/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/jaspservices/services.jasp-stats.org/piwik/core/Db/Adapter/Pdo/Mysql.php(233): Zend_Db_Adapter_Pdo_Abstract->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array) #4 /home/jaspservices/services.jasp-stats.org/piwik/core/DataAccess/LogAggregator.php(324): Piwik\Db\Adapter\Pdo\Mysql->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array) #5 /home/jaspservices/services.jasp-stats.org/piwik/plugins/UserLanguage/Archiver.php(65): Piwik\DataAccess\LogAggregator->queryVisitsByDimension(Array) #6 /home/jaspservices/services.jasp-stats.org/piwik/plugins/UserLanguage/Archiver.php(38): Piwik\Plugins\UserLanguage\Archiver->aggregateByLanguage() #7 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/PluginsArchiver.php(108): Piwik\Plugins\UserLanguage\Archiver->aggregateDayReport() #8 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/Loader.php(122): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins(‘92’, ‘0’) #9 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/Loader.php(72): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(false, false) #10 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(894): Piwik\ArchiveProcessor\Loader->prepareArchive(‘Referrers’) #11 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(708): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day)) #12 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(660): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array) #13 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(598): Piwik\Archive->getArchiveIds(Array) #14 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(369): Piwik\Archive->get(‘Referrers_searc…’, ‘blob’, NULL) #15 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(460): Piwik\Archive->getDataTable(‘Referrers_searc…’, NULL) #16 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(489): Piwik\Archive::getDataTableFromArchive(‘Referrers_searc…’, ‘1’, ‘day’, ‘2015-07-08’, false, false, NULL, NULL) #17 /home/jaspservices/services.jasp-stats.org/piwik/plugins/Referrers/API.php(138): Piwik\Archive::createDataTableFromArchive(‘Referrers_searc…’, ‘1’, ‘day’, ‘2015-07-08’, false, false, false) #18 [internal function]: Piwik\Plugins\Referrers\API->getKeywords(‘1’, ‘day’, ‘2015-07-08’, false, false, false) #19 /home/jaspservices/services.jasp-stats.org/piwik/core/API/Proxy.php(211): call_user_func_array(Array, Array) #20 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Visualization.php(259): Piwik\API\Proxy->call(’\Piwik\Plugins\…’, ‘getKeywords’, Array) #21 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Visualization.php(180): Piwik\Plugin\Visualization->loadDataTableFromAPI() #22 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/ViewDataTable.php(414): Piwik\Plugin\Visualization->buildView() #23 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Report.php(338): Piwik\Plugin\ViewDataTable->render() #24 /home/jaspservices/services.jasp-stats.org/piwik/plugins/CoreHome/Controller.php(78): Piwik\Plugin\Report->render() #25 [internal function]: Piwik\Plugins\CoreHome\Controller->renderReportWidget(Object(Piwik\Plugins\Referrers\Reports\GetKeywords)) #26 /home/jaspservices/services.jasp-stats.org/piwik/core/FrontController.php(494): call_user_func_array(Array, Array) #27 /home/jaspservices/services.jasp-stats.org/piwik/core/FrontController.php(94): Piwik\FrontController->doDispatch(NULL, NULL, NULL) #28 /home/jaspservices/services.jasp-stats.org/piwik/core/dispatch.php(34): Piwik\FrontController->dispatch() #29 /home/jaspservices/services.jasp-stats.org/piwik/index.php(27): require_once(’/home/jaspservi…’) #30 {main}
ERROR: Failed to get data from API: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_visit.location_browser_lang’ in ‘field list’ #0 /home/jaspservices/services.jasp-stats.org/piwik/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/jaspservices/services.jasp-stats.org/piwik/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /home/jaspservices/services.jasp-stats.org/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/jaspservices/services.jasp-stats.org/piwik/core/Db/Adapter/Pdo/Mysql.php(233): Zend_Db_Adapter_Pdo_Abstract->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array) #4 /home/jaspservices/services.jasp-stats.org/piwik/core/DataAccess/LogAggregator.php(324): Piwik\Db\Adapter\Pdo\Mysql->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array) #5 /home/jaspservices/services.jasp-stats.org/piwik/plugins/UserLanguage/Archiver.php(65): Piwik\DataAccess\LogAggregator->queryVisitsByDimension(Array) #6 /home/jaspservices/services.jasp-stats.org/piwik/plugins/UserLanguage/Archiver.php(38): Piwik\Plugins\UserLanguage\Archiver->aggregateByLanguage() #7 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/PluginsArchiver.php(108): Piwik\Plugins\UserLanguage\Archiver->aggregateDayReport() #8 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/Loader.php(122): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins(‘92’, ‘0’) #9 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/Loader.php(72): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(false, false) #10 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(894): Piwik\ArchiveProcessor\Loader->prepareArchive(‘Referrers’) #11 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(708): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day)) #12 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(660): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array) #13 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(598): Piwik\Archive->getArchiveIds(Array) #14 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(369): Piwik\Archive->get(‘Referrers_keywo…’, ‘blob’, NULL) #15 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(460): Piwik\Archive->getDataTable(‘Referrers_keywo…’, NULL) #16 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(489): Piwik\Archive::getDataTableFromArchive(‘Referrers_keywo…’, ‘1’, ‘day’, ‘2015-07-08’, false, false, NULL, NULL) #17 /home/jaspservices/services.jasp-stats.org/piwik/plugins/Referrers/API.php(233): Piwik\Archive::createDataTableFromArchive(‘Referrers_keywo…’, ‘1’, ‘day’, ‘2015-07-08’, false, false, false) #18 [internal function]: Piwik\Plugins\Referrers\API->getSearchEngines(‘1’, ‘day’, ‘2015-07-08’, false, false, false) #19 /home/jaspservices/services.jasp-stats.org/piwik/core/API/Proxy.php(211): call_user_func_array(Array, Array) #20 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Visualization.php(259): Piwik\API\Proxy->call(’\Piwik\Plugins\…’, ‘getSearchEngine…’, Array) #21 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Visualization.php(180): Piwik\Plugin\Visualization->loadDataTableFromAPI() #22 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/ViewDataTable.php(414): Piwik\Plugin\Visualization->buildView() #23 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Report.php(338): Piwik\Plugin\ViewDataTable->render() #24 /home/jaspservices/services.jasp-stats.org/piwik/plugins/CoreHome/Controller.php(78): Piwik\Plugin\Report->render() #25 [internal function]: Piwik\Plugins\CoreHome\Controller->renderReportWidget(Object(Piwik\Plugins\Referrers\Reports\GetSearchEngines)) #26 /home/jaspservices/services.jasp-stats.org/piwik/core/FrontController.php(494): call_user_func_array(Array, Array) #27 /home/jaspservices/services.jasp-stats.org/piwik/core/FrontController.php(94): Piwik\FrontController->doDispatch(NULL, NULL, NULL) #28 /home/jaspservices/services.jasp-stats.org/piwik/core/dispatch.php(34): Piwik\FrontController->dispatch() #29 /home/jaspservices/services.jasp-stats.org/piwik/index.php(27): require_once(’/home/jaspservi…’) #30 {main}
ERROR: Failed to get data from API: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_visit.location_browser_lang’ in ‘field list’ #0 /home/jaspservices/services.jasp-stats.org/piwik/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/jaspservices/services.jasp-stats.org/piwik/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /home/jaspservices/services.jasp-stats.org/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/jaspservices/services.jasp-stats.org/piwik/core/Db/Adapter/Pdo/Mysql.php(233): Zend_Db_Adapter_Pdo_Abstract->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array) #4 /home/jaspservices/services.jasp-stats.org/piwik/core/DataAccess/LogAggregator.php(324): Piwik\Db\Adapter\Pdo\Mysql->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array) #5 /home/jaspservices/services.jasp-stats.org/piwik/plugins/UserLanguage/Archiver.php(65): Piwik\DataAccess\LogAggregator->queryVisitsByDimension(Array) #6 /home/jaspservices/services.jasp-stats.org/piwik/plugins/UserLanguage/Archiver.php(38): Piwik\Plugins\UserLanguage\Archiver->aggregateByLanguage() #7 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/PluginsArchiver.php(108): Piwik\Plugins\UserLanguage\Archiver->aggregateDayReport() #8 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/Loader.php(122): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins(‘92’, ‘0’) #9 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/Loader.php(72): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(false, false) #10 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(894): Piwik\ArchiveProcessor\Loader->prepareArchive(‘DevicesDetectio…’) #11 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(708): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day)) #12 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(660): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array) #13 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(598): Piwik\Archive->getArchiveIds(Array) #14 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(369): Piwik\Archive->get(‘DevicesDetectio…’, ‘blob’, NULL) #15 /home/jaspservices/services.jasp-stats.org/piwik/plugins/DevicesDetection/API.php(36): Piwik\Archive->getDataTable(‘DevicesDetectio…’) #16 /home/jaspservices/services.jasp-stats.org/piwik/plugins/DevicesDetection/API.php(236): Piwik\Plugins\DevicesDetection\API->getDataTable(‘DevicesDetectio…’, ‘1’, ‘day’, ‘2015-07-08’, false) #17 [internal function]: Piwik\Plugins\DevicesDetection\API->getBrowsers(‘1’, ‘day’, ‘2015-07-08’, false) #18 /home/jaspservices/services.jasp-stats.org/piwik/core/API/Proxy.php(211): call_user_func_array(Array, Array) #19 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Visualization.php(259): Piwik\API\Proxy->call(’\Piwik\Plugins\…’, ‘getBrowsers’, Array) #20 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Visualization.php(180): Piwik\Plugin\Visualization->loadDataTableFromAPI() #21 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/ViewDataTable.php(414): Piwik\Plugin\Visualization->buildView() #22 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Report.php(338): Piwik\Plugin\ViewDataTable->render() #23 /home/jaspservices/services.jasp-stats.org/piwik/plugins/CoreHome/Controller.php(78): Piwik\Plugin\Report->render() #24 [internal function]: Piwik\Plugins\CoreHome\Controller->renderReportWidget(Object(Piwik\Plugins\DevicesDetection\Reports\GetBrowsers)) #25 /home/jaspservices/services.jasp-stats.org/piwik/core/FrontController.php(494): call_user_func_array(Array, Array) #26 /home/jaspservices/services.jasp-stats.org/piwik/core/FrontController.php(94): Piwik\FrontController->doDispatch(NULL, NULL, NULL) #27 /home/jaspservices/services.jasp-stats.org/piwik/core/dispatch.php(34): Piwik\FrontController->dispatch() #28 /home/jaspservices/services.jasp-stats.org/piwik/index.php(27): require_once(’/home/jaspservi…’) #29 {main}
ERROR: Failed to get data from API: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_visit.location_browser_lang’ in ‘field list’ #0 /home/jaspservices/services.jasp-stats.org/piwik/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/jaspservices/services.jasp-stats.org/piwik/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /home/jaspservices/services.jasp-stats.org/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/jaspservices/services.jasp-stats.org/piwik/core/Db/Adapter/Pdo/Mysql.php(233): Zend_Db_Adapter_Pdo_Abstract->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array) #4 /home/jaspservices/services.jasp-stats.org/piwik/core/DataAccess/LogAggregator.php(324): Piwik\Db\Adapter\Pdo\Mysql->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array) #5 /home/jaspservices/services.jasp-stats.org/piwik/plugins/UserLanguage/Archiver.php(65): Piwik\DataAccess\LogAggregator->queryVisitsByDimension(Array) #6 /home/jaspservices/services.jasp-stats.org/piwik/plugins/UserLanguage/Archiver.php(38): Piwik\Plugins\UserLanguage\Archiver->aggregateByLanguage() #7 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/PluginsArchiver.php(108): Piwik\Plugins\UserLanguage\Archiver->aggregateDayReport() #8 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/Loader.php(122): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins(‘92’, ‘0’) #9 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/Loader.php(72): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(false, false) #10 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(894): Piwik\ArchiveProcessor\Loader->prepareArchive(‘VisitorInterest’) #11 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(708): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day)) #12 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(660): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array) #13 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(598): Piwik\Archive->getArchiveIds(Array) #14 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(369): Piwik\Archive->get(‘VisitorInterest…’, ‘blob’, NULL) #15 /home/jaspservices/services.jasp-stats.org/piwik/plugins/VisitorInterest/API.php(28): Piwik\Archive->getDataTable(‘VisitorInterest…’) #16 /home/jaspservices/services.jasp-stats.org/piwik/plugins/VisitorInterest/API.php(35): Piwik\Plugins\VisitorInterest\API->getDataTable(‘VisitorInterest…’, ‘1’, ‘day’, ‘2015-07-08’, false) #17 [internal function]: Piwik\Plugins\VisitorInterest\API->getNumberOfVisitsPerVisitDuration(‘1’, ‘day’, ‘2015-07-08’, false) #18 /home/jaspservices/services.jasp-stats.org/piwik/core/API/Proxy.php(211): call_user_func_array(Array, Array) #19 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Visualization.php(259): Piwik\API\Proxy->call(’\Piwik\Plugins\…’, ‘getNumberOfVisi…’, Array) #20 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Visualization.php(180): Piwik\Plugin\Visualization->loadDataTableFromAPI() #21 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/ViewDataTable.php(414): Piwik\Plugin\Visualization->buildView() #22 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Report.php(338): Piwik\Plugin\ViewDataTable->render() #23 /home/jaspservices/services.jasp-stats.org/piwik/plugins/CoreHome/Controller.php(78): Piwik\Plugin\Report->render() #24 [internal function]: Piwik\Plugins\CoreHome\Controller->renderReportWidget(Object(Piwik\Plugins\VisitorInterest\Reports\GetNumberOfVisitsPerVisitDuration)) #25 /home/jaspservices/services.jasp-stats.org/piwik/core/FrontController.php(494): call_user_func_array(Array, Array) #26 /home/jaspservices/services.jasp-stats.org/piwik/core/FrontController.php(94): Piwik\FrontController->doDispatch(NULL, NULL, NULL) #27 /home/jaspservices/services.jasp-stats.org/piwik/core/dispatch.php(34): Piwik\FrontController->dispatch() #28 /home/jaspservices/services.jasp-stats.org/piwik/index.php(27): require_once(’/home/jaspservi…’) #29 {main}
ERROR: Failed to get data from API: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_visit.location_browser_lang’ in ‘field list’ #0 /home/jaspservices/services.jasp-stats.org/piwik/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/jaspservices/services.jasp-stats.org/piwik/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /home/jaspservices/services.jasp-stats.org/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/jaspservices/services.jasp-stats.org/piwik/core/Db/Adapter/Pdo/Mysql.php(233): Zend_Db_Adapter_Pdo_Abstract->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array) #4 /home/jaspservices/services.jasp-stats.org/piwik/core/DataAccess/LogAggregator.php(324): Piwik\Db\Adapter\Pdo\Mysql->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array) #5 /home/jaspservices/services.jasp-stats.org/piwik/plugins/UserLanguage/Archiver.php(65): Piwik\DataAccess\LogAggregator->queryVisitsByDimension(Array) #6 /home/jaspservices/services.jasp-stats.org/piwik/plugins/UserLanguage/Archiver.php(38): Piwik\Plugins\UserLanguage\Archiver->aggregateByLanguage() #7 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/PluginsArchiver.php(108): Piwik\Plugins\UserLanguage\Archiver->aggregateDayReport() #8 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/Loader.php(122): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins(‘92’, ‘0’) #9 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/Loader.php(72): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(false, false) #10 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(894): Piwik\ArchiveProcessor\Loader->prepareArchive(‘VisitsSummary’) #11 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(708): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day)) #12 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(660): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array) #13 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(598): Piwik\Archive->getArchiveIds(Array) #14 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(324): Piwik\Archive->get(Array, ‘numeric’) #15 /home/jaspservices/services.jasp-stats.org/piwik/plugins/VisitsSummary/API.php(35): Piwik\Archive->getDataTableFromNumeric(Array) #16 [internal function]: Piwik\Plugins\VisitsSummary\API->get(‘1’, ‘day’, ‘2015-06-09,2015…’, false, ‘nb_uniq_visitor…’) #17 /home/jaspservices/services.jasp-stats.org/piwik/core/API/Proxy.php(211): call_user_func_array(Array, Array) #18 /home/jaspservices/services.jasp-stats.org/piwik/plugins/API/API.php(405): Piwik\API\Proxy->call(’\Piwik\Plugins\…’, ‘get’, Array) #19 [internal function]: Piwik\Plugins\API\API->get(‘1’, ‘day’, ‘2015-06-09,2015…’, false, Array) #20 /home/jaspservices/services.jasp-stats.org/piwik/core/API/Proxy.php(211): call_user_func_array(Array, Array) #21 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Visualization.php(259): Piwik\API\Proxy->call(’\Piwik\Plugins\…’, ‘get’, Array) #22 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Visualization.php(180): Piwik\Plugin\Visualization->loadDataTableFromAPI() #23 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/ViewDataTable.php(414): Piwik\Plugin\Visualization->buildView() #24 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Controller.php(248): Piwik\Plugin\ViewDataTable->render() #25 /home/jaspservices/services.jasp-stats.org/piwik/plugins/VisitsSummary/Controller.php(126): Piwik\Plugin\Controller->renderView(Object(Piwik\Plugins\CoreVisualizations\Visualizations\JqplotGraph\Evolution)) #26 [internal function]: Piwik\Plugins\VisitsSummary\Controller->getEvolutionGraph() #27 /home/jaspservices/services.jasp-stats.org/piwik/core/FrontController.php(494): call_user_func_array(Array, Array) #28 /home/jaspservices/services.jasp-stats.org/piwik/core/FrontController.php(94): Piwik\FrontController->doDispatch(NULL, NULL, NULL) #29 /home/jaspservices/services.jasp-stats.org/piwik/core/dispatch.php(34): Piwik\FrontController->dispatch() #30 /home/jaspservices/services.jasp-stats.org/piwik/index.php(27): require_once(’/home/jaspservi…’) #31 {main}
ERROR: Failed to get data from API: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_visit.location_browser_lang’ in ‘field list’ #0 /home/jaspservices/services.jasp-stats.org/piwik/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/jaspservices/services.jasp-stats.org/piwik/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /home/jaspservices/services.jasp-stats.org/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/jaspservices/services.jasp-stats.org/piwik/core/Db/Adapter/Pdo/Mysql.php(233): Zend_Db_Adapter_Pdo_Abstract->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array) #4 /home/jaspservices/services.jasp-stats.org/piwik/core/DataAccess/LogAggregator.php(324): Piwik\Db\Adapter\Pdo\Mysql->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array) #5 /home/jaspservices/services.jasp-stats.org/piwik/plugins/UserLanguage/Archiver.php(65): Piwik\DataAccess\LogAggregator->queryVisitsByDimension(Array) #6 /home/jaspservices/services.jasp-stats.org/piwik/plugins/UserLanguage/Archiver.php(38): Piwik\Plugins\UserLanguage\Archiver->aggregateByLanguage() #7 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/PluginsArchiver.php(108): Piwik\Plugins\UserLanguage\Archiver->aggregateDayReport() #8 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/Loader.php(122): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins(‘92’, ‘0’) #9 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/Loader.php(72): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(false, false) #10 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(894): Piwik\ArchiveProcessor\Loader->prepareArchive(‘Referrers’) #11 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(708): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day)) #12 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(660): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array) #13 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(598): Piwik\Archive->getArchiveIds(Array) #14 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(369): Piwik\Archive->get(‘Referrers_urlBy…’, ‘blob’, NULL) #15 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(460): Piwik\Archive->getDataTable(‘Referrers_urlBy…’, NULL) #16 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(489): Piwik\Archive::getDataTableFromArchive(‘Referrers_urlBy…’, ‘1’, ‘day’, ‘2015-07-08’, false, false, NULL, NULL) #17 /home/jaspservices/services.jasp-stats.org/piwik/plugins/Referrers/API.php(280): Piwik\Archive::createDataTableFromArchive(‘Referrers_urlBy…’, ‘1’, ‘day’, ‘2015-07-08’, false, false, false, NULL) #18 [internal function]: Piwik\Plugins\Referrers\API->getWebsites(‘1’, ‘day’, ‘2015-07-08’, false, false, false) #19 /home/jaspservices/services.jasp-stats.org/piwik/core/API/Proxy.php(211): call_user_func_array(Array, Array) #20 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Visualization.php(259): Piwik\API\Proxy->call(’\Piwik\Plugins\…’, ‘getWebsites’, Array) #21 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Visualization.php(180): Piwik\Plugin\Visualization->loadDataTableFromAPI() #22 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/ViewDataTable.php(414): Piwik\Plugin\Visualization->buildView() #23 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Report.php(338): Piwik\Plugin\ViewDataTable->render() #24 /home/jaspservices/services.jasp-stats.org/piwik/plugins/CoreHome/Controller.php(78): Piwik\Plugin\Report->render() #25 [internal function]: Piwik\Plugins\CoreHome\Controller->renderReportWidget(Object(Piwik\Plugins\Referrers\Reports\GetWebsites)) #26 /home/jaspservices/services.jasp-stats.org/piwik/core/FrontController.php(494): call_user_func_array(Array, Array) #27 /home/jaspservices/services.jasp-stats.org/piwik/core/FrontController.php(94): Piwik\FrontController->doDispatch(NULL, NULL, NULL) #28 /home/jaspservices/services.jasp-stats.org/piwik/core/dispatch.php(34): Piwik\FrontController->dispatch() #29 /home/jaspservices/services.jasp-stats.org/piwik/index.php(27): require_once(’/home/jaspservi…’) #30 {main}
ERROR: Failed to get data from API: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_visit.location_browser_lang’ in ‘field list’ #0 /home/jaspservices/services.jasp-stats.org/piwik/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/jaspservices/services.jasp-stats.org/piwik/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /home/jaspservices/services.jasp-stats.org/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/jaspservices/services.jasp-stats.org/piwik/core/Db/Adapter/Pdo/Mysql.php(233): Zend_Db_Adapter_Pdo_Abstract->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array) #4 /home/jaspservices/services.jasp-stats.org/piwik/core/DataAccess/LogAggregator.php(324): Piwik\Db\Adapter\Pdo\Mysql->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array) #5 /home/jaspservices/services.jasp-stats.org/piwik/plugins/UserLanguage/Archiver.php(65): Piwik\DataAccess\LogAggregator->queryVisitsByDimension(Array) #6 /home/jaspservices/services.jasp-stats.org/piwik/plugins/UserLanguage/Archiver.php(38): Piwik\Plugins\UserLanguage\Archiver->aggregateByLanguage() #7 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/PluginsArchiver.php(108): Piwik\Plugins\UserLanguage\Archiver->aggregateDayReport() #8 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/Loader.php(122): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins(‘92’, ‘0’) #9 /home/jaspservices/services.jasp-stats.org/piwik/core/ArchiveProcessor/Loader.php(72): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(false, false) #10 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(894): Piwik\ArchiveProcessor\Loader->prepareArchive(‘VisitTime’) #11 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(708): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day)) #12 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(660): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array) #13 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(598): Piwik\Archive->getArchiveIds(Array) #14 /home/jaspservices/services.jasp-stats.org/piwik/core/Archive.php(369): Piwik\Archive->get(‘VisitTime_serve…’, ‘blob’, NULL) #15 /home/jaspservices/services.jasp-stats.org/piwik/plugins/VisitTime/API.php(34): Piwik\Archive->getDataTable(‘VisitTime_serve…’) #16 /home/jaspservices/services.jasp-stats.org/piwik/plugins/VisitTime/API.php(52): Piwik\Plugins\VisitTime\API->getDataTable(‘VisitTime_serve…’, ‘1’, ‘day’, ‘2015-07-08’, false) #17 [internal function]: Piwik\Plugins\VisitTime\API->getVisitInformationPerServerTime(‘1’, ‘day’, ‘2015-07-08’, false, ‘1’) #18 /home/jaspservices/services.jasp-stats.org/piwik/core/API/Proxy.php(211): call_user_func_array(Array, Array) #19 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Visualization.php(259): Piwik\API\Proxy->call(’\Piwik\Plugins\…’, ‘getVisitInforma…’, Array) #20 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Visualization.php(180): Piwik\Plugin\Visualization->loadDataTableFromAPI() #21 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/ViewDataTable.php(414): Piwik\Plugin\Visualization->buildView() #22 /home/jaspservices/services.jasp-stats.org/piwik/core/Plugin/Report.php(338): Piwik\Plugin\ViewDataTable->render() #23 /home/jaspservices/services.jasp-stats.org/piwik/plugins/CoreHome/Controller.php(78): Piwik\Plugin\Report->render() #24 [internal function]: Piwik\Plugins\CoreHome\Controller->renderReportWidget(Object(Piwik\Plugins\VisitTime\Reports\GetVisitInformationPerServerTime)) #25 /home/jaspservices/services.jasp-stats.org/piwik/core/FrontController.php(494): call_user_func_array(Array, Array) #26 /home/jaspservices/services.jasp-stats.org/piwik/core/FrontController.php(94): Piwik\FrontController->doDispatch(NULL, NULL, NULL) #27 /home/jaspservices/services.jasp-stats.org/piwik/core/dispatch.php(34): Piwik\FrontController->dispatch() #28 /home/jaspservices/services.jasp-stats.org/piwik/index.php(27): require_once(’/home/jaspservi…’) #29 {main}
WARNING: /home/jaspservices/services.jasp-stats.org/piwik/plugins/DevicesDetection/Visitor.php(94): Notice - Undefined index: config_browser_name - Piwik 2.14.0 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING: /home/jaspservices/services.jasp-stats.org/piwik/plugins/DevicesDetection/Visitor.php(94): Notice - Undefined index: config_browser_version - Piwik 2.14.0 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING: /home/jaspservices/services.jasp-stats.org/piwik/plugins/DevicesDetection/Visitor.php(99): Notice - Undefined index: config_browser_name - Piwik 2.14.0 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING: /home/jaspservices/services.jasp-stats.org/piwik/plugins/DevicesDetection/Visitor.php(89): Notice - Undefined index: config_browser_version - Piwik 2.14.0 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING: /home/jaspservices/services.jasp-stats.org/piwik/plugins/DevicesDetection/Visitor.php(89): Notice - Undefined index: config_browser_name - Piwik 2.14.0 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING: /home/jaspservices/services.jasp-stats.org/piwik/plugins/DevicesDetection/Visitor.php(64): Notice - Undefined index: config_os - Piwik 2.14.0 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING: /home/jaspservices/services.jasp-stats.org/piwik/plugins/DevicesDetection/Visitor.php(44): Notice - Undefined index: config_os - Piwik 2.14.0 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING: /home/jaspservices/services.jasp-stats.org/piwik/plugins/DevicesDetection/Visitor.php(99): Notice - Undefined index: config_browser_version - Piwik 2.14.0 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING: /home/jaspservices/services.jasp-stats.org/piwik/plugins/DevicesDetection/Visitor.php(79): Notice - Undefined index: config_browser_name - Piwik 2.14.0 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING: /home/jaspservices/services.jasp-stats.org/piwik/plugins/DevicesDetection/Visitor.php(54): Notice - Undefined index: config_os - Piwik 2.14.0 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING: /home/jaspservices/services.jasp-stats.org/piwik/plugins/DevicesDetection/Visitor.php(64): Notice - Undefined index: config_os - Piwik 2.14.0 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING: /home/jaspservices/services.jasp-stats.org/piwik/plugins/DevicesDetection/Visitor.php(44): Notice - Undefined index: config_os - Piwik 2.14.0 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING: /home/jaspservices/services.jasp-stats.org/piwik/plugins/DevicesDetection/Visitor.php(49): Notice - Undefined index: config_os - Piwik 2.14.0 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING: /home/jaspservices/services.jasp-stats.org/piwik/plugins/UserLanguage/Visitor.php(29): Notice - Undefined index: location_browser_lang - Piwik 2.14.0 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)

I have a very big problem too since this update !!

Look at this : 301 Moved Permanently

I also have


WARNING: /var/www/other/p1w1k/plugins/DevicesDetection/Visitor.php(94): Notice - Undefined index: config_browser_version - Piwik 2.14.0 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)

In addition browser and OS icons don 't show on the dashboard:

This upgrade was tragic…

Which version did you upgrade from?

anyway try deactivate - reactivate the UserLanguage plugin, maybe it will help?

Which version did you upgrade from?

2.13.1

nyway try deactivate - reactivate the UserLanguage plugin, maybe it will help?

No, unfortunately it does not help.

Also, I checked the not displaying images - it appears that they are displayed, but the white squares mean “Unknown”. They were “known” before the upgrade.

Hello
same problem …
I have deactived DevicesDetection and UserLanguage plugins, no error in UI but piwik don’t log (piwik_log_visit and piwik_log_link_visit_action are not growing).

Stéphane

In piwik =< 2.13.1, schema database is in core/DB/Schema/Myisam.php
In piwik >= 2.14.0, schema database is in core/DB/Schema/Mysql.php
when following Update Piwik - Analytics Platform - Matomo, unpacking zip archive add Mysql.php but an old Myisam.php is still present … maybe …

Stéphane

[Edit] : after restoring backup, automatic update was ok … bizarre

Same Problem with

mod_fcgid: stderr: Error in Piwik (tracker): Error query: SQLSTATE[42S22]:
Column not found: 1054 Unknown column ‘location_browser_lang’ in 'field list’
In query: SELECT visit_last_action_time, visit_first_action_time, idvisitor,
idvisit, user_id, visit_exit_idaction_url, visit_exit_idaction_name, visitor_returning,
visitor_days_since_first, visitor_days_since_order, visitor_count_visits, visit_goal_buyer,
location_country, location_region, location_city, location_latitude, location_longitude,
referer_name, referer_keyword, referer_type, location_ip, location_browser_lang,
visit_total_events, visit_total_time, visit_total_actions, visit_total_searches ,
custom_var_k1, custom_var_v1, custom_var_k2, custom_var_v2, custom_var_k3, custom_var_v3,
custom_var_k4, custom_var_v4, custom_var_k5, custom_var_v5
FROM stat_log_visit WHERE visit_last_action_time >= ? AND visit_last_action_time
<= ? AND idsite = ? AND idvisitor = ? ORDER BY visit_last_action_time DESC
LIMIT 1
Parameters: array ( 0 => ‘2015-07-09 09:25:06’, 1 => ‘2015-07-09 10:25:06’, 2 => 2,
3 => ‘(\x9a\xf5O tV\xd4’, ), referer: http://

Following workaround seams to help me:

ALTER TABLE stat_log_visit ADD COLUMN location_browser_lang VARCHAR(20) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_os char(3) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_browser_name varchar(10) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_browser_version varchar(20) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_resolution varchar(9) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_pdf tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_flash tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_director tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_quicktime tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_realplayer tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_windowsmedia tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_gears tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_silverlight tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_java tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_cookie tinyint(1) NOT NULL;

Hans

Thanks for the report! I created a ticket at: Column not found: 1054 Unknown column 'log_visit.location_browser_lang' in 'field list'" · Issue #8304 · matomo-org/piwik · GitHub

Hopefully we will find the problem and fix it in a future version.

Hi there,

I have the same problem after the upgrade from 2.13.1 to 2.14.0
First I used the automatically upgrade and after this failed I transfered the piwik-files over ftp (in binary mode) to the server and I still get the message:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_visit.location_browser_lang’ in 'field list’
if I call the dashboard

I have a similar problem following an automatic upgrade.
Could this workaround potentially conflict with any future official fix? If I backup the db before applying the workaround to get Piwik working, will restoring the backup before applying any future official fix lose all visitors’ data collected in the interim?

Han’s fix [appears to have] worked for me!

http://forum.piwik.org/read.php?2,127838,page=1#msg-127877

thanks Han!

sorry, I´m a beginner. I don´t understand the workaround. What must I do?

Me too, any support please?

Hhmm I have the same problem but I have no idea how to solve or implement the workaround.

I also saw some message in the admin stating the file integrity is not ok:

bestandsgrootte klopt niet: /home/hmestrum/domains/hansmestrum.nl/public_html/statistics/core/Updates/1.8.3-b1.php (verwachte grootte: 4214, gevonden: 4228)

Hans, thank you.
Your work around worked for me.(:smiley:

For the beginners:

1 Go to your MySQL database
(for example with phpmyadmin)

  1. Click the SQL tab or SQL command button

  2. Copy paste the code below in the text field

  3. Click start/run/execute

stat_ is the table prefix in this case, change it to your table prefix.

For example in my case the prefix is piwik, all the stat has to be changed in prefix:

ALTER TABLE stat_log_visit ADD COLUMN location_browser_lang VARCHAR(20) NOT NULL;
will become:
ALTER TABLE piwik_log_visit ADD COLUMN location_browser_lang VARCHAR(20) NOT NULL;

Good luck.

ALTER TABLE stat_log_visit ADD COLUMN location_browser_lang VARCHAR(20) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_os char(3) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_browser_name varchar(10) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_browser_version varchar(20) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_resolution varchar(9) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_pdf tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_flash tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_director tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_quicktime tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_realplayer tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_windowsmedia tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_gears tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_silverlight tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_java tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_cookie tinyint(1) NOT NULL;

Yessss!!! That did the trick! Thx.

+1
In combination with deleting and re-uploading of some plugins (LanguagesManager, UserLanguage)
:slight_smile:

Update:
On dashboard view:
-> the grapgh widget for last visits doesn’t show any visits.
-> the widget visitors in real time does show visits!
But as I mentioned, the tracking is back up working (as I can see visitors in the visitors-log).

On another upgraded Piwik system, I do only have visitors shown in the dahboard widget "visitors in real time"
All other stuff in the main meu “Visitors” doesn’t show any tracking data. And also no error etc.

Wired.::o

@Barcelo

The same here:
-> the graph widget for last visits doesn’t show any visits.
-> the widget visitors in real time does show visits!

But this is only on sites with: Archive reports when viewed from the browser: "no ". When I put it on “yes” the graph is generated well.