search

YunoHost-Apps / matomo_ynh

Matomo package for YunoHost
https://matomo.org/
GNU General Public License v3.0
19 stars 6 forks source link

Column not found: 1054 after update to 4.0.5 #25

Closed b4D8 closed 3 years ago

b4D8 commented 3 years ago

Describe the bug I updated from 3.14.1 to 4.0.5 from the webadmin then logged to my matomo instance, upgraded the database through the browser and found the following error in tabs in the dashboard:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'log_visit.config_director' in 'field list' - in plugin DevicePlugins.

Versions

To Reproduce Updated to 4.0.5

Expected behavior No error

Logs Received from Cron Deamon:

ERROR [2020-12-10 00:05:03] 3005  Got invalid response from API request: ?module=API&method=CoreAdminHome.archiveReports&idSite=2&period=day&date=2020-12-09&format=json&trigger=archivephp. Response was '{"result":"error","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'log_visit.config_director' in 'field list' - in plugin DevicePlugins. #0 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(206): Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins('9', '0', false) #1 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(147): Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive('9', '0') #2 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(96): Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl(false) #3 \/var\/www\/dbuser\/core\/Context.php(75): Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}() #4 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(97): Piwik\\Context::changeIdSite(2, Object(Closure))
  #5 \/var\/www\/dbuser\/plugins\/CoreAdminHome\/API.php(278): Piwik\\ArchiveProcessor\\Loader->prepareArchive(false) #6 [internal function]: Piwik\\Plugins\\CoreAdminHome\\API->archiveReports('2', Object(Piwik\\Period\\Day), '2020-12-09', false, false, false) #7 \/var\/www\/dbuser\/core\/API\/Proxy.php(244): call_user_func_array(Array, Array) #8 \/var\/www\/dbuser\/core\/Context.php(28): Piwik\\API\\Proxy->Piwik\\API\\{closure}() #9 \/var\/www\/dbuser\/core\/API\/Proxy.php(335): Piwik\\Context::executeWithQueryParameters(Array, Object(Closure)) #10 \/var\/www\/dbuser\/core\/API\/Request.php(266): Piwik\\API\\Proxy->call('\\\\Piwik\\\\Plugins\\\\...', 'archiveReports', Array) #11 \/var\/www\/dbuser\/plugins\/API\/Controller.php(46): Piwik\\API\\Request->process() #12 [internal function]: Piwik\\Plugins\\API\\Controller->index() #13 \/var\/www\/dbuser\/core\/FrontController.php(605): call_user_func_array(Array, Array) #14 \/var\/www\/dbuser\/core\/FrontController.php
 (166): Piwik\\FrontController->doDispatch('API', false, Array) #15 \/var\/www\/dbuser\/core\/dispatch.php(32): Piwik\\FrontController->dispatch() #16 \/var\/www\/dbuser\/index.php(25): require_once('\/var\/www\/dbuser...') #17 \/var\/www\/dbuser\/core\/CliMulti\/RequestCommand.php(79): require_once('\/var\/www\/dbuser...') #18 \/var\/www\/dbuser\/vendor\/symfony\/console\/Symfony\/Component\/Console\/Command\/Command.php(257): Piwik\\CliMulti\\RequestCommand->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #19 \/var\/www\/dbuser\/vendor\/symfony\/console\/Symfony\/Component\/Console\/Application.php(874): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #20 \/var\/www\/dbuser\/vendor\/symfony\/console\/Symfony\/Component\/Console\/Application.php(195): Symfony\\Component\\Console\\A
 pplication->doRunCommand(Object(Piwik\\CliMulti\\RequestCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #21 [internal function]: Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #22 \/var\/www\/dbuser\/core\/Console.php(130): call_user_func(Array, Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #23 \/var\/www\/dbuser\/core\/Access.php(673): Piwik\\Console->Piwik\\{closure}() #24 \/var\/www\/dbuser\/core\/Console.php(131): Piwik\\Access::doAsSuperUser(Object(Closure)) #25 \/var\/www\/dbuser\/core\/Console.php(82): Piwik\\Console->doRunImpl(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #26 \/var\/www\/dbuser\/vendor\/symfony\/console\/Symfony\/Componen
 t\/Console\/Application.php(126): Piwik\\Console->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #27 \/var\/www\/dbuser\/console(32): Symfony\\Component\\Console\\Application->run() #28 {main}, caused by: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'log_visit.config_director' in 'field list' #0 \/var\/www\/dbuser\/libs\/Zend\/Db\/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 \/var\/www\/dbuser\/libs\/Zend\/Db\/Adapter\/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 \/var\/www\/dbuser\/libs\/Zend\/Db\/Adapter\/Pdo\/Abstract.php(238): Zend_Db_Adapter_Abstract->query('\/* trigger = Cr...', Array) #3 \/var\/www\/dbuser\/core\/Db\/Adapter\/Pdo\/Mysql.php(309): Zend_Db_Adapter_Pdo_Abstract->query('\/* trigger = Cr...', Array) #4 [internal function]: Piwik\\Db\\Adapter\\Pdo\\Mysql->query('\/* trigger = Cr...', Array) #5 \/var\/www\/dbuser\/core\/DataAccess\/Arc
 hivingDbAdapter.php(59): call_user_func_array(Array, Array) #6 \/var\/www\/dbuser\/core\/DataAccess\/LogAggregator.php(591): Piwik\\DataAccess\\ArchivingDbAdapter->query('\/* trigger = Cr...', Array) #7 \/var\/www\/dbuser\/plugins\/DevicePlugins\/Archiver.php(73): Piwik\\DataAccess\\LogAggregator->queryVisitsByDimension(Array, 'log_visit.visit...', Array, Array) #8 \/var\/www\/dbuser\/plugins\/DevicePlugins\/Archiver.php(33): Piwik\\Plugins\\DevicePlugins\\Archiver->aggregateByPlugin() #9 \/var\/www\/dbuser\/core\/Plugin\/Archiver.php(89): Piwik\\Plugins\\DevicePlugins\\Archiver->aggregateDayReport() #10 \/var\/www\/dbuser\/core\/ArchiveProcessor\/PluginsArchiver.php(164): Piwik\\Plugin\\Archiver->callAggregateDayReport() #11 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(206): Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins('9', '0', false) #12 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Lo ... n#39 \/var\/www\/dbuser\/console(32): Symfon
 y\\Component\\Console\\Application->run()\n#40 {main}"}'
ERROR [2020-12-10 00:05:03] 3005  Got invalid response from API request: ?module=API&method=CoreAdminHome.archiveReports&idSite=2&period=week&date=2020-12-07&format=json&trigger=archivephp. Response was '{"result":"error","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'log_visit.config_director' in 'field list' - in plugin DevicePlugins. #0 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(206): Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins('9', '0', false) #1 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(147): Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive('9', '0') #2 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(96): Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl('VisitsSummary') #3 \/var\/www\/dbuser\/core\/Context.php(75): Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}() #4 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(97): Piwik\\Context::changeIdSite(2, Objec
 t(Closure)) #5 \/var\/www\/dbuser\/plugins\/CoreAdminHome\/API.php(278): Piwik\\ArchiveProcessor\\Loader->prepareArchive('VisitsSummary') #6 \/var\/www\/dbuser\/core\/Archive.php(815): Piwik\\Plugins\\CoreAdminHome\\API->archiveReports(2, Object(Piwik\\Period\\Day), '2020-12-09', '', 'VisitsSummary', '') #7 \/var\/www\/dbuser\/core\/Archive.php(614): Piwik\\Archive->prepareArchive(Array, Object(Piwik\\Site), Object(Piwik\\Period\\Day)) #8 \/var\/www\/dbuser\/core\/Archive.php(561): Piwik\\Archive->cacheArchiveIdsAfterLaunching(Array, Array) #9 \/var\/www\/dbuser\/core\/Archive.php(489): Piwik\\Archive->getArchiveIds(Array) #10 \/var\/www\/dbuser\/core\/Archive.php(304): Piwik\\Archive->get(Array, 'numeric') #11 \/var\/www\/dbuser\/core\/ArchiveProcessor.php(601): Piwik\\Archive->getDataTableFromNumeric(Array) #12 \/var\/www\/dbuser\/core\/ArchiveProcessor.php(247): Piwik\\ArchiveProcessor->getAggregatedNumericMetrics(Array, false) #13 \/var\/www\/dbuser\/core
 \/ArchiveProcessor\/PluginsArchiver.php(306): Piwik\\ArchiveProcessor->aggregateNumericMetrics(Array) #14 \/var\/www\/dbuser\/core\/ArchiveProcessor\/PluginsArchiver.php(104): Piwik\\ArchiveProcessor\\PluginsArchiver->aggregateMultipleVisitsMetrics() #15 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(200): Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateCoreMetrics() #16 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(147): Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive('48', 0) #17 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(96): Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl(false) #18 \/var\/www\/dbuser\/core\/Context.php(75): Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}() #19 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(97): Piwik\\Context::changeIdSite(2, Object(Closure)) #20 \/var\/www\/dbuser\/plugins\/CoreAdminHome\/API.php(278): Piwik\\ArchiveProcessor\\Loader->prepareArch
 ive(false) #21 [internal function]: Piwik\\Plugins\\CoreAdminHome\\API->archiveReports('2', Object(Piwik\\Period\\Week), '2020-12-07', false, false, false) #22 \/var\/www\/dbuser\/core\/API\/Proxy.php(244): call_user_func_array(Array, Array) #23 \/var\/www\/dbuser\/core\/Context.php(28): Piwik\\API\\Proxy->Piwik\\API\\{closure}() #24 \/var\/www\/dbuser\/core\/API\/Proxy.php(335): Piwik\\Context::executeWithQueryParameters(Array, Object(Closure)) #25 \/var\/www\/dbuser\/core\/API\/Request.php(266): Piwik\\API\\Proxy->call('\\\\Piwik\\\\Plugins\\\\...', 'archiveReports', Array) #26 \/var\/www\/dbuser\/plugins\/API\/Controller.php(46): Piwik\\API\\Request->process() #27 [internal function]: Piwik\\Plugins\\API\\Controller->index() #28 \/var\/www\/dbuser\/core\/FrontController.php(605): call_user_func_array(Array, Array) #29 \/var\/www\/dbuser\/core\/FrontController.php(166): Piwik\\FrontController->doDispatch('API', false, Array) #30 \/var\/www\/dbuser\/core\/dispatch
 .php(32): Piwik\\FrontController->dispatch() #31 \/var\/www\/dbuser\/index.php(25): require_once('\/var\/www\/dbuser...') #32 \/var\/www\/dbuser\/core\/CliMulti\/RequestCommand.php(79): require_once('\/var\/www\/dbuser...') #33 \/var\/www\/dbuser\/vendor\/symfony\/console\/Symfony\/Component\/Console\/Command\/Command.php(257): Piwik\\CliMulti\\RequestCommand->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #34 \/var\/www\/dbuser\/vendor\/symfony\/console\/Symfony\/Component\/Console\/Application.php(874): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #35 \/var\/www\/dbuser\/vendor\/symfony\/console\/Symfony\/Component\/Console\/Application.php(195): Symfony\\Component\\Console\\Application->doRunCommand(Object(Piwik\\CliMulti\\RequestCommand), Object(Symfony\\Component\\Console\
 \Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #36 [internal function]: Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #37 \/var\/www\/dbuser\/core\/Console.php(130): call_user_func(Array, Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #38 \/var\/www\/dbuser\/core\/Access.php(673): Piwik\\Console->Piwik\\{closure}() #39 \/var\/www\/dbuser\/core\/Console.php(131): Piwik\\Access::doAsSuperUser(Object(Closure)) #40 \/var\/www\/dbuser\/core\/Console.php(82): Piwik\\Console->doRunImpl(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #41 \/var\/www\/dbuser\/vendor\/symfony\/console\/Symfony\/Component\/Console\/Application.php(126): Piwik\\Console->do ... n#54 \/var\/www\/dbuser\/console(32): Symfon
 y\\Component\\Console\\Application->run()\n#55 {main}"}'
ERROR [2020-12-10 00:05:04] 3005  Got invalid response from API request: ?module=API&method=CoreAdminHome.archiveReports&idSite=2&period=month&date=2020-12-01&format=json&trigger=archivephp. Response was '{"result":"error","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'log_visit.config_director' in 'field list' - in plugin DevicePlugins. #0 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(206): Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins('9', '0', false) #1 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(147): Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive('9', '0') #2 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(96): Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl('VisitsSummary') #3 \/var\/www\/dbuser\/core\/Context.php(75): Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}() #4 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(97): Piwik\\Context::changeIdSite(2, Obje
 ct(Closure)) #5 \/var\/www\/dbuser\/plugins\/CoreAdminHome\/API.php(278): Piwik\\ArchiveProcessor\\Loader->prepareArchive('VisitsSummary') #6 \/var\/www\/dbuser\/core\/Archive.php(815): Piwik\\Plugins\\CoreAdminHome\\API->archiveReports(2, Object(Piwik\\Period\\Day), '2020-12-09', '', 'VisitsSummary', '') #7 \/var\/www\/dbuser\/core\/Archive.php(614): Piwik\\Archive->prepareArchive(Array, Object(Piwik\\Site), Object(Piwik\\Period\\Day)) #8 \/var\/www\/dbuser\/core\/Archive.php(561): Piwik\\Archive->cacheArchiveIdsAfterLaunching(Array, Array) #9 \/var\/www\/dbuser\/core\/Archive.php(489): Piwik\\Archive->getArchiveIds(Array) #10 \/var\/www\/dbuser\/core\/Archive.php(304): Piwik\\Archive->get(Array, 'numeric') #11 \/var\/www\/dbuser\/core\/ArchiveProcessor.php(601): Piwik\\Archive->getDataTableFromNumeric(Array) #12 \/var\/www\/dbuser\/core\/ArchiveProcessor.php(247): Piwik\\ArchiveProcessor->getAggregatedNumericMetrics(Array, false) #13 \/var\/www\/dbuser\/cor
 e\/ArchiveProcessor\/PluginsArchiver.php(306): Piwik\\ArchiveProcessor->aggregateNumericMetrics(Array) #14 \/var\/www\/dbuser\/core\/ArchiveProcessor\/PluginsArchiver.php(104): Piwik\\ArchiveProcessor\\PluginsArchiver->aggregateMultipleVisitsMetrics() #15 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(200): Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateCoreMetrics() #16 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(147): Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive(false, false) #17 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(96): Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl('VisitsSummary') #18 \/var\/www\/dbuser\/core\/Context.php(75): Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}() #19 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(97): Piwik\\Context::changeIdSite(2, Object(Closure)) #20 \/var\/www\/dbuser\/plugins\/CoreAdminHome\/API.php(278): Piwik\\ArchiveProcessor\\Loader
 ->prepareArchive('VisitsSummary') #21 \/var\/www\/dbuser\/core\/Archive.php(815): Piwik\\Plugins\\CoreAdminHome\\API->archiveReports(2, Object(Piwik\\Period\\Week), '2020-12-07', '', 'VisitsSummary', '') #22 \/var\/www\/dbuser\/core\/Archive.php(614): Piwik\\Archive->prepareArchive(Array, Object(Piwik\\Site), Object(Piwik\\Period\\Week)) #23 \/var\/www\/dbuser\/core\/Archive.php(561): Piwik\\Archive->cacheArchiveIdsAfterLaunching(Array, Array) #24 \/var\/www\/dbuser\/core\/Archive.php(489): Piwik\\Archive->getArchiveIds(Array) #25 \/var\/www\/dbuser\/core\/Archive.php(304): Piwik\\Archive->get(Array, 'numeric') #26 \/var\/www\/dbuser\/core\/ArchiveProcessor.php(601): Piwik\\Archive->getDataTableFromNumeric(Array) #27 \/var\/www\/dbuser\/core\/ArchiveProcessor.php(247): Piwik\\ArchiveProcessor->getAggregatedNumericMetrics(Array, false) #28 \/var\/www\/dbuser\/core\/ArchiveProcessor\/PluginsArchiver.php(306): Piwik\\ArchiveProcessor->aggregateNumericMetrics(
 Array) #29 \/var\/www\/dbuser\/core\/ArchiveProcessor\/PluginsArchiver.php(104): Piwik\\ArchiveProcessor\\PluginsArchiver->aggregateMultipleVisitsMetrics() #30 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(200): Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateCoreMetrics() #31 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(147): Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive('133', 0) #32 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(96): Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl(false) #33 \/var\/www\/dbuser\/core\/Context.php(75): Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}() #34 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(97): Piwik\\Context::changeIdSite(2, Object(Closure)) #35 \/var\/www\/dbuser\/plugins\/CoreAdminHome\/API.php(278): Piwik\\ArchiveProcessor\\Loader->prepareArchive(false) #36 [internal function]: Piwik\\Plugins\\CoreAdminHome\\API->archiveReports('2', Ob
 ject(Piwik\\Period\\Month), '2020-12-01', false, false, false) #37 \/var\/www\/dbuser\/core\/API\/Proxy.php(244): call_user_func_array(Array, Array) #38 \/var\/www\/dbuser\/core\/Context.php(28): Piwik\\API\\Proxy->Piwik\\API\\{closure}() #39 \/var\/www\/dbuser\/core\/API\/Proxy.php(335): Piwik\\Context::executeWithQueryParameters(Array, Object(Closure)) #40 \/var\/www\/dbuser\/core\/API\/Request.php(266): Piwik\\API\\Proxy->call('\\\\Piwik\\\\Plugins\\\\...', 'archiveReports', Array) #41 \/var\/www\/dbuser\/plugins\/API\/Controller.php(46): Piwik\\API\\Request->process() #42 [internal function]: Piwik\\Plugins\\API\\Controller->index() #43 \/var\/www\/dbuser\/core\/FrontController.php(605): call_user_func_array(Array, Array) #44 \/var\/www\/dbuser\/core\/FrontController.php(166): Piwik\\FrontController->doDispatch('API', false, Array) #45 \/var\/www\/dbuser\/core\/dispatch.php(32): Piwik\\FrontController->dispatch() ... n#69 \/var\/www\/dbuser\/console(32): Symfon
 y\\Component\\Console\\Application->run()\n#70 {main}"}'
