Whoops! Figured it out - interval is a reserved word in mysql - "interval" instead of interval works nicely. Sorry for the trouble.
On Wednesday, January 11, 2023 at 4:38:00 PM UTC-5 James Runser wrote: > I'm trying to insert water temperature data from a different monitor stack > and am flummoxed by the interval column. Any attempt to interact with > interval fails. What gives here? > > A simple example: > MariaDB [weewx]> select count(dateTime) from archive; > +-----------------+ > | count(dateTime) | > +-----------------+ > | 14200 | > +-----------------+ > 1 row in set (0.019 sec) > > MariaDB [weewx]> select count(interval) from archive; > ERROR 1064 (42000): You have an error in your SQL syntax; check the manual > that corresponds to your MariaDB server version for the right syntax to use > near ') from archive' at line 1 > MariaDB [weewx]> select count(usUnits) from archive; > +----------------+ > | count(usUnits) | > +----------------+ > | 14200 | > +----------------+ > 1 row in set (0.019 sec) > > > -- 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/b561df8d-abb5-4c36-b900-13f59a91d635n%40googlegroups.com.
