Hallo, I have a small request, the values for day.radiation.energy_integral and week... month... and year.radiation.energy_integral not displayed
as proof, have a look at http://wh3080.hes61.de/ Hartmut [email protected] schrieb am Donnerstag, 11. März 2021 um 10:41:08 UTC+1: > Yes, you are right. I did use ' instead of `. > > gjr80 schrieb am Donnerstag, 11. März 2021 um 10:37:49 UTC+1: > >> Are you sure you are using backticks, there are a number of similar >> looking symbols. Actually, looking at my reply I said backticks but I >> suspect I did not actually use them, you want this one: >> ‘ >> Backticks will work in SQLite, if you look through the WeeWX code you >> will find wherever interval is used in a SQL statement it is enclosed in >> backticks. I believe double quotes can be used in MySQL in certain modes >> only, but backticks can be used in all modes. >> >> Gary >> On Thursday, 11 March 2021 at 19:19:54 UTC+10 [email protected] wrote: >> >>> gjr80 schrieb am Donnerstag, 11. März 2021 um 10:07:01 UTC+1: >>> >>>> I think you will find the issue is that interval is a reserved word in >>>> MySQL. The solution is to enclose interval in backticks, eg: 'interval' >>> >>> >>> Thank you, Gary, for your tip. Unfortunately, that in turn does not work >>> for Sqlite. There, it only works with quotes, "interval" >>> >>> >> -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/0db5d982-2a5e-448f-bef0-830bec97be20n%40googlegroups.com.
