Data changes to 0

[Glomon06]

hi, I installed Matomo with the Wordpress module. I send myself monthly reports.

Once a month in the last visits report, I have a day that goes to 0 visits while in the database I have many visits. The report of June 17 is ok but from June 18, the report indicates 0 for the day of June 8.

[mattmary]

Hi @Glomon06

I hope I did not make mistakes in the dates. Please update the following SQL query if they do not match your 0 visits data. Could you execute this query and give me the result?

select * from wp_matomo_archive_numeric_2022_06 where date1 = '2022-06-08' and date2 = '2022-06-08' and name = 'nb_visits' union select * from wp_matomo_archive_numeric_2022_05 where date1 = '2022-05-05' and date2 = '2022-05-05' and name = 'nb_visits';

The table prefix wp_ could be different on your website: this is the content of the variable $table_prefix you'll find in your wp-config.php file.

Kind regards

Mat

[Glomon06]

Hi here are the results :

idarchive	name	idsite	date1	date2	period	ts_archived	value
7512	nb_visits	1	08/06/2022	08/06/2022	1	22/06/2022 14:01	2758
7513	nb_visits	1	08/06/2022	08/06/2022	1	22/06/2022 14:01	941
8364	nb_visits	1	05/05/2022	05/05/2022	1	23/05/2022 13:15	2898
8365	nb_visits	1	05/05/2022	05/05/2022	1	23/05/2022 13:15	783

[Glomon06]

I have the same problem for 9 july ...

[mattmary]

Hi @Glomon06

thank you.

You are on the UTC+1 timezone, right? Can you also give me the result of this query?

select * from wp_matomo_archive_numeric_2022_06 where date1 = '2022-06-07' and date2 = '2022-06-07' and name = 'nb_visits' union select * from wp_matomo_archive_numeric_2022_05 where date1 = '2022-05-04' and date2 = '2022-05-04' and name = 'nb_visits' union select * from wp_matomo_archive_numeric_2022_07 where date1 = '2022-07-09' and date2 = '2022-07-09' and name = 'nb_visits' union select * from wp_matomo_archive_numeric_2022_07 where date1 = '2022-07-08' and date2 = '2022-07-08' and name = 'nb_visits';

Can you also remove this line from your configuration? define(‘MATOMO_SUPPORT_ASYNC_ARCHIVING’, false);

And can you post your system report available from the menu Matomo Analytics > Diagnostics?

Kind regards

[Glomon06]

hi I'm french. for the query :

idarchive	name	idsite	date1	date2	period	ts_archived	value
2049	nb_visits	1	07/06/2022	07/06/2022	1	08/06/2022 00:42	3991
2052	nb_visits	1	07/06/2022	07/06/2022	1	08/06/2022 00:42	3045
2053	nb_visits	1	07/06/2022	07/06/2022	1	08/06/2022 00:42	946
2196	nb_visits	1	04/05/2022	04/05/2022	1	07/05/2022 02:42	3650
2254	nb_visits	1	04/05/2022	04/05/2022	1	07/05/2022 05:43	2914
2271	nb_visits	1	04/05/2022	04/05/2022	1	07/05/2022 06:42	736
4281	nb_visits	1	09/07/2022	09/07/2022	1	13/07/2022 09:36	1135
4282	nb_visits	1	09/07/2022	09/07/2022	1	13/07/2022 09:36	369
2633	nb_visits	1	08/07/2022	08/07/2022	1	09/07/2022 00:03	2122
2636	nb_visits	1	08/07/2022	08/07/2022	1	09/07/2022 00:03	1598
2637	nb_visits	1	08/07/2022	08/07/2022	1	09/07/2022 00:03	524

I have remove define(‘MATOMO_SUPPORT_ASYNC_ARCHIVING’, false);

My Matomo Diagnostics :

			  # Matomo

• Version de l’extension Matomo: 4.10.0
• Config existe et est accessible en écriture.: Oui ("$abs_path/wp-content/uploads/matomo/config/config.ini.php" )
• JS Tracker existe et est accessible en écriture.: Oui ("$abs_path/wp-content/uploads/matomo/matomo.js" )
• Répertoires de l’extension: Yes ([{"pluginsPathAbsolute":"$abs_path/wp-content/plugins/matomo/plugins","webrootDirRelativeToMatomo":"../"}])
• Répertoire temporaire accessible en écriture: Yes ($abs_path/wp-content/cache/matomo)
• Version de Matomo: 4.10.0
• idSite du site web Matomo: 1
• Version installée de Matomo: 4.6.0 (Install date: 2022-03-09 16:42:25)
• 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

• Heure du serveur: 2022-07-15 06:58:59
• Heure du site web: 2022-07-15 08:58:59 (Les dates ci-dessous sont affichées dans le fuseau horaire du site web)
• Sync users & sites: Next run: 2022-07-15 11:03:27 (2 heures 4 min) ( Last started: 2022-07-14 11:03:43 (-21 heures 55 min). Last ended: 2022-07-14 11:03:43 (-21 heures 55 min). Interval: daily)
• Archive: Next run: 2022-07-15 09:03:27 (4 min 28s) ( Last started: 2022-07-15 08:03:27 (-55 min 32s). Last ended: 2022-07-15 08:03:33 (-55 min 26s). Interval: hourly)
• Update GeoIP DB: Next run: 2022-08-05 11:03:27 (21 jours 2 heures) ( Last started: 2022-07-06 11:03:27 (-8 jours 21 heures). Last ended: 2022-07-06 11:03:33 (-8 jours 21 heures). Interval: matomo_monthly)

Contrôles obligatoires

• Version PHP >= : ok
• PDO Extension: ok
• PDO\MYSQL Extension: ok
• MYSQLI Extension: ok
• Autres extensions requises: ok
• Fonctions requises: ok
• Configuration PHP requise (php.ini): ok
• Répertoires avec les droits d'accès en écriture: ok
• Répertoires avec accès en écriture pour Gestionnaire de balises: ok

Contrôles facultatifs

• Binaire PHP 64 bits: ok
• État du traqueur: ok
• Limite mémoire: ok
• Fuseau horaire: ok
• Ouvrir l'URL: ok
• PageSpeed est désactivé: ok
• GD > 2.x + FreeType (graphics): ok
• Autres extensions: ok
• Autres fonctions: ok
• Système de fichiers: ok
• Dernière exécution d'archivage réussie: ok
• Capacités de la base de données: ok
• Taille maximale des paquets: ok
• Géolocalisation: ok
• Mettre à jour via HTTPS: ok
• Supports Async Archiving: No
• Location provider ID: geoip2php
• Location provider available: Yes
• Location provider working: Yes
• Had visit in last 5 days: Yes
• Matomo URL: Yes ($site_url/wp-content/plugins/matomo/app/)

Matomo Settings

• Track mode: default
• Track codeposition: footer
• Track api endpoint: default
• Track js endpoint: default
• Version history: 4.10.0, 4.6.0
• Core version: 4.10.0
• Last tracking settings update: 1655971648
• Last settings update: 1655971648
• Show get started page: 0
• Track content: visible
• Track ecommerce: No
• Track 404: Yes
• Track jserrors: Yes
• Mail history: 2022-07-14 23:03:35, 2022-07-13 23:03:49, 2022-07-12 23:03:35

Logs

• Aucun:

WordPress

• Home URL: $site_url
• Site URL: $site_url
• WordPress Version: 6.0.1
• Number of blogs: 1
• Multisite Enabled: No
• Network Enabled: No
• WP_DEBUG: Yes
• WP_DEBUG_DISPLAY: No
• WP_DEBUG_LOG: Yes
• DISABLE_WP_CRON: -
• FORCE_SSL_ADMIN: Yes
• WP_CACHE: No
• CONCATENATE_SCRIPTS: -
• COMPRESS_SCRIPTS: -
• COMPRESS_CSS: -
• ENFORCE_GZIP: -
• WP_LOCAL_DEV: -
• WP_CONTENT_URL: $site_url/wp-content
• WP_CONTENT_DIR: $abs_path/wp-content
• UPLOADS: -
• BLOGUPLOADDIR: -
• 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: Yes
• MATOMO_SAFE_MODE: -
• MATOMO_GLOBAL_UPLOAD_DIR: -
• MATOMO_LOGIN_REDIRECT: -
• Permalink Structure: /%postname%/
• Possibly uses symlink: No
• Upload base url: $site_url/wp-content/uploads
• Upload base dir: $abs_path/wp-content/uploads
• Upload url: $site_url/wp-content/uploads/2022/07
• Custom upload_path:
• Custom upload_url_path:
• Compatible content directory: Yes

