[Bug]: error="no such table: playlist_tracks_genres"

[somedevreally]

I confirm that:

• I have searched the existing open AND closed issues to see if an issue already exists for the bug I've encountered
• I'm using the latest version (your issue may have been fixed already)

Version

0.52.0-SNAPSHOT (7ab7b5d)

Current Behavior

dev build in docker, when clicked on any smartplaylist in the side bar in browser, gets error Server communication error and playlist wont display/open.

if i go back to stable docker build, everything works normal

Expected Behavior

playlist need to display or open

Steps To Reproduce

No response

Environment

docker/web browser

How Navidrome is installed?

Docker

Configuration

No response

Relevant log output

{"id":"9a95e458-34d3-4602-b524-8f90fc7ffbd2","level":"debug","msg":"Refreshing smart playlist","playlist":"bryan adams","requestId":"ca5060121dc9/i1q870sbAy-000054","time":"2024-04-29T19:58:08Z","username":"userxxxx"}

{"elapsed":"308.1ms","id":"9a95e458-34d3-4602-b524-8f90fc7ffbd2","level":"debug","msg":"Refreshed playlist","numTracks":"70","playlist":"bryan adams","requestId":"ca5060121dc9/i1q870sbAy-000054","time":"2024-04-29T19:58:08Z","username":"userxxxx"}

