Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED\' does not exist

[maxxer90]

Hello Matomo Wordpress Team,

I tried a new installation of Matomo for Wordpress on our site yesterday.
Everything is working except archiving.

When I try to do manual archiving, I get the following errors:

WordPress-Datenbank-Fehler Table \'$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED\' doesn\'t exist für Abfrage SELECT /*+ MAX_EXECUTION_TIME(7200000) */ 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\\Component\\Console\\Application->run, Piwik\\Console->doRun, Piwik\\Console->doRunImpl, Piwik\\Access::doAsSuperUser, Piwik\\Console->Piwik\\{closure}, call_user_func, Symfony\\Component\\Console\\Application->doRun, Symfony\\Component\\Console\\Application->doRunCommand, Symfony\\Component\\Console\\Command\\Command->run, Piwik\\CliMulti\\RequestCommand->execute, require_once(\'/plugins/matomo/app/index.php\'), require_once(\'/plugins/matomo/app/core/dispatch.php\'), Piwik\\FrontController->dispatch, Piwik\\FrontController->doDispatch, call_user_func_array, Piwik\\Plugins\\API\\Controller->index, Piwik\\API\\Request->process, Piwik\\API\\Proxy->call, Piwik\\Context::executeWithQueryParameters, Piwik\\API\\Proxy->Piwik\\API\\{closure}, call_user_func_array, Piwik\\Plugins\\CoreAdminHome\\API->archiveReports, Piwik\\ArchiveProcessor\\Loader->prepareArchive, Piwik\\Context::changeIdSite, Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}, Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl, Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive, Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins, Piwik\\Plugin\\Archiver->callAggregateDayReport, Piwik\\Plugins\\Goals\\Archiver->aggregateDayReport, Piwik\\ArchiveProcessor->processDependentArchive, Piwik\\ArchiveProcessor\\Loader->prepareArchive, Piwik\\Context::changeIdSite, Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}, Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl, Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive, Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins, Piwik\\DataAccess\\LogAggregator->cleanup, Piwik\\DataAccess\\LogAggregator->doesSegmentTableExist, Piwik\\DataAccess\\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\\Db\\Adapter\\WordPress->fetchOne
{"idarchives":[280],"nb_visits":"1"}\''
'Error unserializing the following response from ?module=API&method=CoreAdminHome.archiveReports&idSite=1&period=week&date=2021-01-25&format=json&trigger=archivephp: \'WordPress-Datenbank-Fehler Table \'$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED\' doesn\'t exist für Abfrage SELECT /*+ MAX_EXECUTION_TIME(7200000) */ 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\\Component\\Console\\Application->run, Piwik\\Console->doRun, Piwik\\Console->doRunImpl, Piwik\\Access::doAsSuperUser, Piwik\\Console->Piwik\\{closure}, call_user_func, Symfony\\Component\\Console\\Application->doRun, Symfony\\Component\\Console\\Application->doRunCommand, Symfony\\Component\\Console\\Command\\Command->run, Piwik\\CliMulti\\RequestCommand->execute, require_once(\'/plugins/matomo/app/index.php\'), require_once(\'/plugins/matomo/app/core/dispatch.php\'), Piwik\\FrontController->dispatch, Piwik\\FrontController->doDispatch, call_user_func_array, Piwik\\Plugins\\API\\Controller->index, Piwik\\API\\Request->process, Piwik\\API\\Proxy->call, Piwik\\Context::executeWithQueryParameters, Piwik\\API\\Proxy->Piwik\\API\\{closure}, call_user_func_array, Piwik\\Plugins\\CoreAdminHome\\API->archiveReports, Piwik\\ArchiveProcessor\\Loader->prepareArchive, Piwik\\Context::changeIdSite, Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}, Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl, Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive, Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins, Piwik\\Plugin\\Archiver->callAggregateMultipleReports, Piwik\\Plugins\\Goals\\Archiver->aggregateMultipleReports, Piwik\\ArchiveProcessor->processDependentArchive, Piwik\\ArchiveProcessor\\Loader->prepareArchive, Piwik\\Context::changeIdSite, Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}, Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl, Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive, Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins, Piwik\\DataAccess\\LogAggregator->cleanup, Piwik\\DataAccess\\LogAggregator->doesSegmentTableExist, Piwik\\DataAccess\\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\\Db\\Adapter\\WordPress->fetchOne
WordPress-Datenbank-Fehler Table \'$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED\' doesn\'t exist für Abfrage SELECT /*+ MAX_EXECUTION_TIME(7200000) */ 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\\Component\\Console\\Application->run, Piwik\\Console->doRun, Piwik\\Console->doRunImpl, Piwik\\Access::doAsSuperUser, Piwik\\Console->Piwik\\{closure}, call_user_func, Symfony\\Component\\Console\\Application->doRun, Symfony\\Component\\Console\\Application->doRunCommand, Symfony\\Component\\Console\\Command\\Command->run, Piwik\\CliMulti\\RequestCommand->execute, require_once(\'/plugins/matomo/app/index.php\'), require_once(\'/plugins/matomo/app/core/dispatch.php\'), Piwik\\FrontController->dispatch, Piwik\\FrontController->doDispatch, call_user_func_array, Piwik\\Plugins\\API\\Controller->index, Piwik\\API\\Request->process, Piwik\\API\\Proxy->call, Piwik\\Context::executeWithQueryParameters, Piwik\\API\\Proxy->Piwik\\API\\{closure}, call_user_func_array, Piwik\\Plugins\\CoreAdminHome\\API->archiveReports, Piwik\\ArchiveProcessor\\Loader->prepareArchive, Piwik\\Context::changeIdSite, Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}, Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl, Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive, Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins, Piwik\\Plugin\\Archiver->callAggregateMultipleReports, Piwik\\Plugins\\Goals\\Archiver->aggregateMultipleReports, Piwik\\ArchiveProcessor->processDependentArchive, Piwik\\ArchiveProcessor\\Loader->prepareArchive, Piwik\\Context::changeIdSite, Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}, Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl, Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive, Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins, Piwik\\DataAccess\\LogAggregator->cleanup, Piwik\\DataAccess\\LogAggregator->doesSegmentTableExist, Piwik\\DataAccess\\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\\Db\\Adapter\\WordPress->fetchOne
{"idarchives":[283],"nb_visits":3}\''
'Error unserializing the following response from ?module=API&method=CoreAdminHome.archiveReports&idSite=1&period=month&date=2021-01-01&format=json&trigger=archivephp: \'WordPress-Datenbank-Fehler Table \'$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED\' doesn\'t exist für Abfrage SELECT /*+ MAX_EXECUTION_TIME(7200000) */ 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\\Component\\Console\\Application->run, Piwik\\Console->doRun, Piwik\\Console->doRunImpl, Piwik\\Access::doAsSuperUser, Piwik\\Console->Piwik\\{closure}, call_user_func, Symfony\\Component\\Console\\Application->doRun, Symfony\\Component\\Console\\Application->doRunCommand, Symfony\\Component\\Console\\Command\\Command->run, Piwik\\CliMulti\\RequestCommand->execute, require_once(\'/plugins/matomo/app/index.php\'), require_once(\'/plugins/matomo/app/core/dispatch.php\'), Piwik\\FrontController->dispatch, Piwik\\FrontController->doDispatch, call_user_func_array, Piwik\\Plugins\\API\\Controller->index, Piwik\\API\\Request->process, Piwik\\API\\Proxy->call, Piwik\\Context::executeWithQueryParameters, Piwik\\API\\Proxy->Piwik\\API\\{closure}, call_user_func_array, Piwik\\Plugins\\CoreAdminHome\\API->archiveReports, Piwik\\ArchiveProcessor\\Loader->prepareArchive, Piwik\\Context::changeIdSite, Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}, Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl, Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive, Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins, Piwik\\Plugin\\Archiver->callAggregateMultipleReports, Piwik\\Plugins\\Goals\\Archiver->aggregateMultipleReports, Piwik\\ArchiveProcessor->processDependentArchive, Piwik\\ArchiveProcessor\\Loader->prepareArchive, Piwik\\Context::changeIdSite, Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}, Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl, Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive, Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins, Piwik\\DataAccess\\LogAggregator->cleanup, Piwik\\DataAccess\\LogAggregator->doesSegmentTableExist, Piwik\\DataAccess\\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\\Db\\Adapter\\WordPress->fetchOne
WordPress-Datenbank-Fehler Table \'$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED\' doesn\'t exist für Abfrage SELECT /*+ MAX_EXECUTION_TIME(7200000) */ 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\\Component\\Console\\Application->run, Piwik\\Console->doRun, Piwik\\Console->doRunImpl, Piwik\\Access::doAsSuperUser, Piwik\\Console->Piwik\\{closure}, call_user_func, Symfony\\Component\\Console\\Application->doRun, Symfony\\Component\\Console\\Application->doRunCommand, Symfony\\Component\\Console\\Command\\Command->run, Piwik\\CliMulti\\RequestCommand->execute, require_once(\'/plugins/matomo/app/index.php\'), require_once(\'/plugins/matomo/app/core/dispatch.php\'), Piwik\\FrontController->dispatch, Piwik\\FrontController->doDispatch, call_user_func_array, Piwik\\Plugins\\API\\Controller->index, Piwik\\API\\Request->process, Piwik\\API\\Proxy->call, Piwik\\Context::executeWithQueryParameters, Piwik\\API\\Proxy->Piwik\\API\\{closure}, call_user_func_array, Piwik\\Plugins\\CoreAdminHome\\API->archiveReports, Piwik\\ArchiveProcessor\\Loader->prepareArchive, Piwik\\Context::changeIdSite, Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}, Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl, Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive, Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins, Piwik\\Plugin\\Archiver->callAggregateMultipleReports, Piwik\\Plugins\\Goals\\Archiver->aggregateMultipleReports, Piwik\\ArchiveProcessor->processDependentArchive, Piwik\\ArchiveProcessor\\Loader->prepareArchive, Piwik\\Context::changeIdSite, Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}, Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl, Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive, Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins, Piwik\\DataAccess\\LogAggregator->cleanup, Piwik\\DataAccess\\LogAggregator->doesSegmentTableExist, Piwik\\DataAccess\\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\\Db\\Adapter\\WordPress->fetchOne
{"idarchives":[286],"nb_visits":3}\''
'Error unserializing the following response from ?module=API&method=CoreAdminHome.archiveReports&idSite=1&period=year&date=2021-01-01&format=json&trigger=archivephp: \'WordPress-Datenbank-Fehler Table \'$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED\' doesn\'t exist für Abfrage SELECT /*+ MAX_EXECUTION_TIME(7200000) */ 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\\Component\\Console\\Application->run, Piwik\\Console->doRun, Piwik\\Console->doRunImpl, Piwik\\Access::doAsSuperUser, Piwik\\Console->Piwik\\{closure}, call_user_func, Symfony\\Component\\Console\\Application->doRun, Symfony\\Component\\Console\\Application->doRunCommand, Symfony\\Component\\Console\\Command\\Command->run, Piwik\\CliMulti\\RequestCommand->execute, require_once(\'/plugins/matomo/app/index.php\'), require_once(\'/plugins/matomo/app/core/dispatch.php\'), Piwik\\FrontController->dispatch, Piwik\\FrontController->doDispatch, call_user_func_array, Piwik\\Plugins\\API\\Controller->index, Piwik\\API\\Request->process, Piwik\\API\\Proxy->call, Piwik\\Context::executeWithQueryParameters, Piwik\\API\\Proxy->Piwik\\API\\{closure}, call_user_func_array, Piwik\\Plugins\\CoreAdminHome\\API->archiveReports, Piwik\\ArchiveProcessor\\Loader->prepareArchive, Piwik\\Context::changeIdSite, Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}, Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl, Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive, Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins, Piwik\\Plugin\\Archiver->callAggregateMultipleReports, Piwik\\Plugins\\Goals\\Archiver->aggregateMultipleReports, Piwik\\ArchiveProcessor->processDependentArchive, Piwik\\ArchiveProcessor\\Loader->prepareArchive, Piwik\\Context::changeIdSite, Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}, Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl, Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive, Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins, Piwik\\DataAccess\\LogAggregator->cleanup, Piwik\\DataAccess\\LogAggregator->doesSegmentTableExist, Piwik\\DataAccess\\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\\Db\\Adapter\\WordPress->fetchOne
WordPress-Datenbank-Fehler Table \'$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED\' doesn\'t exist für Abfrage SELECT /*+ MAX_EXECUTION_TIME(7200000) */ 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\\Component\\Console\\Application->run, Piwik\\Console->doRun, Piwik\\Console->doRunImpl, Piwik\\Access::doAsSuperUser, Piwik\\Console->Piwik\\{closure}, call_user_func, Symfony\\Component\\Console\\Application->doRun, Symfony\\Component\\Console\\Application->doRunCommand, Symfony\\Component\\Console\\Command\\Command->run, Piwik\\CliMulti\\RequestCommand->execute, require_once(\'/plugins/matomo/app/index.php\'), require_once(\'/plugins/matomo/app/core/dispatch.php\'), Piwik\\FrontController->dispatch, Piwik\\FrontController->doDispatch, call_user_func_array, Piwik\\Plugins\\API\\Controller->index, Piwik\\API\\Request->process, Piwik\\API\\Proxy->call, Piwik\\Context::executeWithQueryParameters, Piwik\\API\\Proxy->Piwik\\API\\{closure}, call_user_func_array, Piwik\\Plugins\\CoreAdminHome\\API->archiveReports, Piwik\\ArchiveProcessor\\Loader->prepareArchive, Piwik\\Context::changeIdSite, Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}, Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl, Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive, Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins, Piwik\\Plugin\\Archiver->callAggregateMultipleReports, Piwik\\Plugins\\Goals\\Archiver->aggregateMultipleReports, Piwik\\ArchiveProcessor->processDependentArchive, Piwik\\ArchiveProcessor\\Loader->prepareArchive, Piwik\\Context::changeIdSite, Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}, Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl, Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive, Piwik\\ArchiveProcessor\\PluginsArchiver->callAggregateAllPlugins, Piwik\\DataAccess\\LogAggregator->cleanup, Piwik\\DataAccess\\LogAggregator->doesSegmentTableExist, Piwik\\DataAccess\\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\\Db\\Adapter\\WordPress->fetchOne
{"idarchives":[289],"nb_visits":3}\''
'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.'

