• Resolved arfufu

    (@arfufu)


    Bonjour!

    Thanks a lot for this ethical analytics.
    Unfortunately everything looks to work fine except for the reports. I have all visitor logs, and can have the daily reports for each day, but as soon as I want to see weekly or monthly report I have no data at all.
    I checked my DB and even invalidated with your extra plugin / manually emptied all the report tables (blob), but I still get no data and these errors (below). When I try to display again a weekly report, it doesn’t work but the related table in PhPmyAdmin has created many rows (so it seems to be working at the end???)

    Background: I have PHP 7.X , OVH Pro, so I can’t update the settings of MySQL to increase max_allowed_packet. I don’t remeber exactly but I think I tried to install matomo manually before you relaeased the WP plugin, I didn’t manage to make it work, and I installed the WP plugin recently -in march (maybe there is a conflict with the old installation?). I’m not very technical I would need some help sorry.

    Thank you ??

    Diagnostics=
    Dernière exécution d’archivage réussie error L’archivage s’est exécuté avec succès le Samedi 7 mars 2020 17:40:04 soit il y a 45 jours 11:33:22

    Taille maximale des paquets warning Il est important de configurer une taille ‘max_allowed_packet’ dans votre base de données MySQL d’au moins 64MB. 32MB configuré en ce moment.

    archive_main 2020-04-22 04:50:40 1 total errors during this script execution, please investigate and try and fix these errors. => CronArchive.php:602; CronArchive.php:595; CronArchive.php:330; Access.php:644; CronArchive.php:331; ScheduledTasks.php:225; class-wp-hook.php:285; class-wp-hook.php:311; plugin.php:544; wp-cron.php:138;

    Trouleshooting / create the archiving reports =
    Matomo Archive Warnings: ‘Empty or invalid response \’?a:52:{s:10:”2020-03-02″;a:19:{s:35:”Referrers_visitorsFromSearchEngines”;i:0;s:36:”Referrers_visitorsFromSocialNetworks”;i:0;s:33:”Referrers_visitorsFromDirectEntry”;i:0;s:30:”Referrers_visitorsFromWebsites”;i:0;s:31:”Referrers_visitorsFromCampaigns”;i:0;s:41:”Referrers_visitorsFromDirectEntry_percent”;s:2:”0%”;s:43:”Referrers_visitorsFromSearchEngines_percent”;s:2:”0%”;s:39:”Referrers_visitorsFromCampaigns_percent”;s:2:”0%”;s:44:”Referrers_visitorsFromSocialNetworks_percent”;s:2:”0%”;s:38:”Referrers_visitorsFromWebsites_percent”;s:2:”0%”;s:11:”bounce_rate”;s:2:”0%”;s:20:”nb_actions_per_visit”;i:0;s:16:”avg_time_on_site”;i:0;s:26:”avg_time_on_site_returning”;i:0;s:30:”nb_actions_per_visit_returning”;i:0;s:21:”bounce_rate_returning”;s:2:”0%”;s:20:”avg_time_on_site_new”;i:0;s:24:”nb_actions_per_visit_new”;i:0;s:15:”bounce_rate_new”;s:2:”0%”;}s:10:”2020-03-03″;a:19:{s:35:”Referrers_visitorsFromSearchEngines”;i:0;s:36:”Referrers_visitorsFromSocialNetworks”;i:0;s:33:”Referrers_visitorsFromDirectEntry”;i:0;s:30:”Referrers_visitorsFromWebsites”;i:0;s:31:”Referrers_visitorsFromCampaigns”;i:0;s:41:”Referrers_visitorsFromDirectEntry_percent”;s:2:”0%”;s:43:”Referrers_visitorsFromSearchEngines_percent”;s:2:”0%”;s:39:”Referrers_visitorsFromCampaigns_percent”;s:2:”0%”;s:44:”Referrers_visitorsFromSocialNetworks_percent”;s:2:”0%”;s:38:”Referrers_visitorsFromWebsites_percent”;s:2:”0%”;s:11:”bounce_rate”;s:2:”0%”;s:20:”nb_actions_per_visit”;i:0;s:16:”avg_time_on_site”;i:0;s:26:”avg_time_on_site_returning”;i:0;s:30:”nb_actions_per_visit_returning”;i:0;s:21:”bounce_rate_returning”;s:2:”0%”;s:20:”avg_time_on_site_new”;i:0;s:24:”nb_actions_per_visit_new”;i:0;s:15:”bounce_rate_new”;s:2:”0%”;}s:10:”2020-03-04″;a:19:{s:35:”Referrers_visitorsFromSearchEngines”;i:0;s:36:”Referrers_visitorsFromSocialNetworks”;i:0;s:33:”Referrers_visitorsFromDirectEntry”;i:0;s:30:”Referrers_visitorsFromWebsites”;i:0;s:31:”Referrers_visitorsFromCampaigns”;i:0;s:41:”Referrers_visitorsFromDirectEntry_percent”;s:2:”0%”;s:43:”Referrers_visitorsFromSearchEngines_percent”;s:2:”0%”;s:39:”Referrers_visitorsFromCampaigns_percent”;s:2:”0%”;s:44:”Referrers_visitorsFromSocialNetworks_percent”;s:2:”0%”;s:38:”Referrers_visitorsFromWebsites_percent”;s:2:”0%”;s:11:”bounce_rate”;s:2:”0%”;s:20:”nb_actions_per_visit”;i:0;s:16:”avg_time_on_site”;i:0;s:26:”avg_time_on_site_returning”;i:0;s:30:”nb_actions_per_visit_returning”;i:0;s:21:”bounce_rate_returning”;s:2:”0%”;s:20:”avg_time_on_site_new”;i:0;s:24:”nb_actions_per_visit_new”;i:0;s:15:”bounce_rate_new”;s:2:”0%”;}s:10:”2020-03-05″;a:19:{s:35:”Referrers_visitorsFromSearchEngines”;i:0;s:36:”Referrers_visitorsFromSocialNetworks”;i:0;s:33:”Referrers_visitorsFromDirectEntry”;i:0;s:30:”Referrers_visitorsFromWebsites”;i:0;s:31:”Referrers_visitorsFromCampaigns”;i:0;s:41:”Referrers_visitorsFromDirectEntry_percent”;s:2:”0%”;s:43:”Referrers_visitorsFromSearchEngines_percent”;s:2:”0%”;s:39:”Referrers_visitorsFromCampaigns_percent”;s:2:”0%”;s:44:”Referrers_visitorsFromSocialNetworks_percent”;s:2:”0%”;s:38:”Referrers_visitorsFromWebsites_percent”;s:2:”0%”;s:11:”bounce_rate”;s:2:”0%”;s:20:”nb_actions_per_visit”;i:0;s:16:”avg_time_on_site”;i:0;s:26:”avg_time_on_site_returning”;i:0;s:30:”nb_actions_per_visit_returning”;i:0;s:21:”bounce_rate_returning”;s:2:”0%”;s:20:”avg_time_on_site_new”;i:0;s:24:”nb_actions_per_visit_new”;i:0;s:15:”bounce_rate_new”;s:2:”0%”;}s:10:”2020-03-06″;a:19:{s:35:”Referrers_visitorsFromSearchEngines”;i:0;s:36:”Referrers_visitorsFromSocialNetworks”;i:0;s:33:”Referrers_visitorsFromDirectEntry”;i:0;s:30:”Referrers_visitorsFromWebsites”;i:0;s:31:”Referrers_visitorsFromCampaigns”;i:0;s:41:”Referrers_visitorsFromDirectEntry_percent”;s:2:”0%”;s:43:”Referrers_visitorsFromSearchEngines_percent”;s:2:”0%”;s:39:”Referrers_visitorsFromCampaigns_percent”;s:2:”0%”;s:44:”Referrers_visitorsFromSocialNetworks_percent”;s:2:”0%”;s:38:”Referrers_visitorsFromWebsites_percent”;s:2:”0%”;s:11:”bounce_rate”;s:2:”0%”;s:20:”nb_actions_per_visit”;i:0;s:16:”avg_time_on_site”;i:0;s:26:”avg_time_on_site_returning”;i:0;s:30:”nb_actions_per_visit_returning”;i:0;s:21:”bounce_rate_returning”;s:2:”0%”;s:20:”avg_time_on_site_new”;i:0;s:24:”nb_actions_per_visit_new”;i:0;s:15:”bounce_rate_new”;s:2:”0%”;}s:10:”2020-03-07″;a:19:{s:35:”Referrers_visitorsFromSearchEngines”;i:0;s:36:”Referrers_visitorsFromSocialNetworks”;i:0;s:33:”Referrers_visitorsFromDirectEntry”;i:0;s:30:”Referrers_visitorsFromWebsites”;i:0;s:31:”Referrers_visitorsFromCampaigns”;i:0;s:41:”Referrers_visitorsFromDirectEntry_percent”;s:2:”0%”;s:43:”Referrers_visitorsFromSearchEngines_percent”;s:2:”0%”;s:39:”Referrers_visitorsFromCampaigns_percent”;s:2:”0%”;s:44:”Referrers_visitorsFromSocialNetworks_percent”;s:2:”0%”;s:38:”Referrers_visitorsFromWebsites_percent”;s:2:”0%”;s:11:”bounce_rate”;s:2:”0%”;s:20:”nb_actions_per_visit”;i:0;s:16:”avg_time_on_site”;i:0;s:26:”avg_time_on_site_returning”;i:0;s:30:”nb_actions_per_visit_returning”;i:0;s:21:”bounce_rate_returning”;s:2:”0%”;s:20:”avg_time_on_site_new”;i:0;s:24:”nb_actions_per_visit_new”;i:0;s:15:”bounce_rate_new”;s:2:”0%”;}s:10:”2020-03-08″;a:19:{s:35:”Referrers_visitorsFromSearchEngines”;i:0;s:36:”Referrers_visitorsFromSocialNetworks”;i:0;s:33:”Referrers_visitorsFromDirectEntry”;i:0;s:30:”Referrers_visitorsFromWebsites”;i:0;s:31:”Referrers_visitorsFromCampaigns”;i:0;s:41:”Referrers_visitorsFromDirectEntry_percent”;s:2:”0%”;s:43:”Referrers_visitorsFromSearchEngines_percent”;s:2:”0%”;s:39:”Referrers_visitorsFromCampaigns_percent”;s:2:”0%”;s:44:”Referrers_visitorsFromSocialNetworks_percent”;s:2:”0%”;s:38:”Referrers_visitorsFromWebsites_percent”;s:2:”0%”;s:11:”bounce_rate”;s:2:”0%”;s:20:”nb_actions_per_visit”;i:0;s:16:”avg_time_on_site”;i:0;s:26:”avg_time_on_site_returning”;i:0;s:30:”nb_actions_per_visit_returning”;i:0;s:21:”bounce_rate_returning”;s:2:”0%”;s:20:”avg_time_on_site_new”;i:0;s:24:”nb_actions_per_visit_new”;i:0;s:15:”bounce_rate_new”;s:2:”0%”;}s:10:”2020-03-09″;a:19:{s:35:”Referrers_vi’
    ‘1 total errors during this script execution, please investigate and try and fix these errors.’
    ‘1 total errors during this script execution, please investigate and try and fix these errors.’

Viewing 4 replies - 16 through 19 (of 19 total)
  • Plugin Author Thomas

    (@tsteur)

    Glad it seems to be ok now.

    You can definitely ignore the warning around 32MB/64MB.

    Not quite sure what you mean with another database? We only support MySQL. However, you can install Matomo On-Premise in another database see https://matomo.org/docs/installation/ It is then completely separated from WordPress and tracking and reporting UI should be faster as the WordPress part is gone.

    Thread Starter arfufu

    (@arfufu)

    I meant that with OVH “pro” we can have more than 1 MySQL for the same server, and I was wondering if I could set up matomo on another SQL than the one the website uses (if it would be beneficial?)
    I’ve seen we can with Matomo On-Premise but it’s more complicated than the “all-in-one” matomo WP plugin (Matoma Analytics) where we could change the settings on it for another database?
    ??

    • This reply was modified 4 years, 7 months ago by arfufu.
    Plugin Author Thomas

    (@tsteur)

    I see. It’s unfortunately not possible. That’s basically where you would need to use Matomo On-Premise unfortunately. Sorry I don’t have better news in regards to this.

    Plugin Author Thomas

    (@tsteur)

    @arfufu marking this issue as resolved for now. Feel free to comment again should the issue come up again.

Viewing 4 replies - 16 through 19 (of 19 total)
  • The topic ‘Archiving report issue – Weeks, months, years not working’ is closed to new replies.