Topic: Meteotemplate interactive graphs issue

[Bashy]

Hi folks

I would like to revisit this one, please.

As seen here at the center/bottom block, you can see the graphs not showing, just the spinning update icon showing.

To resolve this i was told to  do one of 2 things

In phpmyadmin if you have the variables tab search for the sql_mode variable and remove ONLY_FULL_GROUP_BY option.

Or execute the following

Code: [Select]

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
I do not have the variable tab so i opted for the latter, this worked to a certain degree, what I didn't realise until now is that it does not last long at all, i.e if i restart the server then i have to insert that again.

The other bigger issue thats just started recently is that when i do execute that, the MySQL CPU usage goes sky high and i do not say that lightly, I've seen it hit over 110% (not sure how thats possible lol)

This is the path thats hitting >100%

Code: [Select]

/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
This means that i can no longer use that SQL execution.
I was hoping that updating to the latest template version may help but alas, it did not, therefore, are there any other options, please?

Thank you