It is the same issue as this user: https://wordpress.org/support/topic/archive-warning-error-unserializing-wp_matomo_logtmpsegment/

This is my system report:

			  # Matomo

• Matomo-Plugin-Version: 4.1.2
• Config existiert und ist schreibbar.: Ja ("$ABSPATH/wp-content/uploads/matomo/config/config.ini.php" )
• JS Tracker existiert und ist schreibbar.: Ja ("$ABSPATH/wp-content/uploads/matomo/matomo.js" )
• Plugin-Verzeichnisse: Yes ([{"pluginsPathAbsolute":"$ABSPATH/wp-content/plugins/matomo/plugins","webrootDirRelativeToMatomo":"../"},{"pluginsPathAbsolute":"$ABSPATH/wp-content/plugins","webrootDirRelativeToMatomo":"../../"}])
• Tmp-Verzeichnis schreibbar: Yes ($ABSPATH/wp-content/cache/matomo)
• Matomo-Version: 4.1.1
• Matomo Blog idSite: 1
• Installierte Matomo-Version: 4.1.2 (Install date: 2021-01-26 13:31:06)
• Upgrades outstanding: No
• Upgrade in progress: No

Endpoints

• Matomo JavaScript Tracker URL: ($site_url/wp-content/uploads/matomo/matomo.js)
• Matomo JavaScript Tracker - WP Rest API: ($site_url/wp-json/matomo/v1/hit/)
• Matomo HTTP Tracking API: ($site_url/wp-content/plugins/matomo/app/matomo.php)
• Matomo HTTP Tracking API - WP Rest API: ($site_url/wp-json/matomo/v1/hit/)

