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/bfe6788e-2ecc-43f0-b371-439db0c2d93an%40googlegroups.com.
