Witam czy ktoś wie co to za bład w mariaDB i jak się go pozbyć
Logger: homeassistant.components.recorder.util
Source: components/recorder/util.py:148
Integration: Recorder (documentation, issues)
First occurred: 20:19:43 (39 occurrences)
Last logged: 20:20:19
Error executing query: (pymysql.err.OperationalError) (1054, "Unknown column 'statistics_meta.name' in 'field list'") [SQL: SELECT statistics_meta.id AS statistics_meta_id, statistics_meta.statistic_id AS statistics_meta_statistic_id, statistics_meta.source AS statistics_meta_source, statistics_meta.unit_of_measurement AS statistics_meta_unit_of_measurement, statistics_meta.has_mean AS statistics_meta_has_mean, statistics_meta.has_sum AS statistics_meta_has_sum, statistics_meta.name AS statistics_meta_name FROM statistics_meta WHERE statistics_meta.statistic_id IN (%(statistic_ids_1)s, %(statistic_ids_2)s, %(statistic_ids_3)s, %(statistic_ids_4)s, %(statistic_ids_5)s, %(statistic_ids_6)s, %(statistic_ids_7)s, %(statistic_ids_8)s, %(statistic_ids_9)s, %(statistic_ids_10)s, %(statistic_ids_11)s, %(statistic_ids_12)s)] [parameters: {'statistic_ids_1': 'sensor.dzienny_licznik_pralki', 'statistic_ids_2': 'sensor.tygodniowy_licznik_pralki', 'statistic_ids_3': 'sensor.miesieczny_licznik_pralki', 'statistic_ids_4': 'sensor.roczny_licznik_pralki', 'statistic_ids_5': 'sensor.dzienny_licznik_koparki', 'statistic_ids_6': 'sensor.tygodniowy_licznik_koparki', 'statistic_ids_7': 'sensor.miesieczny_licznik_koparki', 'statistic_ids_8': 'sensor.roczny_licznik_koparki', 'statistic_ids_9': 'sensor.dzienny_licznik_komputer', 'statistic_ids_10': 'sensor.tygodniowy_licznik_komputer', 'statistic_ids_11': 'sensor.miesieczny_licznik_komputer', 'statistic_ids_12': 'sensor.roczny_licznik_komputer'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)
Po wyczyszczeniu bazy danych mam teraz takie logo
Logger: homeassistant.components.recorder.util
Source: components/recorder/util.py:437
Integration: Recorder (documentation, issues)
First occurred: 22:10:10 (2 occurrences)
Last logged: 22:15:10
Error executing statistics: (pymysql.err.OperationalError) (1054, "Unknown column 'statistics_meta.name' in 'field list'") [SQL: SELECT statistics_meta.id AS statistics_meta_id, statistics_meta.statistic_id AS statistics_meta_statistic_id, statistics_meta.source AS statistics_meta_source, statistics_meta.unit_of_measurement AS statistics_meta_unit_of_measurement, statistics_meta.has_mean AS statistics_meta_has_mean, statistics_meta.has_sum AS statistics_meta_has_sum, statistics_meta.name AS statistics_meta_name FROM statistics_meta WHERE statistics_meta.statistic_id IN (NULL) AND (1 != 1)] (Background on this error at: https://sqlalche.me/e/14/e3q8)
