Probléme PHP: 7.2.18

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.

Hi,

Do you see the warning immeadiatly after loading the page or does it load for a long time and then abort with the warning?

In both cases, can you please check the PHP error log for errors?

Hi Lukas,
Yes i can see it on first page.


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

Hi,

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
https://matomo.org/faq/troubleshooting/faq_183/

Ok thank you for the answer.
But i’m on a Cpanel virtual server and i have no acces on the my.cnf.
So do you have another solution ?

Hi,

In that case contact your server host, so they can take a look at the issue.

But why when I come back in php version 7.1 everything works as it should?

I contacted my host who told me not to be able to change the requested settings because it is a shared server. Would there be another solution?