WordPress Plugins

• Advanced Custom Fields: 5.12.2
• Advanced Custom Fields PRO: 5.9.1
• Advanced Editor Tools (previously TinyMCE Advanced): 5.6.0
• Broken Link Checker: 1.11.16
• Contact Form 7: 5.6
• Matomo Analytics - Ethical Stats. Powerful Insights.: 4.10.0
• Nested Pages: 3.1.21
• Newsletter: 7.5.0
• Ninja Forms: 3.6.12
• Ninja Forms - Layout & Styles: 3.0.25
• Polylang: 3.2.5
• Secondary Title: 2.0.8
• Simple Custom CSS and JS: 3.40
• tarteaucitron.js - Cookies legislation & GDPR: 1.6.4
• WPFront Scroll Top: 2.0.7.08086
• WP Table Builder: 1.4.2
• Yoast SEO: 19.3
• Active Plugins: 15 (polylang advanced-custom-fields-pro-master advanced-custom-fields broken-link-checker contact-form-7 custom-css-js matomo ninja-forms-layout-styles-develop ninja-forms secondary-title tinymce-advanced wordpress-seo wp-nested-pages wp-table-builder wpfront-scroll-top)
• Theme: frontaliers (frontaliers)

Server

• Server Info: Apache
• PHP OS: Linux
• PHP Version: 7.4.30
• PHP SAPI: fpm-fcgi
• PHP Binary Name: php-fpm
• PHP Error Reporting: 0 After bootstrap: 0
• Timezone: UTC
• WP timezone: Europe/Paris
• Locale: fr_FR
• User Locale: fr_FR
• Memory Limit: 256M (At least 128MB recommended. Depending on your traffic 256MB or more may be needed.)
• WP Memory Limit: 40M
• WP Max Memory Limit: 256M
• Timezone version: 2021.1
• Time: 1657868339
• Max Execution Time: 300
• Max Post Size: 64M
• Max Upload Size: 33554432
• Max Input Vars: 20000
• Disabled PHP functions: No
• zlib.output_compression is off: Yes
• Curl Version: 7.29.0, NSS/3.53.1
• Suhosin installed: No

Database

• MySQL Version: 5.7.34
• Mysqli Connect: Yes
• Force MySQL over Mysqli: No
• DB Prefix: wp_
• DB CHARSET: utf8mb4
• DB COLLATE:
• SHOW ERRORS: No
• SUPPRESS ERRORS: No
• Uses Socket: No
• Uses IPv6: No
• Matomo tables found: 159
• DB tables exist: Yes
• Matomo users found: 10
• Matomo sites found: 1
• Permissions obligatoires: OK

Browser

• Browser: (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36)
• Language: fr-fr,fr,en-us,en,de

[mattmary]

Hi @Glomon06

In two following reports, are you able to reproduce this 0 value error at the same date? Or it happens only in the first report following this date? Can you give me the output of this following SQL query? select * from wp_matomo_report where deleted = 0 \G wp_ is your wordpress table prefix. You should replace it by your wordpress table prfix (defined in your wp-config.php file) if you use a custom one. Kind regards

Mat

[Glomon06]

hi @mattmary , I think the problem recurs every month at the same time.

Result SQL query :

idreport	idsite	login	description	idsegment	period	hour	type	format	reports	parameters	ts_created	ts_last_sent	deleted	evolution_graph_within_period	evolution_graph_period_n	period_param
1	1	admin	Rapport Matomo frontaliers	NULL	day	23	email	html	["VisitsSummary_get"]	{"displayFormat":"1","emailMe":true,"evolutionGraph":false}	30/05/2022 13:46	21/07/2022 23:03	0	1	30	day

wp_ is my wordpress table prefix.

[mattmary]

Hi @Glomon06

Thanks. So from one month to the other you have at the same dates a 0 value for specific dates, right?

Kind regards

Mat

[mattmary]

Hi @Glomon06

Any chances you read my previous comment?

Kind regards

Mat

[mattmary]

Hi @Glomon06

Without any answers, I close this issue. Feel free to open a new one if you request any further support.

Kind regards

Mat