Crons

• Server-Zeit: 2021-01-27 09:43:25
• Blog-Zeit: 2021-01-27 10:43:25 (Die nachfolgenden Daten werden in der Blog-Zeitzone angezeigt)
• Sync users & sites: Next run: 2021-01-27 13:31:03 (2 Stunden 47 Minuten) ( Last started: 2021-01-26 13:32:34 (-21 Stunden 10 Minuten). Last ended: 2021-01-26 13:32:34 (-21 Stunden 10 Minuten). Interval: daily)
• Archive: Next run: 2021-01-27 11:31:03 (47 Minuten 38s) ( Last started: 2021-01-27 10:31:40 (-11 Minuten 45s). Last ended: 2021-01-26 18:37:23 (-16 Stunden 6 Minuten). Interval: hourly)
• Update GeoIP DB: Next run: 2021-02-25 13:31:03 (29 Tage 2 Stunden) ( Last started: 2021-01-26 13:32:35 (-21 Stunden 10 Minuten). Last ended: 2021-01-26 13:32:37 (-21 Stunden 10 Minuten). Interval: matomo_monthly)

Vorgeschriebene Prüfungen

• PHP-Version >= : ok
• PDO Erweiterung: ok
• PDO\MYSQL Erweiterung: ok
• MYSQLI Erweiterung: ok
• Weitere erforderliche Anforderungen: ok
• Erforderliche Funktionen: ok
• Benötigte PHP Konfiguration (php.ini): ok
• Verzeichnisse mit Schreibzugriff: ok
• Verzeichnisse mit Schreibzugriff auf Tag Manager: ok

