Archive Warning: Error unserializing & wp_matomo_logtmpsegment

  • Resolved Jan

    (@janerio)


    3 years, 2 months ago

    Hello,

    unfortunately, in my standard woocommerce/matomo installation archiving does

    not work and I get 3 times following error:
    Matomo Archive Warnings: ‘Error unserializing the following response from ?module=API&method=CoreAdminHome.archiveReports&idSite=1&period=day&date=2021-01-26&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”:[2810],”nb_visits”:”6″}\”

    DB does have needed rights.

    Can you help?

    Thanks
    Jan

Viewing 13 replies - 1 through 13 (of 13 total)
  • Plugin Author Thomas

    (@tsteur)

    3 years, 2 months ago

    Hi @janerio thanks for bringing this up. We’ve been able to reproduce this and we’ll release an update fixing this issue very soon. In the meantime you can ignore these logs because it’s actually expected this query to sometimes fail and it generally won’t cause any issue.

    Thread Starter Jan

    (@janerio)

    3 years, 2 months ago

    @tsteur thanks for your reply. I’m facing the issue that some of the reports (e.g. ecommerce) do not show any content and get a banner that archiving was not run displayed. I thought this is related, isn’t? It’s a standard installation with tag manager and activated ecommerce checkbox.

    Plugin Author Thomas

    (@tsteur)

    3 years, 2 months ago

    Hi @janerio to better understand do you mind posting your system report? See https://matomo.org/faq/wordpress/how-do-i-find-and-copy-the-system-report-in-matomo-for-wordpress/ and the output should be anonymised automatically

    Thread Starter Jan

    (@janerio)

    3 years, 2 months ago

    @tsteur :

    # 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.1 (Install date: 2020-12-30 20:00:51)
    * 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 22:26:10
    * Blog-Zeit: 2021-01-27 23:26:10 (Die nachfolgenden Daten werden in der Blog-Zeitzone angezeigt)
    * Sync users & sites: Next run: 2021-01-28 20:00:50 (20 Stunden 34 Minuten) ( Last started: 2021-01-27 20:17:14 (-3 Stunden 8 Minuten). Last ended: 2021-01-27 20:17:15 (-3 Stunden 8 Minuten). Interval: daily)
    * Archive: Next run: 2021-01-28 00:00:50 (34 Minuten 40s) ( Last started: 2021-01-27 23:02:16 (-23 Minuten 54s). Last ended: 2021-01-27 20:17:16 (-3 Stunden 8 Minuten). Interval: hourly)
    * Update GeoIP DB: Next run: 2021-01-29 20:00:50 (1 Tage 20 Stunden) ( Last started: 2020-12-30 20:12:28 (-28 Tage 3 Stunden). Last ended: 2020-12-30 20:12:30 (-28 Tage 3 Stunden). 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
    * Maximale Packetgröße: ok
    * 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: tagmanager
    * Track codeposition: header
    * Track api endpoint: default
    * Track js endpoint: default
    * Version history: 4.1.2, 4.1.1
    * Core version: 4.1.1
    * Last tracking settings update: 1611526061
    * Track search: Yes
    * Track user id: email
    * Last settings update: 1611526061
    * Mail history: 2021-01-25 00:02:19, 2021-01-18 00:15:44, 2021-01-17 22:18:43
    * Show get started page: 0

    ## Logs

    * Warning archive_main: 2021-01-27 21:02: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 21:02: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\\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 {“idarchives”:[3131],”nb_visits”:”74″}\” ‘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”:[3134],”nb_visits”:117}\” ‘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”:[3139],”nb_visits”:406}\” ‘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”:[3142],”nb_visits”:406}\” ‘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 22:02: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 22:02: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\\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 {“idarchives”:[3145],”nb_visits”:”77″}\” ‘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”:[3148],”nb_visits”:120}\” ‘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”:[3151],”nb_visits”:409}\” ‘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”:[3154],”nb_visits”:409}\” ‘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 23:02:30 (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 23:02:30 (‘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\\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 {“idarchives”:[3157],”nb_visits”:”83″}\” ‘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”:[3160],”nb_visits”:126}\” ‘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”:[3163],”nb_visits”:415}\” ‘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”:[3166],”nb_visits”:415}\” ‘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;)

    # 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: Yes
    * FORCE_SSL_ADMIN: Yes
    * WP_CACHE: Yes
    * CONCATENATE_SCRIPTS: Yes
    * COMPRESS_SCRIPTS: Yes
    * COMPRESS_CSS: Yes
    * ENFORCE_GZIP: Yes
    * 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

    * BigBuy Dropshipping Connector for WooCommerce: 1.2.12
    * Contact Form 7: 5.3.2
    * Easy WP SMTP: 1.4.5
    * Facebook for WooCommerce: 2.2.0
    * Germanized for WooCommerce: 3.3.5
    * Germanized for WooCommerce Pro: 3.1.4
    * Marketing Campaigns Reporting (Matomo Plugin): 4.0.4
    * Matomo Analytics – Ethical Stats. Powerful Insights.: 4.1.2
    * Matomo Marketplace for WordPress: 1.0.8
    * Monetization Code plugin: 1.0
    * Newsletter: 7.0.2
    * Newsletter – Addons Manager: 1.1.3
    * Newsletter – Contact Form 7: 4.1.9
    * Newsletter – Facebook: 4.0.9
    * Newsletter – Geo Resolver: 1.1.0
    * Newsletter – Reports and Retargeting: 4.3.7
    * Newsletter – WooCommerce: 1.6.0
    * PayPal PLUS for WooCommerce: 2.2.1
    * Rank Math SEO: 1.0.56.1
    * Vendidero Helper: 1.3.0
    * WooCommerce: 4.9.2
    * Active Plugins: 21 (MarketingCampaignsReporting bigbuy-wc-dropshipping-connector contact-form-7 easy-wp-smtp facebook-for-woocommerce matomo-marketplace-for-wordpress matomo mplugin.php newsletter-cf7 newsletter-extensions newsletter-facebook newsletter-geo newsletter-reports newsletter-woocommerce newsletter seo-by-rank-math vendidero-helper woo-paypalplus woocommerce-germanized-pro woocommerce-germanized woocommerce)
    * Theme: flatsome (flatsome)

    # Server

    * Server Info: Apache/2.4.38 (Debian)
    * PHP OS: Linux
    * PHP Version: 7.4.12
    * PHP SAPI: fpm-fcgi
    * PHP Binary Name: php-fpm7.4
    * PHP Found Binary: php -q
    * Timezone: UTC
    * WP timezone: Europe/Berlin
    * Locale: de_DE
    * User Locale: de_DE
    * Memory Limit: 1024M (At least 128MB recommended. Depending on your traffic 256MB or more may be needed.)
    * WP Memory Limit: 40M
    * WP Max Memory Limit: 1024M
    * Timezone version: 0.system
    * Time: 1611786370
    * Max Execution Time: 3600
    * Max Post Size: 1024M
    * Max Upload Size: 1073741824
    * Max Input Vars: 1000
    * Disabled PHP functions: Yes (pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,)
    * zlib.output_compression is off: Yes
    * Curl Version: 7.64.0, OpenSSL/1.1.1g
    * Suhosin installed: No

    # Database

    * MySQL Version: 5.5.5
    * Mysqli Connect: Yes
    * Force MySQL over Mysqli: No
    * DB Prefix: wp_
    * DB CHARSET: utf8mb4
    * DB COLLATE: utf8mb4_unicode_520_ci
    * SHOW ERRORS: No
    * SUPPRESS ERRORS: No
    * Uses Socket: No
    * Uses IPv6: No
    * Matomo tables found: 60
    * Matomo users found: 3
    * 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

    Plugin Author Thomas

    (@tsteur)

    3 years, 2 months ago

    @janerio any chance you can update to the version we just released and then in the WP Admin dashboard go to

    Matomo Analytics -> Diagnostics -> Troubleshooting

    And click on the “Archive reports” button there? Just in case it is somehow related to the bug we fixed. You could then check if reports appear or if it shows any error message.

    Thread Starter Jan

    (@janerio)

    3 years, 2 months ago

    @tsteur update fixed the issue. Thanks a lot 🙂

    Thread Starter Jan

    (@janerio)

    3 years, 2 months ago

    no errors in the logs anymore but still no data in ecommerce reports. Is there anything special to be configured if tag manager is used? Just have it installed with normal tracking and scroll analysis.

    Thread Starter Jan

    (@janerio)

    3 years, 2 months ago

    @tsteur just had some sales but do not see them in e-commerce reports. Now errors in log.

    Plugin Author Thomas

    (@tsteur)

    3 years, 2 months ago

    Hi @janerio sorry for the late reply. Could you maybe send me a link to our site either as a comment here or by email to wordpress@matomo.org ? I’d then try to debug and see if I find the issue there maybe.

    Thread Starter Jan

    (@janerio)

    3 years, 2 months ago

    Hi @tsteur, yes, for sure:

    https://gluecklich.shop

    I’ve checked the e-commerce checkbox in settings and have the tag manager activated. Tag is published with normal matomo tracking configuration for pageviews and scroll depth measurement.

    Thanks a lot
    Jan

    Plugin Author Thomas

    (@tsteur)

    3 years, 2 months ago

    Hi @janerio I likely have a patch to fix this issue. Are you familiar with patching files in your WordPress?

    If so, could you try this patch: https://github.com/matomo-org/wp-matomo/pull/421/files

    where the files wp-content/plugins/matomo/classes/WpMatomo/Ecommerce/Base.php and wp-content/plugins/matomo/classes/WpMatomo/Ecommerce/Woocommerce.php would need to be changed.

    Thread Starter Jan

    (@janerio)

    3 years, 2 months ago

    Hi @tsteur sorry, but I do not have a system with installed “patch” available at the moment.

    Plugin Author Thomas

    (@tsteur)

    3 years, 2 months ago

    All good @janerio I’m quite confident this problem should be resolved with our next update. I’ll mark this issue as resolved for now but feel free to comment if the issue still happens after the next update. As for timing I think there should be a new release in the next 2 weeks.

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Archive Warning: Error unserializing & wp_matomo_logtmpsegment’ is closed to new replies.