I get No state history found since the update 0.99.2 when i click on a sensor i get this no history found message.
Is there something i have to include my config after the update?
1 Like
Any errors in your log related to the database?
Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{"entity_id": "sensor.power_production_low", "old_state": {"entity_id": "sensor.power_production_low", "state": "2869.853", "attributes": {"unit_of_m ... (516 characters truncated) ... :00", "last_updated": "2019-09-22T08:38:31.870291+00:00", "context": {"id": "8d55fff75c1f49c388ffd9c68c4733c4", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-09-22 08:38:31.870369', '2019-09-22 08:38:31.890854', '8d55fff75c1f49c388ffd9c68c4733c4', None)] (Background on this error at: http://sqlalche.me/e/4xp6)
My bad hadn’t check that log 
Any idea how i can fix the database?
And i found my answer just by searching 
This has nothing to do with home-assistant.log. The file you want to delete is home-assistant_v2.db. That is the one containing the history database. If you delete it, and restart home-assistant it will recreate an empty database
5 Likes
Thnx for pointing me in the right direction
1 Like