From ca0473677d87a8b215dedbe8801046df483e5f7b Mon Sep 17 00:00:00 2001 From: Marcel van der Veldt Date: Sat, 25 Mar 2023 21:18:40 +0100 Subject: [PATCH] fix query --- music_assistant/server/controllers/media/albums.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/music_assistant/server/controllers/media/albums.py b/music_assistant/server/controllers/media/albums.py index b1c335f2..1e9a70d0 100644 --- a/music_assistant/server/controllers/media/albums.py +++ b/music_assistant/server/controllers/media/albums.py @@ -349,7 +349,7 @@ class AlbumsController(MediaControllerBase[Album]): db_album = await self.get_db_item(item_id) # simply grab all tracks in the db that are linked to this album # TODO: adjust to json query instead of text search? - query = 'SELECT * FROM tracks WHERE albums LIKE "item_id":"{item_id}","provider":"database"' + query = f'SELECT * FROM {DB_TABLE_TRACKS} WHERE albums LIKE \'%"item_id":"{item_id}","provider":"database"%\'' # noqa: E501 result = [] for track in await self.mass.music.tracks.get_db_items_by_query(query): if album_mapping := next( -- 2.34.1