From 6da8cadd9934d5db11b0b2f9f9ddd31599bb3680 Mon Sep 17 00:00:00 2001 From: Marcel van der Veldt Date: Thu, 22 Aug 2024 07:59:47 +0200 Subject: [PATCH] Fix new playlists get corrupted (#1590) due to leftover redundant column --- music_assistant/server/controllers/music.py | 12 +++++++++--- 1 file changed, 9 insertions(+), 3 deletions(-) diff --git a/music_assistant/server/controllers/music.py b/music_assistant/server/controllers/music.py index 01cdc06c..90dded00 100644 --- a/music_assistant/server/controllers/music.py +++ b/music_assistant/server/controllers/music.py @@ -73,7 +73,7 @@ DEFAULT_SYNC_INTERVAL = 3 * 60 # default sync interval in minutes CONF_SYNC_INTERVAL = "sync_interval" CONF_DELETED_PROVIDERS = "deleted_providers" CONF_ADD_LIBRARY_ON_PLAY = "add_library_on_play" -DB_SCHEMA_VERSION: Final[int] = 7 +DB_SCHEMA_VERSION: Final[int] = 8 class MusicController(CoreController): @@ -1058,9 +1058,15 @@ class MusicController(CoreController): await self.__create_database_tables() return - if prev_version <= 6: + if prev_version <= 7: # remove redundant artists and provider_mappings columns - for table in (DB_TABLE_TRACKS, DB_TABLE_ALBUMS, DB_TABLE_ARTISTS, DB_TABLE_RADIOS): + for table in ( + DB_TABLE_TRACKS, + DB_TABLE_ALBUMS, + DB_TABLE_ARTISTS, + DB_TABLE_RADIOS, + DB_TABLE_PLAYLISTS, + ): for column in ("artists", "provider_mappings"): try: await self.database.execute(f"ALTER TABLE {table} DROP COLUMN {column}") -- 2.34.1