Some sensors stopped working in the 1st March?

[mprowe]

Hi,
Not checked the gas sensors but:
There are no entries in the SQLite database later than 2023-03-01 10:00:11 for the sensors:

1. sensor.electricity_standing_charge_per_day
2. sensor.electricity_price_per_kwh
3. sensor.electricity_cost_this_bill

The others seem to be okay.
This is my query:

select DATETIME(created_ts, 'auto'), *
from statistics
where metadata_id = (select id from statistics_meta where statistic_id = 'sensor.electricity_price_per_kwh') 
order by created_ts
DESC

I have had problems with other sensors when the database column changed from created to created_ts

Any possibility that there is a connection?

Regards, Martin

[mmillmor]

This is due to a change in home assistant. I logged home-assistant/core#87388 and home-assistant/core#87874 for it, but they are adamant that monetary amounts can't be measurements, and therefore can't have statistics. If you disagree then feel free to log a bug on home assistant - it's possible that multiple people raising issues on this will persuade them otherwise