Optionale Prüfungen

• Tracker-Status: ok
• Speicherlimit: ok
• Zeitzone: ok
• Öffnen einer URL: ok
• PageSpeed deaktiviert: ok
• GD > 2.x + Freetype (graphics): ok
• Andere Erweiterungen: ok
• Andere Funktionen: ok
• Dateisystem: ok
• Letzter erfolgreicher Abschluss der Archivierung: ok
• Datenbankfähigkeiten: ok
• Warning Maximale Packetgröße: warning (Es wird empfohlen die 'max_allowed_packet' Größe in Ihrer MySQL Datenbank auf mindestens 64MB zu erhöhen. Aktuell ist 16MB eingestellt. )
• Standorterkennung: ok
• Update über HTTPS: ok
• Schreibbarer JavaScript-Tracker ("/matomo.js"): ok
• Supports Async Archiving: Yes
• Location provider ID: geoip2php
• Location provider available: Yes
• Location provider working: Yes
• Had visit in last 5 days: Yes

Matomo Settings

• Track mode: disabled
• Track codeposition: footer
• Track api endpoint: default
• Track js endpoint: default
• Version history: 4.1.2
• Core version: 4.1.1
• Show get started page: 0
• Last settings update: 1611664354
• Last tracking settings update: 1611664354

