You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have your code plus weewx 3.7.1 installed and everything appears to be working except I appear to not have a dayrain column so error.log is throwing this:
2017/05/26 09:57:11 [error] 26806#0: *219 [lua] api.lua:46: view(): Failed SQL query: SELECT
datetime,
date_trunc('second', age(NOW(), date_trunc('second', datetime))) AS age,
dayrain FROM archive WHERE
dayrain =
(
SELECT
MIN(dayrain)
FROM archive WHERE (
datetime BETWEEN CURRENT_DATE AND
CURRENT_DATE + INTERVAL '1 DAY'
)
LIMIT 1
)
AND (
datetime BETWEEN CURRENT_DATE AND
CURRENT_DATE + INTERVAL '1 DAY'
)
LIMIT 1
, client: 192.168.211.236, server: localhost, request: "GET /api/record/dayrain/min?start=today HTTP/1.1", host: "weather:8080", referrer: "http://weather:8080/"
Any ideas how to go about fixing this query to work?
The text was updated successfully, but these errors were encountered:
I have your code plus weewx 3.7.1 installed and everything appears to be working except I appear to not have a
dayrain
column soerror.log
is throwing this:Any ideas how to go about fixing this query to work?
The text was updated successfully, but these errors were encountered: