Commit 69cc037 <https://github.com/roe-dl/weewx-GTS/commit/69cc03784d1463373cdaad1986bd0acf01487ab7>
Karen K schrieb am Donnerstag, 11. März 2021 um 10:56:17 UTC+1: > Could you send your skin.conf and index.html.tmpl here? > > [email protected] schrieb am Donnerstag, 11. März 2021 um 10:51:38 UTC+1: > >> 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/4e1a4d08-147e-4276-9339-23566e50189en%40googlegroups.com.