{"args":"map[p0:9c18d406ae03edb713ab41e045d41fed p1:de30e5b999132d6cd3ca7c409cee3c03 p10:e4eb4b846b7ea91d63ed43c97c790d59 p11:6eb6a297be1aa5e990ac6c1f265f19dc p12:5ba0d6f4583ba67f6b4b4251f8b7b49a p13:1ff0467dedde9512769d3f6ab9efd298 p14:fc91c74a3fd434948e61eca37665e35d p15:4e2d5908015e369f2753439a6e796143 p16:040cafb910a6ac1a98f899ba05be81d2 p17:df3c06adedcdd8b61eea70de4c7d18e8 p18:6c828a0a4a39cc2bf4c7c6af2e29c3d7 p19:51779f1fefbe2853c7cc3239d09b4f16 p2:d473def6d0d82f1524463ceb5a8334e7 p20:436f0300a27593bc3e17c80a2173cbcb p21:c15febd8ae78fb9946b5f83c5138b0b4 p22:d4a4dcf26d020a39ac06dd199fb04a94 p23:9958dba40a409ed463dc31cd2cff24c8 p24:8e61583201985b81719b1df788b0c77c p25:3f7b15df3942ff0c435c8c7008b1ca67 p26:cdafd39d991a15b2b7f7e33b81ce1642 p27:b12ff9f6d4df3d0e8e273f9435783208 p28:2b62482575027e1c63995968574e3eb4 p29:80e0b09a3326612612754e9c108c3378 p3:ba0554b84851edde0e45f8ea4f892221 p30:d87dbb0be480d524f118a71549a70edb p31:ddef37c7b7997e6d98ef76d44611eb2f p32:98bbe4ddc25ddb7e2074e2c848c75e5b p33:ad3b153a378ad173a5b86334af663c35 p34:9c8e82ce5a838fd0d6c9851815fef514 p35:3ddb2a18a71e79ef6a1db2f57017f69f p36:ed99db224fa109c6834671c7e79ffc9a p37:d69b78577151a396cefb1dcabe665068 p38:50739e13c7080f278bd64d3e99f13995 p39:dc265991b01d69e887a7473edb1880a4 p4:564b5e63cc6e0579183d5f3c6628a60a p40:3edd342c45c9181de8e2b346627773de p41:0e99bc9f9ad027f3dfa96bf1b88dd779 p42:f6b9cd0d6be7c6c8e12551a462802619 p43:a04cca91e3bbe3d6fd6c8465a67c7e41 p44:ae05428e829b9418a369e281ff0fa6fd p45:118777cd2017726fc55faf77413e287c p46:95e60aacb7171e72293697ec7f8fb6b3 p47:e955248df4cee3cf95173d773e0bad04 p48:4b4cc3174d23231b3555236971b6891f p49:f4c902fe3911961b6db23bbbcf0d0d34 p5:5f72036450f7664ecc818fceeae10127 p50:9effe4dd0d84606d05ebac51a62b337d p51:e4ef9861ec5a8c2344cbbbd511d550a0 p52:2dce1325d6c40d2d127627b7735a94b3 p53:45d8c8b7dd460d49c4a3aaf332a88034 p54:b4ca3e200aa17b3b6c6f047b54132299 p55:6e8eea3d9e99759a2e8406aeb6b6e5b5 p56:e6407bb5566d5163460934926cbd4eb4 p57:7ca1111d67f83d4f9d88731d5cec5c4e p58:fdbe2ad15cc7d9efe5d1c290d3798464 p59:d09e20e52af9a17d23fe7f374ae06f61 p6:9bbac614cdb8fc52d023ceefaff1fc62 p60:1dac9ebf692b60404a771b9fe2c1902e p61:a332ecaf88fba213ea10ecbc94ff0646 p62:2d5fe36c93a35dee2472bf2da39f0192 p63:eba443db081d69ad647bbe855ee187fb p64:bfa42c2452af7e32c23cd30a45275bcf p65:3b91f918a86e1be0da1140105f54ae49 p66:e04c46aa6042488dc257a69eec34f1ed p67:74c26c54ed71496c9b38691f769c4d9a p68:d9096b0bbf7123f0e18bf7f23184784f p69:5f25db99bfdcb16b3ecf888848a55a11 p7:c7189ad1fdb95d91bca9f531c979a308 p8:e6ef9b4539d4c7e85acb2d2c37b2be8b p9:e8889cb9b2ea51ad33ad8a144d5a440f]","elapsedTime":"472.899µs","error":"no such table: playlist_tracks_genres","level":"error","msg":"SQL: `SELECT genre.*, playlist_tracks_id as item_id FROM genre JOIN playlist_tracks_genres ig on genre.id = ig.genre_id WHERE playlist_tracks_id IN ({:p0},{:p1},{:p2},{:p3},{:p4},{:p5},{:p6},{:p7},{:p8},{:p9},{:p10},{:p11},{:p12},{:p13},{:p14},{:p15},{:p16},{:p17},{:p18},{:p19},{:p20},{:p21},{:p22},{:p23},{:p24},{:p25},{:p26},{:p27},{:p28},{:p29},{:p30},{:p31},{:p32},{:p33},{:p34},{:p35},{:p36},{:p37},{:p38},{:p39},{:p40},{:p41},{:p42},{:p43},{:p44},{:p45},{:p46},{:p47},{:p48},{:p49},{:p50},{:p51},{:p52},{:p53},{:p54},{:p55},{:p56},{:p57},{:p58},{:p59},{:p60},{:p61},{:p62},{:p63},{:p64},{:p65},{:p66},{:p67},{:p68},{:p69}) ORDER BY playlist_tracks_id, ig.rowid`","requestId":"ca5060121dc9/i1q870sbAy-000054","rowsAffected":"-1","time":"2024-04-29T19:58:08Z","username":"userxxxx"}

{"error":"no such table: playlist_tracks_genres","id":"9a95e458-34d3-4602-b524-8f90fc7ffbd2","level":"error","msg":"Error loading genres for playlist","playlist":"bryan adams","requestId":"ca506012q870sbAy-000054","time":"2024-04-29T19:58:08Z","username":"userxxxx"}

2024/04/29 19:58:08 Error reading playlist_tracks: no such table: playlist_tracks_genres

{"elapsedTime":"342.4ms","httpStatus":"500","level":"error","msg":"HTTP: GET http://localdomain.local/api/playlist/9a95e458-24-8f90fc7ffbd2/tracks?_end=100&_order=ASC&_sort=id&_start=0&playlist_id=9a95e458-34d3-4602-sf90fc7ffbd2","remoteAddr":"x.x.x.x","requestId":"fee60121dc9/i1q870sbAy-000054","responseSize":"53","time":"2024-04-29T19:58:08Z","userAgent":"xxxx"}

Anything else?

Code of Conduct

• I agree to follow Navidrome's Code of Conduct

[deluan]

Thanks for reporting. Will fix this soon.