Logs

• Warning archive_main: 2021-01-27 09:39:33 (4 total errors during this script execution, please investigate and try and fix these errors. => CronArchive.php:611; CronArchive.php:604; CronArchive.php:270; Access.php:673; CronArchive.php:274; ScheduledTasks.php:288; class-wp-hook.php:285; class-wp-hook.php:311; plugin.php:551; wp-cron.php:138;)
• Warning archive_errors: 2021-01-27 09:39:33 ('Error unserializing the following response from ?module=API&method=CoreAdminHome.archiveReports&idSite=1&period=day&date=2021-01-27&format=json&trigger=archivephp: 'WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /*+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateDayReport, Piwik\Plugins\Goals\Archiver->aggregateDayReport, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateDayReport, Piwik\Plugins\Goals\Archiver->aggregateDayReport, Piwik\Plugins\Goals\Archiver->aggregateGeneralGoalMetrics, Piwik\DataAccess\LogAggregator->queryConversionsByDimension, Piwik\DataAccess\LogAggregator->generateQuery, Piwik\DataAccess\LogAggregator->createTemporaryTable, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateDayReport, Piwik\Plugins\Goals\Archiver->aggregateDayReport, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne {"idarchives":[257],"nb_visits":"1"}'' 'Error unserializing the following response from ?module=API&method=CoreAdminHome.archiveReports&idSite=1&period=week&date=2021-01-25&format=json&trigger=archivephp: 'WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateMultipleReports, Piwik\Plugins\Goals\Archiver->aggregateMultipleReports, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateMultipleReports, Piwik\Plugins\Goals\Archiver->aggregateMultipleReports, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne {"idarchives":[260],"nb_visits":3}'' 'Error unserializing the following response from ?module=API&method=CoreAdminHome.archiveReports&idSite=1&period=month&date=2021-01-01&format=json&trigger=archivephp: 'WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateMultipleReports, Piwik\Plugins\Goals\Archiver->aggregateMultipleReports, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateMultipleReports, Piwik\Plugins\Goals\Archiver->aggregateMultipleReports, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne {"idarchives":[263],"nb_visits":3}'' 'Error unserializing the following response from ?module=API&method=CoreAdminHome.archiveReports&idSite=1&period=year&date=2021-01-01&format=json&trigger=archivephp: 'WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateMultipleReports, Piwik\Plugins\Goals\Archiver->aggregateMultipleReports, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) */ 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateMultipleReports, Piwik\Plugins\Goals\Archiver->aggregateMultipleReports, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne {"idarchives":[266],"nb_visits":3}'' '4 total errors during this script execution, please investigate and try and fix these errors.' => ScheduledTasks.php:301; class-wp-hook.php:285; class-wp-hook.php:311; plugin.php:551; wp-cron.php:138;)
• Warning archive_main: 2021-01-27 10:31:46 (3 total errors during this script execution, please investigate and try and fix these errors. => CronArchive.php:611; CronArchive.php:604; CronArchive.php:270; Access.php:673; CronArchive.php:274; ScheduledTasks.php:288; class-wp-hook.php:285; class-wp-hook.php:311; plugin.php:551; wp-cron.php:138;)
• Warning archive_errors: 2021-01-27 10:31:46 ('Error unserializing the following response from ?module=API&method=CoreAdminHome.archiveReports&idSite=1&period=day&date=2021-01-27&format=json&trigger=archivephp: 'WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /*+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateDayReport, Piwik\Plugins\Goals\Archiver->aggregateDayReport, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateDayReport, Piwik\Plugins\Goals\Archiver->aggregateDayReport, Piwik\Plugins\Goals\Archiver->aggregateGeneralGoalMetrics, Piwik\DataAccess\LogAggregator->queryConversionsByDimension, Piwik\DataAccess\LogAggregator->generateQuery, Piwik\DataAccess\LogAggregator->createTemporaryTable, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateDayReport, Piwik\Plugins\Goals\Archiver->aggregateDayReport, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne {"idarchives":[269],"nb_visits":"1"}'' 'Error unserializing the following response from ?module=API&method=CoreAdminHome.archiveReports&idSite=1&period=week&date=2021-01-25&format=json&trigger=archivephp: 'WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateMultipleReports, Piwik\Plugins\Goals\Archiver->aggregateMultipleReports, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateMultipleReports, Piwik\Plugins\Goals\Archiver->aggregateMultipleReports, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne {"idarchives":[272],"nb_visits":3}'' 'Error unserializing the following response from ?module=API&method=CoreAdminHome.archiveReports&idSite=1&period=month&date=2021-01-01&format=json&trigger=archivephp: 'WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateMultipleReports, Piwik\Plugins\Goals\Archiver->aggregateMultipleReports, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) */ 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateMultipleReports, Piwik\Plugins\Goals\Archiver->aggregateMultipleReports, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne {"idarchives":[275],"nb_visits":3}'' '3 total errors during this script execution, please investigate and try and fix these errors.' => ScheduledTasks.php:301; class-wp-hook.php:285; class-wp-hook.php:311; plugin.php:551; wp-cron.php:138;)
• Warning archive_main: 2021-01-27 10:40:58 (4 total errors during this script execution, please investigate and try and fix these errors. => CronArchive.php:611; CronArchive.php:604; CronArchive.php:270; Access.php:664; CronArchive.php:274; ScheduledTasks.php:288; SystemReport.php:114; SystemReport.php:178; class-wp-hook.php:287; class-wp-hook.php:311; plugin.php:484; admin.php:259;)
• Warning archive_errors: 2021-01-27 10:40:58 ('Error unserializing the following response from ?module=API&method=CoreAdminHome.archiveReports&idSite=1&period=day&date=2021-01-27&format=json&trigger=archivephp: 'WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /*+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateDayReport, Piwik\Plugins\Goals\Archiver->aggregateDayReport, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateDayReport, Piwik\Plugins\Goals\Archiver->aggregateDayReport, Piwik\Plugins\Goals\Archiver->aggregateGeneralGoalMetrics, Piwik\DataAccess\LogAggregator->queryConversionsByDimension, Piwik\DataAccess\LogAggregator->generateQuery, Piwik\DataAccess\LogAggregator->createTemporaryTable, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne
  WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateDayReport, Piwik\Plugins\Goals\Archiver->aggregateDayReport, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne
  {"idarchives":[280],"nb_visits":"1"}'' 'Error unserializing the following response from ?module=API&method=CoreAdminHome.archiveReports&idSite=1&period=week&date=2021-01-25&format=json&trigger=archivephp: 'WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateMultipleReports, Piwik\Plugins\Goals\Archiver->aggregateMultipleReports, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne
  WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateMultipleReports, Piwik\Plugins\Goals\Archiver->aggregateMultipleReports, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne
  {"idarchives":[283],"nb_visits":3}'' 'Error unserializing the following response from ?module=API&method=CoreAdminHome.archiveReports&idSite=1&period=month&date=2021-01-01&format=json&trigger=archivephp: 'WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateMultipleReports, Piwik\Plugins\Goals\Archiver->aggregateMultipleReports, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne
  WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateMultipleReports, Piwik\Plugins\Goals\Archiver->aggregateMultipleReports, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne
  {"idarchives":[286],"nb_visits":3}'' 'Error unserializing the following response from ?module=API&method=CoreAdminHome.archiveReports&idSite=1&period=year&date=2021-01-01&format=json&trigger=archivephp: 'WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) / 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateMultipleReports, Piwik\Plugins\Goals\Archiver->aggregateMultipleReports, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne
  WordPress-Datenbank-Fehler Table '$DB_NAME.wp_matomo_logtmpsegmentTOKEN_REPLACED' doesn't exist für Abfrage SELECT /+ MAX_EXECUTION_TIME(7200000) */ 1 FROM wp_matomo_logtmpsegmentTOKEN_REPLACED LIMIT 1 von Symfony\Component\Console\Application->run, Piwik\Console->doRun, Piwik\Console->doRunImpl, Piwik\Access::doAsSuperUser, Piwik\Console->Piwik\{closure}, call_user_func, Symfony\Component\Console\Application->doRun, Symfony\Component\Console\Application->doRunCommand, Symfony\Component\Console\Command\Command->run, Piwik\CliMulti\RequestCommand->execute, require_once('/plugins/matomo/app/index.php'), require_once('/plugins/matomo/app/core/dispatch.php'), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\API\Controller->index, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API\{closure}, call_user_func_array, Piwik\Plugins\CoreAdminHome\API->archiveReports, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\Plugin\Archiver->callAggregateMultipleReports, Piwik\Plugins\Goals\Archiver->aggregateMultipleReports, Piwik\ArchiveProcessor->processDependentArchive, Piwik\ArchiveProcessor\Loader->prepareArchive, Piwik\Context::changeIdSite, Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}, Piwik\ArchiveProcessor\Loader->prepareArchiveImpl, Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive, Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins, Piwik\DataAccess\LogAggregator->cleanup, Piwik\DataAccess\LogAggregator->doesSegmentTableExist, Piwik\DataAccess\ArchivingDbAdapter->fetchOne, call_user_func_array, Piwik\Db\Adapter\WordPress->fetchOne
  {"idarchives":[289],"nb_visits":3}'' '4 total errors during this script execution, please investigate and try and fix these errors.' => ScheduledTasks.php:301; SystemReport.php:114; SystemReport.php:178; class-wp-hook.php:287; class-wp-hook.php:311; plugin.php:484; admin.php:259;)

