Blocks and Plugins not calculating data

enephler · Post by **enephler** » Sat Apr 15, 2023 7:29 pm

My hosting company had to move my site to a different server, and since then blocks and plugins are not calculating correctly. All the data is in MySQL and updating correctly. Some blocks show some data, but others show nothing.
In attached screen shots, the snow block show the correct total snowfall, but is missing the monthly, and in the interactive graph screen show it shows nothing at all. This is the first time I've had any problems at all.
Any ideas how to fix this?
Thank you.

FSC830 · Post by **FSC830** » Sat Apr 15, 2023 7:43 pm

Any other changes made in addition, i.e. switch von PHP7.x to PHP8.x?

Regards

enephler · Post by **enephler** » Sat Apr 15, 2023 7:45 pm

FSC830 wrote: ↑Sat Apr 15, 2023 7:43 pm Any other changes made in addition, i.e. switch von PHP7.x to PHP8.x?

Regards

No, it's still running PHP 7.4.

enephler · Post by **enephler** » Sat Apr 15, 2023 7:56 pm

Here are a couple more examples. As you can see the Station Data is up to date and correct, but the Averages and Deviations are blank.

FSC830 · Post by **FSC830** » Sat Apr 15, 2023 8:10 pm

Can you run the queries against the database manually?
You need to lookup the query in the referring .php file.
What is the outcome of the query?

Regards

enephler · Post by **enephler** » Sat Apr 15, 2023 9:07 pm

FSC830 wrote: ↑Sat Apr 15, 2023 8:10 pm Can you run the queries against the database manually?
You need to lookup the query in the referring .php file.
What is the outcome of the query?

Regards

I'm not sure how to do that. When I do run a query from a block there are variables that are needed.

FSC830 · Post by **FSC830** » Sat Apr 15, 2023 10:27 pm

To run the queries manually you need a SSH connection to your host.
No need for variables, you can just lookup the command in the .php file.
Only thing is that you need to know the DB user and password and run the query from CLI.
User and password can be found in the config file.

Regards

enephler · Post by **enephler** » Sun Apr 16, 2023 11:48 am

FSC830 wrote: ↑Sat Apr 15, 2023 10:27 pm To run the queries manually you need a SSH connection to your host.
No need for variables, you can just lookup the command in the .php file.
Only thing is that you need to know the DB user and password and run the query from CLI.
User and password can be found in the config file.

Regards

Yes, running queries manually works fine.
This seems to be quite hit and miss, as in the Rain Block does not populate at all, but the Station Data Block works with static data but not calculated data.

enephler · Post by **enephler** » Sun Apr 16, 2023 4:34 pm

This issue is resolved. The problem was MySQL had mode 'ONLY_FULL_GROUP_BY' on, once taken out/disabled, everything is back up and working as it should.

FSC830 · Post by **FSC830** » Sun Apr 16, 2023 5:53 pm

Sometimes it could be so easy

. See here.
So with move to the new server the mysql options have been modified too.
This was not my first thought.

Regards

Meteotemplate Forum

Blocks and Plugins not calculating data

Blocks and Plugins not calculating data

Re: Blocks and Plugins not calculating data

Re: Blocks and Plugins not calculating data

Re: Blocks and Plugins not calculating data

Re: Blocks and Plugins not calculating data

Re: Blocks and Plugins not calculating data

Re: Blocks and Plugins not calculating data

Re: Blocks and Plugins not calculating data

Re: Blocks and Plugins not calculating data

Re: Blocks and Plugins not calculating data