2024.8.2

• Avoid Exception on Glances missing key (@wittypluck - #114628) (glances docs)
• Fix Madvr sensor values on startup (@iloveicedgreentea - #122479) (madvr docs)
• Drop violating rows before adding foreign constraints in DB schema 44 migration (@emontnemery - #123454) (recorder docs)
• Handle Yamaha ValueError (@pssc - #123547) (yamaha docs)
• Bump aiohttp to 3.10.3 (@bdraco - #123549) (dependency)
• Update knx-frontend to 2024.8.9.225351 (@farmio - #123557) (knx docs) (dependency)
• Fix secondary russound controller discovery failure (@noahhusby - #123590) (russound_rio docs)
• Change WoL to be secondary on device info (@gjohansson-ST - #123591) (wake_on_lan docs)
• Ensure HomeKit connection is kept alive for devices that timeout too quickly (@bdraco - #123601) (homekit_controller docs)
• Bump aioshelly to version 11.2.0 (@bieniu - #123602) (shelly docs) (dependency)
• Bump pydaikin to 2.13.4 (@kingy444 - #123623) (daikin docs) (dependency)
• System Bridge package updates (@timmo001 - #123657) (system_bridge docs) (dependency)
• Bump aiohomekit to 3.2.2 (@bdraco - #123669) (homekit_controller docs) (dependency)
• Fix startup block from Swiss public transport (@miaucl - #123704) (swiss_public_transport docs)
• Bump pyschlage to 2024.8.0 (@dknowles2 - #123714) (schlage docs) (dependency)
• Update AEMET-OpenData to v0.5.4 (@Noltari - #123716) (aemet docs) (dependency)
• Update aioairzone-cloud to v0.6.2 (@Noltari - #123719) (airzone_cloud docs) (dependency)
• Update aioqsw to v0.4.1 (@Noltari - #123721) (qnap_qsw docs) (dependency)
• Bump ZHA lib to 0.0.31 (@dmulcahey - #123743) (zha docs) (dependency)
• Update wled to 0.20.2 (@frenck - #123746) (wled docs) (dependency)
• Fix error message in html5 (@mib1185 - #123749) (html5 docs)
• Bump py-nextbusnext to 2.0.4 (@ViViDboarder - #123750) (nextbus docs) (dependency)
• Bump python-nest-sdm to 4.0.6 (@allenporter - #123762) (nest docs) (dependency)
• Update xknx to 3.1.0 and fix climate read only mode (@farmio - #123776) (knx docs) (dependency)
• Fix KNX UI Light color temperature DPT (@farmio - #123778) (knx docs)
• Fix status update loop in bluesound integration (@LouisChrist - #123790) (bluesound docs)
• Bump py-synologydsm-api to 2.4.5 (@mib1185 - #123815) (synology_dsm docs) (dependency)
• Fix blocking I/O of SSLContext.load_default_certs in Ecovacs (@edenhaus - #123856) (ecovacs docs)
• Fix translation for integration not found repair issue (@mib1185 - #123868) (homeassistant docs)
• Handle timeouts on Airzone DHCP config flow (@Noltari - #123869) (airzone docs)
• Bump pylutron_caseta to 0.21.1 (@bdraco - #123924) (lutron_caseta docs) (dependency)
• Fix PI-Hole update entity when no update available (@mib1185 - #123930) (pi_hole docs)
• Bump LaCrosse View to 1.0.2, fixes blocking call (@IceBotYT - #123935) (lacrosse_view docs) (dependency)
• Bump pypck to 0.7.20 (@alengwenus - #123948) (lcn docs) (dependency)
• Environment Canada weather format fix (@gwww - #123960) (environment_canada docs)
• Bump pyhomeworks to 1.1.1 (@emontnemery - #123981) (homeworks docs)
• Ensure event entities are allowed for linked homekit config via YAML (@bdraco - #123994) (homekit docs)
• Bump openwebifpy to 4.2.7 (@autinerd - #123995) (enigma2 docs) (dependency)
• Re-enable concord232 (@joostlek - #124000) (concord232 docs) (dependency)
• Bump aiounifi to v80 (@Kane610 - #124004) (unifi docs) (dependency)
• Fix rear trunk logic in Tessie (@Bre77 - #124011) (tessie docs)
• Bump bluetooth-adapters to 0.19.4 (@bdraco - #124018) (bluetooth docs) (dependency)
• Fix loading KNX integration actions when not using YAML (@farmio - #124027) (knx docs)
• Bump aiomealie to 0.8.1 (@joostlek - #124047) (mealie docs) (dependency)
• Exclude aiohappyeyeballs from license check (@joostlek - #124041)