WordPress

• Home URL: $site_url
• Site URL: $site_url
• WordPress Version: 5.6
• Number of blogs: 1
• Multisite Enabled: No
• Network Enabled: No
• WP_DEBUG: No
• WP_DEBUG_DISPLAY: Yes
• WP_DEBUG_LOG: No
• DISABLE_WP_CRON: -
• FORCE_SSL_ADMIN: Yes
• WP_CACHE: No
• CONCATENATE_SCRIPTS: -
• COMPRESS_SCRIPTS: -
• COMPRESS_CSS: -
• ENFORCE_GZIP: -
• WP_LOCAL_DEV: -
• DIEONDBERROR: -
• WPLANG:
• ALTERNATE_WP_CRON: -
• WP_CRON_LOCK_TIMEOUT: 60
• WP_DISABLE_FATAL_ERROR_HANDLER: -
• MATOMO_SUPPORT_ASYNC_ARCHIVING: -
• MATOMO_TRIGGER_BROWSER_ARCHIVING: -
• MATOMO_ENABLE_TAG_MANAGER: -
• MATOMO_SUPPRESS_DB_ERRORS: -
• MATOMO_ENABLE_AUTO_UPGRADE: -
• MATOMO_DEBUG: -
• MATOMO_SAFE_MODE: -
• MATOMO_GLOBAL_UPLOAD_DIR: -
• MATOMO_LOGIN_REDIRECT: -
• Permalink Structure: /%postname%/
• Possibly uses symlink: No
• Compatible content directory: Yes

