Rain block

[bengtdg]

Hi
Having issues with the rain block.
It only shows rain today.

This month and This year is always zero
Block version 7.1

Weather station netatmo

Bengt

[davidefa]

- do other block report rain data correctly ( for example block station data )?
- do graphs show past rain data correctly ( which is equivalent to previous question and should verify that rain data is correctly saved in database )?
- when did you start weather data recording in meteotemplate

Please post a link to your site

[bengtdg]

Link: https://selevaret.casadelsele.com/meteo/

Started collecting data sinse mid april this year.

Now i see that block station data also shows 0 mm when selecting month or year

Bengt

[bengtdg]

Found the fix

ran this command:
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

I had problem with the interactive graph as well, both solved:)

[djpoppy]

I have the same problem. Where should I run the command? In this console?

[davidefa]

Yes, you can do it from the Sql tab, or in the Variables tab you should be able to edit the sql_mode variable directly

[djpoppy]

Sorry but I've never edited on SQL. Is this one? What should I enter or change?

[davidefa]

Simply remove the

Code: Select all

ONLY_FULL_GROUP_BY,

at the beginning

[djpoppy]

It gives me an error when modifying the sqlmode database because I don't have super privileges even if the database is mine

[davidefa]

You still have a few options:
- verify in the control panel of your hosting provider if you have any 'database setting options' to disable the only_full_group_by flag ( a mysql.ini editor or the like )
- verify in the control panel of your hosting provider if you can change the 'sql version' ( in mysql that option is enabled by default starting from ver 5.7, in mariaDb is disabled )
- you could add the following to your config.php script near line 15 ( after line beginning with '$con =' ). I used in my aruba domain which has the same problem, and it seems working.

Code: Select all

mysqli_query($con,"SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))");

( if you run the 'main configuration script' and click the save button, you will need to reenter this mod )

[djpoppy]

@davidefa I have to thank you again... I used the "third method" you listed.
I have a TopHost domain and had the same problem.
Now it seems to work. I have to remember that if I make changes in the main configuration I have to go and edit the config.php file again.
My php version is 7.4.