Hallo,
seit kurzem bekommen wir folgende Fehlermeldung bei der Ausführung des Cronjob “console: core:archive”:
ERROR [2021-06-14 12:05:25] 85966 Got invalid response from API request: ?module=API&method=API.get&idSite=11&period=year&date=last7&format=php&segment=pageUrl%3D%5Ehttps%25253A%25252F%25252Fwww.baintranet.de%25252F002%25252F001%25252F002%25252F%2CpageUrl%3D%3Dhttps%25253A%25252F%25252Fwww.baintranet.de%25252F005%25252F011%25252F002%25252F001%25252FSeiten%25252Fdefault.aspx%2CpageUrl%3D%3Dhttps%25253A%25252F%25252Fwww.baintranet.de%25252F005%25252F015%25252F004%25252F001%25252F002%25252F003%25252FSeiten%25252Fdefault.aspx%2CdownloadUrl%3D%5Ehttps%25253A%25252F%25252Fwww.baintranet.de%25252F002%25252F001%25252F002%25252F&trigger=archivephp. Response was 'a:2:{s:6:“result”;s:5:“error”;s:7:“message”;s:13311:"Trying to sum unsupported operands for column segment in row with label = datatable_metadata: string + integer - in plugin Actions #0 /srv/www/htdocs/matomo/core/ArchiveProcessor/Loader.php(165): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins(15260, 152, fal
se) #1 /srv/www/htdocs/matomo/core/ArchiveProcessor/Loader.php(111): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(15260, 152) #2 /srv/www/htdocs/matomo/core/ArchiveProcessor/Loader.php(84): Piwik\ArchiveProcessor\Loader->prepareArchiveImpl(‘VisitsSummary’) #3 /srv/www/htdocs/matomo/core/Context.php(75): Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor{closure}() #4 /srv/www/htdocs/matomo/core/ArchiveProcessor/Loader.php(85): Piwik\Context::changeIdSite(11, Object(Closure)) #5 /srv/www/htdocs/matomo/core/Archive.php(803): Piwik\ArchiveProcessor\Loader->prepareArchive(‘VisitsSummary’) #6 /srv/www/htdocs/matomo/core/Archive.php(607): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Year)) #7 /srv/www/htdocs/matomo/core/Archive.php(551): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array) #8 /srv/www/htdocs/matomo/core/Archive.php(480): Piwik\Archive->getArchiveIds(Array) #9 /srv/www/htdocs/matomo/core/Archive.php(
295): Piwik\Archive->get(Array, ‘numeric’) #10 /srv/www/htdocs/matomo/plugins/VisitsSummary/API.php(36): Piwik\Archive->getDataTableFromNumeric(Array) #11 [internal function]: Piwik\Plugins\VisitsSummary\API->get(‘11’, ‘year’, ‘last7’, ‘pageUrl%3D%5Eht…’, Array) #12 /srv/www/htdocs/matomo/core/API/Proxy.php(237): call_user_func_array(Array, Array) #13 /srv/www/htdocs/matomo/core/Context.php(28): Piwik\API\Proxy->Piwik\API{closure}() #14 /srv/www/htdocs/matomo/core/API/Proxy.php(328): Piwik\Context::executeWithQueryParameters(Array, Object(Closure)) #15 /srv/www/htdocs/matomo/plugins/API/API.php(437): Piwik\API\Proxy->call(’\Piwik\Plugins\…’, ‘get’, Array) #16 [internal function]: Piwik\Plugins\API\API->get(‘11’, ‘year’, ‘last7’, ‘pageUrl%3D%5Eht…’, Array) #17 /srv/www/htdocs/matomo/core/API/Proxy.php(237): call_user_func_array(Array, Array) #18 /srv/www/htdocs/matomo/core/Context.php(28): Piwik\API\Proxy->Piwik\API{closure}() #19 /srv/www/htdocs/matom
o/core/API/Proxy.php(328): Piwik\Context::executeWithQueryParameters(Array, Object(Closure)) #20 /srv/www/htdocs/matomo/core/API/Request.php(266): Piwik\API\Proxy->call(’\Piwik\Plugins\…’, ‘get’, Array) #21 /srv/www/htdocs/matomo/plugins/API/Controller.php(41): Piwik\API\Request->process() #22 [internal function]: Piwik\Plugins\API\Controller->index() #23 /srv/www/htdocs/matomo/core/FrontController.php(590): call_user_func_array(Array, Array) #24 /srv/www/htdocs/matomo/core/FrontController.php(165): Piwik\FrontController->doDispatch(‘API’, false, Array) #25 /srv/www/htdocs/matomo/core/dispatch.php(34): Piwik\FrontController->dispatch() #26 /srv/www/htdocs/matomo/index.php(27): require_once(’/srv/www/htdocs…’) #27 /srv/www/htdocs/matomo/core/CliMulti/RequestCommand.php(79): require_once(’/srv/www/htdocs…’) #28 /srv/www/htdocs/matomo/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Piwik\CliMulti\RequestCommand->execute(Object(Symfo
ny\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #29 /srv/www/htdocs/matomo/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)) #30 /srv/www/htdocs/matomo/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)) #31 [internal function]: Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #32 /srv/www/htdocs/matomo/core/Console.php(140): call_user_func(Array, Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\Conso
leOutput)) #33 /srv/www/htdocs/matomo/core/Access.php(644): Piwik\Console->Piwik{closure}() #34 /srv/www/htdocs/matomo/core/Console.php(141): Piwik\Access::doAsSuperUser(Object(Closure)) #35 /srv/www/htdocs/matomo/core/Console.php(93): Piwik\Console->doRunImpl(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #36 /srv/www/htdocs/matomo/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Piwik\Console->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #37 /srv/www/htdocs/matomo/console(32): Symfony\Component\Console\Application->run() #38 {main}, caused by: Trying to sum unsupported operands for column segment in row with label = datatable_metadata: string + integer #0 /srv/www/htdocs/matomo/core/DataTable/Row.php(516): Piwik\DataTable\Row->sumRowArray(‘pageUrl=^https%…’, 0, ‘segment’) #1 /srv/www/htdocs/matomo/core/DataTable
/Row.php(485): Piwik\DataTable\Row->getColumnValu
ERROR [2021-06-14 12:05:25] 85966 1 total errors during this script execution, please investigate and try and fix these errors.
ERROR [2021-06-14 12:05:25] 85966 Uncaught exception: /srv/www/htdocs/matomo/core/CronArchive.php(606): 1 total errors during this script execution, please investigate and try and fix these errors.
1 total errors during this script execution, please investigate and try and fix these errors.
#0 /srv/www/htdocs/matomo/core/CronArchive.php(599): Piwik\CronArchive->logFatalError(‘1 total errors …’)
#1 /srv/www/htdocs/matomo/core/CronArchive.php(331): Piwik\CronArchive->end()
#2 /srv/www/htdocs/matomo/core/Access.php(635): Piwik\CronArchive->Piwik{closure}()
#3 /srv/www/htdocs/matomo/core/CronArchive.php(335): Piwik\Access::doAsSuperUser(Object(Closure))
#4 /srv/www/htdocs/matomo/plugins/CoreConsole/Commands/CoreArchiver.php(27): Piwik\CronArchive->main()
#5 /srv/www/htdocs/matomo/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Piwik\Plugins\CoreConsole\Commands\CoreArchiver->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#6 /srv/www/htdocs/matomo/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))
#7 /srv/www/htdocs/matomo/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(Piwik\Plugins\CoreConsole\Commands\CoreArchiver), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#8 [internal function]: Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#9 /srv/www/htdocs/matomo/core/Console.php(140): call_user_func(Array, Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#10 /srv/www/htdocs/matomo/core/Access.php(644): Piwik\Console->Piwik{closure}()
#11 /srv/www/htdocs/matomo/core/Console.php(141): Piwik\Access::doAsSuperUser(Object(Closure))
#12 /srv/www/htdocs/matomo/core/Console.php(93): Piwik\Console->doRunImpl(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#13 /srv/www/htdocs/matomo/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Piwik\Console->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#14 /srv/www/htdocs/matomo/console(32): Symfony\Component\Console\Application->run()
#15 {main}
ich komme aktuell nicht dahinter wo der Fehler liegt, sieht für mich so aus als wolle er etwas zusammen zählen, was nicht geht oder nicht zusammen passt. Ich weiß aber nicht wo das passiert. In der GUI findet sich kein Fehler. wir sind aus gewissen Gründen noch auf Version 3.13.5.
Hat jemand eine Idee?
Viele Grüße
Ortwin