WordPress Plugins

• Absolute <> Relative URLs: 1.6.0
• Akismet Anti-Spam: 4.1.8
• Autoptimize: 2.8.1
• Better Search Replace: 1.3.4 (Network enabled)
• Borlabs Cookie - Cookie Opt-in: 2.2.13
• Buttonizer - Smart Floating Action Button: 2.2.5
• Classic Editor: 1.6
• Contact Form 7: 5.3.2
• Contact Form 7 Image Captcha: 3.2.1
• Email Address Encoder: 1.0.22
• Hello Dolly: 1.7.2
• Honeypot for Contact Form 7: 1.14.1
• LayerSlider WP: 6.10.2
• Matomo Analytics - Ethical Stats. Powerful Insights.: 4.1.2
• Matomo Marketplace for WordPress: 1.0.8
• Max Mega Menu: 2.9.2
• OMGF: 4.2.4
• Really Simple SSL: 4.0.6
• Redirection: 5.0
• Search Engine Keywords Performance (Matomo Plugin): 4.2.0
• Self-Hosted Google Fonts: 1.0.1
• Slider Revolution: 6.3.4
• SVG Support: 2.3.18
• Templatera: 2.0.4
• Total Theme Core: 1.2.7
• Wordfence Security: 7.4.14 (Network enabled)
• WPBakery Page Builder: 6.5.0
• WP Super Cache: 1.7.1
• Yoast Duplicate Post: 4.0.2
• Yoast SEO: 15.6.2
• Active Plugins: 25 (LayerSlider SearchEngineKeywordsPerformance absolute-relative-urls better-search-replace borlabs-cookie buttonizer-multifunctional-button classic-editor contact-form-7-honeypot contact-form-7-image-captcha contact-form-7 duplicate-post email-address-encoder host-webfonts-local js_composer matomo-marketplace-for-wordpress matomo megamenu redirection revslider selfhost-google-fonts svg-support templatera total-theme-core wordfence wordpress-seo)
• Theme: Total (total-child-theme)

