hi all, after updating I keep getting ‘no state history’ when I try to check the history tag on the side.
Any errors coming up in the log?
Yes I got this:
Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'SELECT states.state_id AS states_state_id, states.domain AS states_domain, states.entity_id AS states_entity_id, states.state AS states_state, states.attributes AS states_attributes, states.event_id AS states_event_id, states.last_changed AS states_last_changed, states.last_updated AS states_last_updated, states.created AS states_created, states.context_id AS states_context_id, states.context_user_id AS states_context_user_id \nFROM states JOIN (SELECT states.state_id AS max_state_id \nFROM states \nWHERE states.last_updated < ? AND states.entity_id IN (?) ORDER BY states.last_updated DESC\n LIMIT ? OFFSET ?) AS anon_1 ON states.state_id = anon_1.max_state_id \nWHERE states.domain NOT IN (?, ?)
Stop HA and delete your config/home-assistant_v2.db file. You’ll lose previous history bu HA will create a new database.
Tom, You the man. Thanks a bunch. I’m back in action.