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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/8c66cd5c-104d-4845-a036-95f319543a46n%40googlegroups.com.
