Hello,
my log is showing this:
2021-10-10 22:00:10 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) near "(": syntax error
[SQL: SELECT anon_1.metadata_id AS anon_1_metadata_id, anon_1.start AS anon_1_start, anon_1.last_reset AS anon_1_last_reset, anon_1.state AS anon_1_state, anon_1.sum AS anon_1_sum, anon_1.rownum AS anon_1_rownum
FROM (SELECT statistics_short_term.metadata_id AS metadata_id, statistics_short_term.start AS start, statistics_short_term.last_reset AS last_reset, statistics_short_term.state AS state, statistics_short_term.sum AS sum, row_number() OVER (PARTITION BY statistics_short_term.metadata_id ORDER BY statistics_short_term.start DESC) AS rownum
FROM statistics_short_term
WHERE statistics_short_term.start >= ? AND statistics_short_term.start < ?) AS anon_1
WHERE anon_1.rownum = ? ORDER BY anon_1.metadata_id]
[parameters: ('2021-10-10 19:00:00.000000', '2021-10-10 20:00:00.000000', 1)]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
What can I do ?
Thanks.
