Thousand numbers are wrongly displayed in email reports #17747

Expected Behavior

Beautiful graphs should display numbers chars in email reports

Current Behavior

On email reports, (HTML or PDF format), the graphs display wrong chars for thousand numbers (squares instead of numbers).
The same in the preview mode of the reports.
Examples:

Possible Solution

No idea!

Steps to Reproduce (for Bugs)

1. Go to Administration cog >Personal > Email reports
2. Then create/edit a report on some data higher than 1000. The report must contain some graphs. The format can be HTML or PDF.
3. Send the report, or just download it.

Your Environment

Mandatory checks

Version PHP >= 7.2.5:

✔ 7.3.20

PDO Extension:

✔

PDO\MYSQL Extension:

✔

MYSQLI Extension:

✔

Extensions requises:

✔ zlib ✔ SPL ✔ iconv ✔ json ✔ mbstring ✔ Reflection ✔ filter ✔ hash ✔ session

Fonctions requises:

✔ debug_backtrace ✔ eval ✔ hash ✔ gzcompress ✔ gzuncompress ✔ pack

Configuration PHP requise (php.ini):

✔ session.auto_start = 0 ✔ max_execution_time = 0 OR >= 30

Répertoires avec les droits d'accès en écriture:

✔ $DOC_ROOT/tmp ✔ $DOC_ROOT/tmp/assets ✔ $DOC_ROOT/tmp/cache ✔ $DOC_ROOT/tmp/climulti ✔ $DOC_ROOT/tmp/latest ✔ $DOC_ROOT/tmp/logs ✔ $DOC_ROOT/tmp/sessions ✔ $DOC_ROOT/tmp/tcpdf ✔ $DOC_ROOT/tmp/templates_c

Répertoires avec accès en écriture pour Gestionnaire de balises:

✔ $DOC_ROOT/js/tics-manager

Extensions requises:

✔ openssl

Optional checks

Required Private Directories:

⚠ Warning: Unable to execute check for $MATOMO_URLconfig/config.ini.php: curl_exec: Peer's Certificate issuer is not recognized.. Hostname requested was: matomo..fr ⚠ Warning: Unable to execute check for $MATOMO_URLtmp/: curl_exec: Peer's Certificate issuer is not recognized.. Hostname requested was: matomo..fr ⚠ Warning: Unable to execute check for $MATOMO_URLtmp/empty: curl_exec: Peer's Certificate issuer is not recognized.. Hostname requested was: matomo..fr ⚠ Warning: Unable to execute check for $MATOMO_URLtmp/cache/tracker/matomocache_general.php: curl_exec: Peer's Certificate issuer is not recognized.. Hostname requested was: matomo..fr ⚠ Warning: Unable to execute check for $MATOMO_URLlang/en.json: curl_exec: Peer's Certificate issuer is not recognized.. Hostname requested was: matomo.*.fr ✔ All private directories are inaccessible from the internet.

Intégrité du fichier:

⚠ Warning: Le contrôle d'intégrité a échoué et a rapporté des erreurs. Vous devriez corriger ces problèmes puis rafraîchir cette page jusqu'à ce qu'il n'y ait plus d'erreur.

Des fichiers auxquels nous ne nous attendions pas ont été trouvés dans votre installation de Matomo.
--> Veuillez supprimer ces fichiers pour éviter d'avoir des erreurs.

Statut du traqueur:

✔

Limite mémoire:

✔ 128M

Fuseau horaire:

✔

Ouvrez l'URL:

✔ curl

PageSpeed désactivé:

✔

GD > 2.x + Freetype (graphiques):

✔

Autres extensions:

✔ json ✔ libxml ✔ dom ✔ SimpleXML ✔ openssl

Autres fonctions:

✔ shell_exec ✔ set_time_limit ✔ mail ✔ parse_ini_file ✔ glob ✔ gzopen ✔ md5_file

Système de fichiers:

✔

Paramétrer une tâche Cron (chargement plus rapide des rapports):

⚠ Warning: Pour des performances optimales et un Matomo rapide, il est vivement recommandé de mettre en place une entré CRON pour archiver automatiquement vos rapports, et de désactiver le déclanchement depuis l'interface depuis les paramètres Matomo. Apprenez-en plus.

Browser and Auto-archiving enabled:

⚠ Warning: It looks like both browser and auto archiving are enabled. Auto archiving last started 9 min 42s ago. If auto archiving is enabled, you should disable browser archiving in "General Settings".

Paramétrer une tâche Cron - Gestion des processus via la ligne de commande:

✔ Ok

Capacités de la base de données:

✔ UTF8mb4 charset ⚠ Warning: LOAD DATA INFILE
L'utilisation de LOAD DATA INFILE va grandement accélérer la vitesse du processus d'archivage de Matomo. Pour le rendre disponible à Matomo, essayez de mettre à jour PHP & MySQL et assurez-vous que votre utilisateur MySQL a les privilèges de FILE.
Si votre serveur Matomo suit des sites à fort trafic (ex. > 100000 pages par mois), nous recommandons d'essayer de corriger ce problème. ✔ CREATE TEMPORARY TABLES ✔ Changing transaction isolation level

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.

Connexion SSL forcée:

✔

Géolocalisation:

⚠ Warning: Le fournisseur de localisation par défaut devine le pays d'un visiteur en se basant sur le langage de son navigateur. Ceci n'est pas très précis, nous recommandons donc l'installation et l'utilisation d'une base de données de géolocalisation.

Mettre à jour via HTTPS:

✔

Traceur JavaScript inscriptible ("/matomo.js"):

✔

Heatmap & Session Recording Tracking:

⚠ Warning: Requesting '$MATOMO_URLplugins/HeatmapSessionRecording/configs.php?idsite=1&trackerid=5lX6EM&url=http%3A%2F%2Ftest.test%2F' resulted in an SSL error. Maybe you are using a self signed certificate? Please open the URL manually in a browser to see if the response contains 'Piwik.HeatmapSessionRecording'. If not, you might need to modify your server configuration as this file needs to be accessible via a browser from the Internet or Intranet.

Informational results

Matomo Version:

4.3.1

Matomo Update History:

4.0.5,

Matomo Install Version:

4.0.5

Latest Available Version:

Is Git Deployment:

0

PHP_OS:

Linux

PHP SAPI:

apache2handler

Timezone Version:

0.system

PHP Timezone:

UTC

PHP Time:

1625236784

PHP Datetime:

2021-07-02 14:39:44

PHP INI max_execution_time:

30

PHP INI post_max_size:

8M

PHP INI max_input_vars:

1000

PHP INI zlib.output_compression:

Curl Version:

7.29.0, NSS/3.44

Suhosin Installed:

0

DB Prefix:

matomo_

DB Charset:

utf8mb4

DB Adapter:

MYSQLI

MySQL Version:

5.7.32-enterprise-commercial-advanced-log

Num Tables:

90

Browser Segment Archiving Enabled:

1

Development Mode Enabled:

0

Internet Enabled:

1

Multi Server Environment:

1

Auto Update Enabled:

1

Custom User Path:

0

Custom Include Path:

0

Release Channel:

latest_stable

Plugins Activated:

API, AbTesting 4.0.6, Actions, ActivityLog 4.0.2, Annotations, BulkTracking, Cohorts 4.0.3, Contents, CoreAdminHome, CoreConsole, CoreHome, CorePluginsAdmin, CoreUpdater, CoreVisualizations, CustomDimensions, CustomJsTracker, CustomReports 4.0.7, DBStats, Dashboard, DevicePlugins, DevicesDetection, Diagnostics, Events, Feedback, Funnels 4.0.3, GeoIp2, Goals, Heartbeat, HeatmapSessionRecording 4.0.12, ImageGraph, Insights, Installation, Intl, IntranetMeasurable, LanguagesManager, Live, LoginLdap 4.3.0, LoginSaml 4.0.3, MobileMessaging, Monolog, Morpheus, MultiSites, Overlay, PagePerformance, PrivacyManager, Proxy, Referrers, Resolution, RssWidget, SEO, ScheduledReports, SearchEngineKeywordsPerformance 4.1.1, SegmentEditor, SitesManager, TagManager, Tour, Transitions, TwoFactorAuth, UserCountry, UserCountryMap, UserId, UserLanguage, UsersFlow 4.0.4, UsersManager, VisitFrequency, VisitTime, VisitorInterest, VisitsSummary, WebsiteMeasurable, WhiteLabel 4.0.2, Widgetize

Plugins Deactivated:

CustomVariables, Ecommerce, FormAnalytics 4.0.5, Login, Marketplace, MediaAnalytics 4.0.8, MobileAppMeasurable, MultiChannelConversionAttribution 4.0.5, ProfessionalServices, Provider, RollUpReporting 4.0.2, WooCommerceAnalytics 4.0.5

Plugins Invalid:

Server Info:

Apache

Had visits in last 1 day:

1

Had visits in last 3 days:

1

Had visits in last 5 days:

1

Archive Time Last Started:

1625236202

Archive Time Last Finished:

1625236611

User Agent:

Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0

Browser Language:

fr,fr-fr,en-us,en

Total Invalidation Count:

0

In Progress Invalidation Count:

0

Scheduled Invalidation Count:

0

Earliest invalidation ts_started:

Latest invalidation ts_started:

Earliest invalidation ts_invalidated:

Latest invalidation ts_invalidated:

Number of segment invalidations:

0

Number of plugin invalidations:

0

List of plugins being invalidated:

Anonymize Referrer:

Do Not Track enabled:

0

Just tested and this is working for me:

Can you tell me what language is configured for you in Matomo? And what locales are available on your server?

Hi @diosmosis ,
Thanks for your reply (sorry I was in vacation).
I've asked about the configuration to the LAMP server admin:

LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=

Regarding the used language in Matomo we use French (from France).
So I think the problem could come from the missing of fr_FR, isn't it?

Hi @heurteph-ei,
This might be a rendering problem with the font I guess. For french the number formatter is using a small non breakable space to separate thousands.
Using the unicode font would fix that, but it's not available by default and actually currently not used for all languages (including French).
Maybe we should consider using the unicode font always if available. The might be similar issues in other languages as well...

I tried what @diosmosis suggested: change the locales available on the server, but it changed nothing.

@heurteph-ei That won't help. You may need to choose another language in Matomo to "fix" that, until we are able to provide a proper fix

Facing the same issue for reports in French language. Using official docker image of Matomo 4.12.3.