ERROR [2020-12-10 00:05:05] 3005  Got invalid response from API request: ?module=API&method=CoreAdminHome.archiveReports&idSite=2&period=year&date=2020-01-01&format=json&trigger=archivephp. Response was '{"result":"error","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'log_visit.config_director' in 'field list' - in plugin DevicePlugins. #0 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(206): Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins('9', '0', false) #1 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(147): Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive('9', '0') #2 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(96): Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl('VisitsSummary') #3 \/var\/www\/dbuser\/core\/Context.php(75): Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}() #4 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(97): Piwik\\Context::changeIdSite(2, Objec
 t(Closure)) #5 \/var\/www\/dbuser\/plugins\/CoreAdminHome\/API.php(278): Piwik\\ArchiveProcessor\\Loader->prepareArchive('VisitsSummary') #6 \/var\/www\/dbuser\/core\/Archive.php(815): Piwik\\Plugins\\CoreAdminHome\\API->archiveReports(2, Object(Piwik\\Period\\Day), '2020-12-09', '', 'VisitsSummary', '') #7 \/var\/www\/dbuser\/core\/Archive.php(614): Piwik\\Archive->prepareArchive(Array, Object(Piwik\\Site), Object(Piwik\\Period\\Day)) #8 \/var\/www\/dbuser\/core\/Archive.php(561): Piwik\\Archive->cacheArchiveIdsAfterLaunching(Array, Array) #9 \/var\/www\/dbuser\/core\/Archive.php(489): Piwik\\Archive->getArchiveIds(Array) #10 \/var\/www\/dbuser\/core\/Archive.php(304): Piwik\\Archive->get(Array, 'numeric') #11 \/var\/www\/dbuser\/core\/ArchiveProcessor.php(601): Piwik\\Archive->getDataTableFromNumeric(Array) #12 \/var\/www\/dbuser\/core\/ArchiveProcessor.php(247): Piwik\\ArchiveProcessor->getAggregatedNumericMetrics(Array, false) #13 \/var\/www\/dbuser\/core
 \/ArchiveProcessor\/PluginsArchiver.php(306): Piwik\\ArchiveProcessor->aggregateNumericMetrics(Array) #14 \/var\/www\/dbuser\/core\/ArchiveProcessor\/PluginsArchiver.php(104): Piwik\\ArchiveProcessor\\PluginsArchiver->aggregateMultipleVisitsMetrics() #15 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(200): Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateCoreMetrics() #16 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(147): Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive(false, false) #17 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(96): Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl('VisitsSummary') #18 \/var\/www\/dbuser\/core\/Context.php(75): Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}() #19 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(97): Piwik\\Context::changeIdSite(2, Object(Closure)) #20 \/var\/www\/dbuser\/plugins\/CoreAdminHome\/API.php(278): Piwik\\ArchiveProcessor\\Loader-
 >prepareArchive('VisitsSummary') #21 \/var\/www\/dbuser\/core\/Archive.php(815): Piwik\\Plugins\\CoreAdminHome\\API->archiveReports(2, Object(Piwik\\Period\\Week), '2020-12-07', '', 'VisitsSummary', '') #22 \/var\/www\/dbuser\/core\/Archive.php(614): Piwik\\Archive->prepareArchive(Array, Object(Piwik\\Site), Object(Piwik\\Period\\Week)) #23 \/var\/www\/dbuser\/core\/Archive.php(561): Piwik\\Archive->cacheArchiveIdsAfterLaunching(Array, Array) #24 \/var\/www\/dbuser\/core\/Archive.php(489): Piwik\\Archive->getArchiveIds(Array) #25 \/var\/www\/dbuser\/core\/Archive.php(304): Piwik\\Archive->get(Array, 'numeric') #26 \/var\/www\/dbuser\/core\/ArchiveProcessor.php(601): Piwik\\Archive->getDataTableFromNumeric(Array) #27 \/var\/www\/dbuser\/core\/ArchiveProcessor.php(247): Piwik\\ArchiveProcessor->getAggregatedNumericMetrics(Array, false) #28 \/var\/www\/dbuser\/core\/ArchiveProcessor\/PluginsArchiver.php(306): Piwik\\ArchiveProcessor->aggregateNumericMetrics(A
 rray) #29 \/var\/www\/dbuser\/core\/ArchiveProcessor\/PluginsArchiver.php(104): Piwik\\ArchiveProcessor\\PluginsArchiver->aggregateMultipleVisitsMetrics() #30 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(200): Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateCoreMetrics() #31 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(147): Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive(false, false) #32 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(96): Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl('VisitsSummary') #33 \/var\/www\/dbuser\/core\/Context.php(75): Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}() #34 \/var\/www\/dbuser\/core\/ArchiveProcessor\/Loader.php(97): Piwik\\Context::changeIdSite(2, Object(Closure)) #35 \/var\/www\/dbuser\/plugins\/CoreAdminHome\/API.php(278): Piwik\\ArchiveProcessor\\Loader->prepareArchive('VisitsSummary') #36 \/var\/www\/dbuser\/core\/Archive.php(815): Piwik\\Plugins\
 \CoreAdminHome\\API->archiveReports(2, Object(Piwik\\Period\\Month), '2020-12-01', '', 'VisitsSummary', '') #37 \/var\/www\/dbuser\/core\/Archive.php(614): Piwik\\Archive->prepareArchive(Array, Object(Piwik\\Site), Object(Piwik\\Period\\Month)) #38 \/var\/www\/dbuser\/core\/Archive.php(561): Piwik\\Archive->cacheArchiveIdsAfterLaunching(Array, Array) #39 \/var\/www\/dbuser\/core\/Archive.php(489): Piwik\\Archive->getArchiveIds(Array) #40 \/var\/www\/dbuser\/core\/Archive.php(304): Piwik\\Archive->get(Array, 'numeric') #41 \/var\/www\/dbuser\/core\/ArchiveProcessor.php(601): Piwik\\Archive->getDataTableFromNumeric(Array) #42 \/var\/www\/dbuser\/core\/ArchiveProcessor.php(247): Piwik\\ArchiveProcessor->getAggregatedNumericMetrics(Array, false) #43 \/var\/www\/dbuser\/core\/ArchiveProcessor\/PluginsArchiver.php(306): Piwik\\ArchiveProcessor->aggregateNumericMetrics(Array) #44 \/var\/www\/dbuser\/core\/ArchiveProce ... n#84 \/var\/www\/dbuser\/console(32): Symfon
 y\\Component\\Console\\Application->run()\n#85 {main}"}'
