Hi, since yesterday my Matomo installation no longer works. It’s very weird because I didn’t make any changes. It worked fine before. Can you help me, because I have no solution and I don’t understand how this can happen overnight, without modification.
Is the automatic update enabled?
Does the error occur with all browsers? Did your current browser update?
It’s the same problem on Chrome and Firefox. Matomo is already up to date.
Click to view System Check
Mandatory checks
Version PHP >= 7.2.5:
8.0.17
PDO Extension:
PDO\MYSQL Extension:
MYSQLI Extension:
Autres extensions requises:
zlib json 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 = -1 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
Optional checks
Répertoires privés requis:
Tous les répertoires privés sont inaccessibles depuis Internet.
Répertoires privés recommandés:
Tous les répertoires privés sont inaccessibles depuis Internet.
Intégrité des fichiers:
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 inattendus ont été trouvés dans votre installation de Matomo.
→ Veuillez supprimer ces fichiers pour éviter d’avoir des erreurs.
Binaire PHP 64 bits:
État du traqueur:
Limite mémoire:
640M
Fuseau horaire:
Ouvrir l’URL:
curl
PageSpeed est désactivé:
GD > 2.x + FreeType (graphics):
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 - Gestion des processus via la ligne de commande:
Ok
Dernière exécution d’archivage réussie:
Le processus d’archivage s’est terminé avec succès il y a 00:02:45.
Capacités de la base de données:
UTF8mb4 charset Warning: LOAD DATA INFILE
Astuce : l’utilisation de LOAD DATA INFILE en mettant à jour PHP et MySQL et s’assurant que votre utilisateur MySQL a les privilèges de FILE va grandement accélérer la vitesse du processus d’archivage de Matomo.
Si votre serveur Matomo suit des sites à fort trafic (ex. > 100000 pages par mois).
Erreur: LOAD DATA INFILE failed… Error was:
Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user ‘hj35h_app_piwik’@‘localhost’ (using password: YES)[28000],
Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MariaDB version[42000]
Troubleshooting: FAQ on matomo.org CREATE TEMPORARY TABLES Changing transaction isolation level
Taille maximale des paquets:
Connexion SSL forcée:
Géolocalisation:
geoip2php (continent_code, continent_name, country_code, country_name, region_code, region_name, city_name, postal_code, lat, long)
Mettre à jour via HTTPS:
Traceur JavaScript inscriptible ("/matomo.js" & “/piwik.js”):
Informational results
Matomo Version:
4.8.0
Matomo Update History:
4.6.2,4.6.1,4.5.0,4.4.1,3.3.0,
Matomo Install Version:
Unknown - pre 3.8.
Latest Available Version:
4.8.0
Is Git Deployment:
0
PHP_OS:
Linux
PHP_BINARY:
/opt/php8.0/sbin/php-fpm
PHP SAPI:
fpm-fcgi
Timezone Version:
2021.5
PHP Timezone:
UTC
PHP Time:
1648458178
PHP Datetime:
2022-03-28 09:02:58
PHP Disabled functions:
passthru, system
PHP INI max_execution_time:
60
PHP INI post_max_size:
300M
PHP INI max_input_vars:
10000
PHP INI zlib.output_compression:
1
Curl Version:
7.74.0, OpenSSL/1.1.1k
Suhosin Installed:
0
DB Prefix:
qjfx_
DB Charset:
utf8mb4
DB Adapter:
PDO_MYSQL
MySQL Version:
10.4.17-MariaDB-1:10.4.17+maria~jessie-log
Num Tables:
145
Browser Segment Archiving Enabled:
1
Development Mode Enabled:
0
Internet Enabled:
1
Multi Server Environment:
0
Auto Update Enabled:
1
Custom User Path:
0
Custom Include Path:
0
Release Channel:
latest_stable
Plugins Activated:
API, Actions, Annotations, BulkTracking, Contents, CoreAdminHome, CoreConsole, CoreHome, CorePluginsAdmin, CoreUpdater, CoreVisualizations, CoreVue, CustomDimensions, CustomJsTracker, Dashboard, DevicePlugins, DevicesDetection, Diagnostics, Ecommerce, Events, Feedback, GeoIp2, Goals, Heartbeat, ImageGraph, Insights, Installation, Intl, IntranetMeasurable, LanguagesManager, Live, Login, Marketplace, MobileMessaging, Monolog, Morpheus, MultiSites, Overlay, PagePerformance, PrivacyManager, ProfessionalServices, Proxy, Referrers, Resolution, RssWidget, SEO, ScheduledReports, SegmentEditor, SitesManager, Tour, Transitions, TwoFactorAuth, UserCountry, UserCountryMap, UserId, UserLanguage, UsersManager, VisitFrequency, VisitTime, VisitorInterest, VisitsSummary, WebsiteMeasurable, Widgetize
Plugins Deactivated:
CustomVariables 4.0.1, DBStats, MobileAppMeasurable, Provider 4.0.3, TagManager
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:
1648458005
Archive Time Last Finished:
1648458013
User Agent:
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.74 Safari/537.36 Edg/99.0.1150.46
Browser Language:
fr,fr-fr,en,en-gb,en-us
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:
exclude_path
Do Not Track enabled:
0
Googling the error message, I found:
Does this solve your issue?
PS: If your Matomo UI doesn’t work, how did you get the System Check?
Are you hosted? Maybe the provider changed some configuration without notice you…
There has been some updates (PHP version upgrade)
See:
Êtes-vous sûr(e) de vouloir supprimer ce segment? - Support en français (French) - Matomo forums
I am not sure it is the same problem, but the fact several errors occur at the same time from the same provider is fishy
I have the same problem (but it is a first install). I am also on Infomaniak but couldn’t get their help except a link to https://fr.matomo.org/faq/how-to/faq_25548/
Try to use PHP 7 instead of PHP 8.
see: