New Vegas Casino sister sites.Enjoy Free 888+200 Daily Legal Bonus

Forum Replies Created

Viewing 4 replies - 16 through 19 (of 19 total)

← 1 2

Forum: Plugins
In reply to: [Matomo Analytics - Ethical Stats. Powerful Insights.] Archive Warning: Error unserializing & wp_matomo_logtmpsegment

Thread Starter Jan
(@janerio)

4 years, 1 month 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.

Forum: Plugins
In reply to: [Matomo Analytics - Ethical Stats. Powerful Insights.] Archive Warning: Error unserializing & wp_matomo_logtmpsegment

Thread Starter Jan
(@janerio)

4 years, 1 month ago

@tsteur update fixed the issue. Thanks a lot ??

Forum: Plugins
In reply to: [Matomo Analytics - Ethical Stats. Powerful Insights.] Archive Warning: Error unserializing & wp_matomo_logtmpsegment

Thread Starter Jan
(@janerio)

4 years, 1 month 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

Forum: Plugins
In reply to: [Matomo Analytics - Ethical Stats. Powerful Insights.] Archive Warning: Error unserializing & wp_matomo_logtmpsegment

Thread Starter Jan
(@janerio)

4 years, 1 month 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.

Viewing 4 replies - 16 through 19 (of 19 total)

← 1 2