ERROR [2020-12-10 00:05:06] 3005  4 total errors during this script execution, please investigate and try and fix these errors.
ERROR [2020-12-10 00:05:06] 3005  Uncaught exception: /var/www/matomo/core/CronArchive.php(600): 4 total errors during this script execution, please investigate and try and fix these errors.
4 total errors during this script execution, please investigate and try and fix these errors.

  [Exception]                                                                                   
  4 total errors during this script execution, please investigate and try and fix these errors. 

core:archive [--url="..."] [--skip-idsites[="..."]] [--skip-all-segments] [--force-idsites[="..."]] [--skip-segments-today] [--force-periods[="..."]] [--force-date-last-n="..."] [--force-date-range[="..."]] [--force-idsegments="..."] [--concurrent-requests-per-website[="..."]] [--concurrent-archivers[="..."]] [--disable-scheduled-tasks] [--accept-invalid-ssl-certificate] [--php-cli-options[="..."]] [--force-all-websites]
b4D8 commented 3 years ago

Also new message from Cron : /bin/sh: 1: /usr/bin/phpPHPVERSION: not found

Findus23 commented 3 years ago

https://github.com/matomo-org/matomo/issues/16888 and https://github.com/matomo-org/matomo/issues/16827 describe similar issues in the Matomo repo

ericgaspar commented 3 years ago

If you have the possibility to upgrade Matomo (knowing that it can break the app) with this branch of upgrade-testing ... and report errors... sudo yunohost app upgrade matomo -u https://github.com/YunoHost-Apps/matomo_ynh/tree/upgrade-testing

b4D8 commented 3 years ago

@Findus23 Indeed it seems like the same issue. Comments aren't being very helpful though...

@ericgaspar Just did the upgrade. Here's the log: https://paste.yunohost.org/raw/zetevatuhe. Everything seems just the same : dashboard is accessible but it seems that visits aren't being recorded anymore and most tabs show the SQLSTATE error.

Edit: when plugin DevicePlugins is inactive, errors do not show.

ericgaspar commented 3 years ago

can you try a fresh install (this app is multi-instance) and report if you have these errors? sudo yunohost app install https://github.com/YunoHost-Apps/matomo_ynh/tree/upgrade-testing

b4D8 commented 3 years ago

OK just did it. It seems that everything went well. Here's the log: https://paste.yunohost.org/raw/pojedapije. I don't have recorded data so I don't know if it's working fine though. Do you think I can save my old instance? or could you help me migrate my data?

ericgaspar commented 3 years ago

Should be fixed with #24