Server

• Server Info: Apache
• PHP OS: Linux
• PHP Version: 7.3.25
• PHP SAPI: fpm-fcgi
• PHP Binary Name: php-fpm
• PHP Found Binary: php -q
• Timezone: UTC
• WP timezone: Europe/Berlin
• Locale: de_DE
• User Locale: de_DE
• Memory Limit: 256M (At least 128MB recommended. Depending on your traffic 256MB or more may be needed.)
• WP Memory Limit: 40M
• WP Max Memory Limit: 256M
• Timezone version: 0.system
• Time: 1611740605
• Max Execution Time: 300
• Max Post Size: 50M
• Max Upload Size: 33554432
• Max Input Vars: 1000
• Disabled PHP functions: Yes (opcache_get_status)
• zlib.output_compression is off: Yes
• Curl Version: 7.47.0, OpenSSL/1.0.2g
• Suhosin installed: No

Database

• MySQL Version: 5.7.32
• Mysqli Connect: Yes
• Force MySQL over Mysqli: No
• DB Prefix: wp_
• DB CHARSET: utf8
• DB COLLATE:
• SHOW ERRORS: No
• SUPPRESS ERRORS: No
• Uses Socket: No
• Uses IPv6: No
• Matomo tables found: 61
• Matomo users found: 7
• Matomo sites found: 1
• Erforderliche Berechtigungen: OK

Browser

• Browser: (Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36)
• Language: de-de,de,en-us,en

Thank you for your assistance.

[tsteur]

Thanks for this @maxxer90 I was finally able to reproduce this and we should have a fix for it. We'll release an update soon. Be great if you could confirm if it's still an issue after updating. Basically, it was expected for that query to fail in some cases but WP DB behaviour was to still log this message even though it was not causing any issue and expected to fail. So everything should still have worked meanwhile. In future it should be no longer logged.

[maxxer90]

Thank you very much for your work @tsteur . I could run manual archiving without any errors after the latest update :) And automatic archiving works, too :)