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) |
+
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 monit
I'm trying to integrate a home-built tide and temperature monitor into
weewx (configured and working without issue with an Acurite Atlas). I'm
using a MySQL DB and tried simply inserting my data (waterTemp, tideHeight)
into archive. I use current timestamp, usUnits and 10 for the required
inter
quot;. I've walked through the
template and inc files but still can't find the right building blocks. I
even tried changing the waterTemp column from a double to a double(4,2) but
am still getting all the extra zeros.
On Monday, January 16, 2023 at 2:16:12 PM UTC-5 James Runser wrote:
>
