Energy Dashboard stopped working

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

homeassistant.log

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)

image