Not sure why Matomo is trying to create tables from 2015-2016. I only have site data for a few months now.
[14-Nov-2022 15:51:27 UTC] WordPress database error Table ‘wp_matomo_archive_numeric_2016_01’ already exists for query CREATE TABLE wp_matomo_archive_numeric_2016_01 (
idarchive INTEGER UNSIGNED NOT NULL,
name VARCHAR(190) NOT NULL,
idsite INTEGER UNSIGNED NULL,
date1 DATE NULL,
date2 DATE NULL,
period TINYINT UNSIGNED NULL,
ts_archived DATETIME NULL,
value DOUBLE NULL,
PRIMARY KEY(idarchive, name),
INDEX index_idsite_dates_period(idsite, date1, date2, period, ts_archived),
INDEX index_period_archived(period, ts_archived)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
made by require_once(’/plugins/matomo/app/core/dispatch.php’), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\CoreHome\Controller->renderReportWidget, Piwik\Plugin\Report->render, Piwik\Plugins\CoreVisualizations\Visualizations\Sparkline->render, Piwik\Plugin\ViewDataTable->loadDataTableFromAPI, Piwik\ViewDataTable\Request->loadDataTableFromAPI, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API{closure}, call_user_func_array, Piwik\Plugins\API\API->get, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API{closure}, call_user_func_array, Piwik\Plugins\Actions\API->get, Piwik\Archive->getDataTableFromNumeric, Piwik\Archive->get, Piwik\Archive->getArchiveIds, Piwik\Archive->cacheArchiveIdsWithoutLaunching, Piwik\DataAccess\ArchiveSelector::getArchiveIds, Piwik\DataAccess\ArchiveTableCreator::getNumericTable, Piwik\DataAccess\ArchiveTableCreator::getTable, Piwik\DataAccess\ArchiveTableCreator::createArchiveTablesIfAbsent, Piwik\DataAccess\Model->createArchiveTable, Piwik\Db\Adapter\WordPress->query
[14-Nov-2022 15:51:27 UTC] WordPress database error Table ‘wp_matomo_archive_numeric_2017_01’ already exists for query CREATE TABLE wp_matomo_archive_numeric_2017_01 (
idarchive INTEGER UNSIGNED NOT NULL,
name VARCHAR(190) NOT NULL,
idsite INTEGER UNSIGNED NULL,
date1 DATE NULL,
date2 DATE NULL,
period TINYINT UNSIGNED NULL,
ts_archived DATETIME NULL,
value DOUBLE NULL,
PRIMARY KEY(idarchive, name),
INDEX index_idsite_dates_period(idsite, date1, date2, period, ts_archived),
INDEX index_period_archived(period, ts_archived)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
made by require_once(’/plugins/matomo/app/core/dispatch.php’), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\CoreHome\Controller->renderReportWidget, Piwik\Plugin\Report->render, Piwik\Plugins\CoreVisualizations\Visualizations\Sparkline->render, Piwik\Plugin\ViewDataTable->loadDataTableFromAPI, Piwik\ViewDataTable\Request->loadDataTableFromAPI, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API{closure}, call_user_func_array, Piwik\Plugins\API\API->get, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API{closure}, call_user_func_array, Piwik\Plugins\Actions\API->get, Piwik\Archive->getDataTableFromNumeric, Piwik\Archive->get, Piwik\Archive->getArchiveIds, Piwik\Archive->cacheArchiveIdsWithoutLaunching, Piwik\DataAccess\ArchiveSelector::getArchiveIds, Piwik\DataAccess\ArchiveTableCreator::getNumericTable, Piwik\DataAccess\ArchiveTableCreator::getTable, Piwik\DataAccess\ArchiveTableCreator::createArchiveTablesIfAbsent, Piwik\DataAccess\Model->createArchiveTable, Piwik\Db\Adapter\WordPress->query
[14-Nov-2022 15:51:27 UTC] WordPress database error Table ‘wp_matomo_archive_numeric_2015_01’ already exists for query CREATE TABLE wp_matomo_archive_numeric_2015_01 (
idarchive INTEGER UNSIGNED NOT NULL,
name VARCHAR(190) NOT NULL,
idsite INTEGER UNSIGNED NULL,
date1 DATE NULL,
date2 DATE NULL,
period TINYINT UNSIGNED NULL,
ts_archived DATETIME NULL,
value DOUBLE NULL,
PRIMARY KEY(idarchive, name),
INDEX index_idsite_dates_period(idsite, date1, date2, period, ts_archived),
INDEX index_period_archived(period, ts_archived)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
made by require_once(’/plugins/matomo/app/core/dispatch.php’), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\CoreHome\Controller->renderReportWidget, Piwik\Plugin\Report->render, Piwik\Plugins\CoreVisualizations\Visualizations\Sparkline->render, Piwik\Plugin\ViewDataTable->loadDataTableFromAPI, Piwik\ViewDataTable\Request->loadDataTableFromAPI, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API{closure}, call_user_func_array, Piwik\Plugins\API\API->get, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API{closure}, call_user_func_array, Piwik\Plugins\VisitsSummary\API->get, Piwik\Archive->getDataTableFromNumeric, Piwik\Archive->get, Piwik\Archive->getArchiveIds, Piwik\Archive->cacheArchiveIdsWithoutLaunching, Piwik\DataAccess\ArchiveSelector::getArchiveIds, Piwik\DataAccess\ArchiveTableCreator::getNumericTable, Piwik\DataAccess\ArchiveTableCreator::getTable, Piwik\DataAccess\ArchiveTableCreator::createArchiveTablesIfAbsent, Piwik\DataAccess\Model->createArchiveTable, Piwik\Db\Adapter\WordPress->query
[14-Nov-2022 15:51:27 UTC] WordPress database error Duplicate entry ‘wp_matomo_archive_numeric_2015_01’ for key ‘PRIMARY’ for query INSERT INTO wp_matomo_sequence (name, value) VALUES (‘wp_matomo_archive_numeric_2015_01’, ‘0’) made by require_once(’/plugins/matomo/app/core/dispatch.php’), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\CoreHome\Controller->renderReportWidget, Piwik\Plugin\Report->render, Piwik\Plugins\CoreVisualizations\Visualizations\Sparkline->render, Piwik\Plugin\ViewDataTable->loadDataTableFromAPI, Piwik\ViewDataTable\Request->loadDataTableFromAPI, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API{closure}, call_user_func_array, Piwik\Plugins\API\API->get, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API{closure}, call_user_func_array, Piwik\Plugins\Actions\API->get, Piwik\Archive->getDataTableFromNumeric, Piwik\Archive->get, Piwik\Archive->getArchiveIds, Piwik\Archive->cacheArchiveIdsWithoutLaunching, Piwik\DataAccess\ArchiveSelector::getArchiveIds, Piwik\DataAccess\ArchiveTableCreator::getNumericTable, Piwik\DataAccess\ArchiveTableCreator::getTable, Piwik\DataAccess\ArchiveTableCreator::createArchiveTablesIfAbsent, Piwik\DataAccess\Model->createArchiveTable, Piwik\Sequence->create, Piwik\Db\Adapter\WordPress->insert
[14-Nov-2022 15:51:27 UTC] WordPress database error Duplicate entry ‘wp_matomo_archive_numeric_2017_01’ for key ‘PRIMARY’ for query INSERT INTO wp_matomo_sequence (name, value) VALUES (‘wp_matomo_archive_numeric_2017_01’, ‘0’) made by require_once(’/plugins/matomo/app/core/dispatch.php’), Piwik\FrontController->dispatch, Piwik\FrontController->doDispatch, call_user_func_array, Piwik\Plugins\CoreHome\Controller->renderReportWidget, Piwik\Plugin\Report->render, Piwik\Plugins\CoreVisualizations\Visualizations\Sparkline->render, Piwik\Plugin\ViewDataTable->loadDataTableFromAPI, Piwik\ViewDataTable\Request->loadDataTableFromAPI, Piwik\API\Request->process, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API{closure}, call_user_func_array, Piwik\Plugins\API\API->get, Piwik\API\Proxy->call, Piwik\Context::executeWithQueryParameters, Piwik\API\Proxy->Piwik\API{closure}, call_user_func_array, Piwik\Plugins\Actions\API->get, Piwik\Archive->getDataTableFromNumeric, Piwik\Archive->get, Piwik\Archive->getArchiveIds, Piwik\Archive->cacheArchiveIdsWithoutLaunching, Piwik\DataAccess\ArchiveSelector::getArchiveIds, Piwik\DataAccess\ArchiveTableCreator::getNumericTable, Piwik\DataAccess\ArchiveTableCreator::getTable, Piwik\DataAccess\ArchiveTableCreator::createArchiveTablesIfAbsent, Piwik\DataAccess\Model->createArchiveTable, Piwik\Sequence->create, Piwik\Db\Adapter\WordPress->insert
[14-Nov-2022 15:51:27 UTC] WordPress database error Table ‘wp_matomo_archive_numeric_2016_01’ already exists for query CREATE TABLE wp_matomo_archive_numeric_2016_01 (