Some pages not showing data

[Mariete]

I run into a problem I'm not able to solve by myself.

My setup is a Davis PRO 2 with WeeWx in a Raspberry Pi reporting to Meteotemplate v17 (on a VPS) via api.php

I can see current data but no data on Interactive Table, Interactive Graphs, and others, there is data in Resume and Almanac...







The summary IS showing data:



In the Report Monthly, for example, it shows the summary and the almanac but not the graphs.


My database looks like it's storing data but don't know if it's lacking some table.



Any clue? I know probably is some silly detail but can't find it for months!

Thanks.

Mario

[Jachym]

Try running this SQL command in PHPMyAdmin

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

[Mariete]

Hi.

Sorry for the delay.

When I try this I get an access denied error:



#1227 - Acceso negado. Usted necesita el privilegio SUPER para esta operación
Means: #1227 - Access denied. You need the SUPER privilege for this operation

[Jachym]

Then you need to ask your provider to change this, if you do not have permissions to do it yourself

[Mariete]

I have a VPS with root access so I’m not supposed to have any limitations. May be it’s some kind of problem with the dafult MySQL configuration?

[Jachym]

There have been a few others with the same problem and this always solved it

[andyk1]

The error is showing a privilege error.

#1227 - Acceso negado. Usted necesita el privilegio SUPER para esta operación
Means: #1227 - Access denied. You need the SUPER privilege for this operation

You may need to call your host server and ask to have your mysql permissions changed. Not many hosts give access to that without a call. Root level is not the same. Fix that and Jachym's fix should work.

Andy