2021.11: Icon picker, device links and entity categories

Blog
46

Upgrade went smooth. Was hoping my Tuya device would appear again as it disappeared half way last month. It worked in 2021.10 but disappeared at an unknown moment :frowning:

47

check your logs for errors

48

Always do, but none :sweat: iā€™ll set it to debug and see if I can find the culprit :slight_smile: no worries :slight_smile:

49

Anyone else got this issue?

Logger: homeassistant.components.recorder.util
Source: components/recorder/util.py:85
Integration: Recorder (documentation, issues)
First occurred: 19:40:21 (1 occurrences)
Last logged: 19:40:21

Error executing query: (MySQLdb._exceptions.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.has_sum = true] (Background on this error at: https://sqlalche.me/e/14/e3q8)
50

Folks, I am on 2021.9.7, and want to avoid troubles with DST coming up this weekend. So I want to install 2021.10.7, and wait for all the bugs to get cleaned up in 2021.11 before migrating there. But the update option in supervisor doesnā€™t give me the 2021.10.7 option, only 2021.11.

How can I get it to update to 2021.10.7 in my situation?

51

Run from the SSH & Terminal add-on the following command:

ha core update --version 2021.10.7

1 Like
52

thank you!!

1 Like
53

I have Flux HACS Install to fix an issue with version 8 of the Magic Home Firmware setup.

Is this fixed on the official integration ?

I have 3 lots of Magic Home lights and only 1 is on the version 8 but its my main LEDS that I uses but the HACS install fixed it.

Originally v8 LEDS never stayed online and could not be turned on or off due to this.

I have the code below in my configuration file and its not upgraded them to the new integration in the 2021.11.0 upgradeā€¦should it have ?

light:
  - platform: flux_led
    devices:
      192.168.0.126:
        name: Kitchen LEDs
        protocol: 'ledenet'
        mode: rgbw
      192.168.0.191:
        name: Office LEDs
        protocol: 'ledenet'
        mode: rgbw
      192.168.0.143:
        name: Top Bedroom LEDs
        mode: rgbw

Thanks

Martyn

54

Itā€™s database migration error :cry:

55

new xiaomi_miio maintenance unit_of_measurement: s

the states doesnā€™t add up?

2

1
1377Ɨ650 54.9 KB

56

Nooo! Why remove MSSQL support? I got DW solution with 60 million HA records build on top of that. :sweat:

4 Likes
57

after update core to 2021.11 Iā€™m missing most of my entities in the ui controlled lovelace. They are not gone but just the just not showing up rooms are missing as well. Anyone else having this problem?

7 Likes
58

The RGBW and RGBCW and RGBCCT lights should work with as long as the models in the database here:

The Flux HACS version is way behind core at this point so its probably best to remove.

59

Wow :star_struck: what a wonderful release full of goodiesā€¦! Icon picker is a lovely and welcomed addition. GREAT WORK EVERYBODY :gift_heart:

60

I lost 5 out of 7 dashboards. Tabs are there but everything is blank.

2 Likes
61

Loving the entity categories and the fact that itā€™ll reduce whatā€™s auto-exposed to Google and Alexa integrations.

I had migrated to explicitly specifying what I wanted to share into Google Home and Alexa, but itā€™s possible this change will allow me to let them be passively exposed again. Maybe.

What would really help me understand what will be sent to Google/Alexa would be entity category filter options on the Configurationā€¦Entities page. Perhaps add the ability to filter by those new categories: Primary, Configuration and Diagnostic? Then I could use the Entities page to see exactly which entities I might expect to show up in Google Home and Alexa should I revert back to auto-population.

Amazing progress, thank you!

3 Likes
62

sounds like custom card issues

1 Like
63

Upon updating all my Shelly devices and their entities got renamed to their defaults, breaking all my automations and Lovelace cards.
Is this a bug, or a breaking change?

1 Like
64

i think you are right. i can see the raw yaml code of the dashboards and i am using custom cards.

65

If I recall correctly, there was a change to the base HA card that everything uses. So custom cards that are effected donā€™t work until you update.