Hi huys, I used the energy dashboard for a while but it stopped working for months now (just came around to fix it) I have no idea what cause this issue.
This is when it used to work
This is when it used to work
Places to look for clues:
Settings → System → Logs
Are there any relevant errors, including for the recorder/database?
Developer Tools → Statistics
Any entities listed with a “FIX ISSUE” button on their right hand side?
It seems to report No Issues
The only log entry sort of related to the issue is this, but it isn’t even from the same entity, seems to be caused by the entity name having the ‘phi’ symbol and that can’t be encoded to the current charset
2022-08-06 18:00:10.120 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (MySQLdb.OperationalError) (1366, "Incorrect string value: '\\xCF\\x86' for column `homeassistant`.`statistics_meta`.`unit_of_measurement` at row 1")
[SQL: INSERT INTO statistics_meta (statistic_id, source, unit_of_measurement, has_mean, has_sum, name) VALUES (%s, %s, %s, %s, %s, %s)]
[parameters: ('sensor.bedroom_meter_energy_factor', 'recorder', 'Cos φ', 1, 0, None)]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
