Hello, since switching to php 7.2 the graphics widget displays the following message. Someone would have an idea of the problem
Version de Matomo: 3.11.0
Version de MySQL: 5.6.41-cll-lve
Version de PHP: 7.2.18
Oups… Il y a eu un problème pendant le traitement de la requête. Peut-être que le serveur a eu un souci temporaire, ou peut-être que vous avez demandé un rapport avec trop de données. Veuillez réessayer. Si cette erreur se répète veuillez contacter votre administrateur Matomo pour obtenir de l’aide.
that what i can see in error log:
[18-Sep-2019 14:34:47 UTC] Error in Matomo: Mysqli prepare error: Lost connection to MySQL server during query - in plugin Referrers
[18-Sep-2019 14:34:54 UTC] Error in Matomo: Mysqli prepare error: MySQL server has gone away
[18-Sep-2019 14:47:26 UTC] Error in Matomo: Mysqli prepare error: MySQL server has gone away
[18-Sep-2019 14:47:34 UTC] Error in Matomo: Mysqli prepare error: Lost connection to MySQL server during query - in plugin Referrers
[18-Sep-2019 14:47:34 UTC] Error in Matomo: Mysqli prepare error: MySQL server has gone away
[18-Sep-2019 14:47:34 UTC] Error in Matomo: Mysqli prepare error: MySQL server has gone away
[18-Sep-2019 14:47:34 UTC] Error in Matomo: Mysqli prepare error: MySQL server has gone away
Did somebody found a solution for that please ?
I have 3 websites on server with joomla and Matomo for each. I have did php update 7.1 -> 7.2 and know that what i have in matomo
Both errors don’t really have much to do with Matomo, but is rather PHP telling you that it tried to query the MySQL server, but during the query the connection broke.
So make sure the MySQL server is working properly.
See also
I can add that the menu “Vérification système” (System Check) return to me systematically a 503 service unavailable error and the menu “Variables personnalisées” (Custom variables) doesn’t load anything.
Hope it can helps
Hi;
I have the exact same problem and I confirm that it works well with PHP 7.1 but not above (up to PHP 7.4 now). My only solution now is to downgrade to PHP 7.1. Any one would have a better option to make it work with PHP 7.4?
Thanks.