koobm

Update: Now the log periodically shows errors from the cron run.

archive_main	2024-11-21 15:52:40	1 total errors during this script execution, please investigate and try and fix these errors. => CronArchive.php:473; CronArchive.php:468; CronArchive.php:226; Access.php:567; CronArchive.php:221; ScheduledTasks.php:378; class-wp-hook.php:322; class-wp-hook.php:348; plugin.php:565; wp-cron.php:191;
archive_errors	2024-11-21 15:52:40	'Got invalid response from API request: ?module=API&method=CoreAdminHome.archiveReports&idSite=1&period=year&date=2024-01-01&format=json&trigger=archivephp. Response was \'{"result":"error","message":"Label column not found in the table to add in addDataTable(). Row: array ( \'label\' => NULL, \'nb_visits\' => 1, \'nb_uniq_visitors\' => 1, ) - in plugin Actions."}\'' '1 total errors during this script execution, please investigate and try and fix these errors.' => ScheduledTasks.php:392; class-wp-hook.php:322; class-wp-hook.php:348; plugin.php:565; wp-cron.php:191;

Hi @dizzyatinnocraft, I can confirm this version fixed the freezing issue after import of the first day. All relevant days (a full year) were imported within roughly 30-45 minutes, no error messages occurred anymore. The importer looks good now from my perspective. Thanks a lot!

Unfortunately my SSH connection was lost and the process cancelled during the report generation phase (somewhere around 60-90 minutes in). Not sure if this is an actual problem, the daily/weekly/monthly visitor info is all there. Only some special reports (e.g. time of day; devices) look incomplete. Not too much of an issue, I could live with that. Just out of curiosity, I found that in Matomo onPremise the report generation can be re-initiated. Is there also a way to do so in the WordPress version?

Thanks and all the best!

Yes, I could do that.

Hey there,

Thanks, highly appreciate the quick response and your efforts! But I’m afraid that it didn’t work out as expected.
I reinstalled Matomo on my last site which hasn’t been migrated yet and ran the importer. This is the full log (DB name replaced) – after the first day it tried to import, it’s frozen:

[info] Starting wp-statistics import
[notice] Importing data for date 2023-11-16...
[info] Importing data for the PagesImporter plugin.
[debug] Import 0 search keywords...
[debug] Import 10 global pages...
[debug] Import 20 page titles...
[info] Importing data for the ReferrersImporter plugin.
[debug] Import 2 referrers...
WordPress database error Table '<DATABASE_NAME>.wp_statistics_search' doesn't exist for query select engine, count(visitor) AS nb from wp_statistics_search where last_counter = '2023-11-16' group by engine order by engine; made by include('phar:///usr/bin/wp-cli/php/boot-phar.php'), include('phar:///usr/bin/wp-cli/vendor/wp-cli/wp-cli/php/wp-cli.php'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->run_command_and_exit, WP_CLI\Runner->run_command, WP_CLI\Dispatcher\Subcommand->invoke, call_user_func, WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher\{closure}, call_user_func, WpMatomo\Commands\MatomoCommands->importWpStatistics, WpMatomo\WpStatistics\Importer->import, WpMatomo\WpStatistics\Importer->import_day, WpMatomo\WpStatistics\Importers\Actions\ReferrersImporter->import_records, WpMatomo\WpStatistics\Importers\Actions\ReferrersImporter->import_search_engines, WpMatomo\WpStatistics\Importers\Actions\ReferrersImporter->get_keywords_and_search_engine_records
[debug] Import 0 search engines...
[info] Importing data for the UserCountryImporter plugin.
[debug] Import 2 countries...
[debug] Import 6 regions...
[debug] Import 9 cities...
[info] Importing data for the DeviceDetectionImporter plugin.
[debug] Import 5 browsers...
[debug] Import 4 platforms...
[info] Importing data for the VisitorsImporter plugin.
[debug] Import 12 visits...
[info] Importing data for the VisitsTimeImporter plugin.

I found this commit in WP Statistics where they removed the whole DB table. Seems like that change was delivered with version 14.11 (the one in which they also announced the “Pro” version of their product), which according to their Github was rolled out 2 weeks ago.

I actually don’t care much about the referrer history, but the importer being frozen after day 1 is a real problem.

Same issue here. I’m using lastest version of Cerber on three sites, only on one of them the “Protect Admin Scripts” switch is inactive / greyed out. Can’t figure out the reason, settings are same on all sites.

Unfortunately this support forum doesn’t seem to get a lot of attention from the author, given the high number of unanswered threads.

Similar issue here. From time to time when performing any backend changes as an administrator (e.g. changing settings of backup or security plugins; (de-)activating plugins; …) and saving changes, the screen will reload as usual and without error messages – but settings will look just like prior to the change, all updated values are void.

I noticed that apcu seems to cause this issue. Only deleting all objects in APCu Manager helps, right after that action all changes which seemed to be lost are displayed correctly. So the database was updated, only the screen didn’t reflect it.

Same setup as thread starter: Shared hosting, latest WP core, PHP 8.1.

For now I’ll ask my co-admins to let me know when weird stuff happens in the backend, then I’ll delete all apcu objects. Permanent fix would be appreciated though.