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 kk44...@gmail.com 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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/37ba9597-cd51-4055-bef4-f6e6fd9cebd0n%40googlegroups.com.
