Meteotemplate Forum

SOLVED: It was a configuration issued as described in this extract of a post: You can try to disable the only_full_group_by setting by executing the following: mysql> set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBST...

My thought around deletion was for WessexWeather who has years of data. a simple SQL statement could delete all the 00 entries instead of trying to edit them.

why not just delete all entries with a time stamp of 00:00 and 00:05. The impact of losing the first 5 minutes of the days data should be minimal and shouldn't be too time-consuming to do.

I have a new station that was set up in late March. I want to load historical data from NWS into the database. I tried by entering the monthly total into field R for the last day of the month at 23:55. However, the rain block is not picking it up. How should I go about inputting historical rain tota...