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/5b796660-7eed-4c51-97d9-9603b232ec4dn%40googlegroups.com.