Youtube music not working Play now must be used Start radio

What version of Music Assistant has the issue?

2.0.0b69

The problem

I don't know much English, so I'm adding a video with the problem.

Thank you

https://www.youtube.com/watch?v=-76y9iNj-ho

How to reproduce

I don't know much English, so I'm adding a video with the problem.

Thank you

https://www.youtube.com/watch?v=-76y9iNj-ho

Relevant log output

2023-08-05 09:51:24.761 INFO (MainThread) [music_assistant] Starting Music Assistant Server (d9742c16fb3c42daa204dad872aa84c9) version 2.0.0b69 - uvloop: False 2023-08-05 09:51:24.974 INFO (MainThread) [music_assistant.webserver] Starting server on 172.30.32.1:8095 - base url: http://172.30.32.1:8095 2023-08-05 09:51:25.168 INFO (MainThread) [music_assistant.music] Setting up the sync interval to 180 minutes. 2023-08-05 09:51:26.939 INFO (MainThread) [music_assistant.streams] Detected ffmpeg version 5.1.3 with libsoxr support 2023-08-05 09:51:26.939 INFO (MainThread) [music_assistant.streams] Starting server on 0.0.0.0:8096 - base url: http://192.168.2.100:8096 2023-08-05 09:51:27.941 INFO (MainThread) [music_assistant] Loaded player provider UPnP/DLNA Player provider 2023-08-05 09:51:27.941 INFO (MainThread) [music_assistant] Loaded metadata provider fanart.tv Metadata provider 2023-08-05 09:51:27.941 INFO (MainThread) [music_assistant] Loaded music provider URL 2023-08-05 09:51:27.943 INFO (MainThread) [music_assistant] Loaded metadata provider MusicBrainz Metadata provider 2023-08-05 09:51:27.943 INFO (MainThread) [music_assistant] Loaded metadata provider TheAudioDB Metadata provider 2023-08-05 09:51:27.943 INFO (MainThread) [music_assistant] Loaded player provider SONOS 2023-08-05 09:51:28.098 INFO (MainThread) [music_assistant] Loaded player provider Universal Group Player 2023-08-05 09:51:28.105 INFO (MainThread) [music_assistant.music] Sync task for URL completed 2023-08-05 09:51:28.113 INFO (MainThread) [music_assistant] Loaded player provider Chromecast 2023-08-05 09:51:28.116 INFO (MainThread) [music_assistant.providers.slimproto] Started SLIMProto server on port 3483 2023-08-05 09:51:28.117 INFO (MainThread) [music_assistant.providers.slimproto.cli] Registering jsonrpc endpoints on the webserver 2023-08-05 09:51:28.122 INFO (MainThread) [music_assistant.providers.slimproto.cli] Starting (telnet) CLI on port 9090 2023-08-05 09:51:28.129 INFO (MainThread) [music_assistant] Loaded player provider Slimproto 2023-08-05 09:51:28.212 INFO (MainThread) [music_assistant.players] Player registered: 57cd4a7d-6af7-b684-bcfb-33a72f38da59/GarĂˇĹľ rĂˇdio 2023-08-05 09:51:28.423 INFO (MainThread) [music_assistant] Loaded music provider RadioBrowser 2023-08-05 09:51:28.424 INFO (MainThread) [music_assistant.music] Sync task for RadioBrowser completed 2023-08-05 09:51:28.945 INFO (MainThread) [music_assistant] Loaded player provider Airplay 2023-08-05 09:51:32.135 INFO (MainThread) [music_assistant] Loaded music provider YouTube Music 2023-08-05 09:51:38.057 INFO (MainThread) [music_assistant.music] Sync task for YouTube Music completed 2023-08-05 09:59:11.412 ERROR (MainThread) [music_assistant.webserver] [140471266292752] Error handling message: CommandMessage(message_id=25, command='players/queue/play_media', args={'queue_id': '57cd4a7d-6af7-b684-bcfb-33a72f38da59', 'media': ['library://playlist/2'], 'option': 'replace'}) Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/webserver.py", line 372, in _run_handler result = await result ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/player_queues.py", line 210, in play_media await self.mass.music.mark_item_played( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py", line 508, in mark_item_played await self.database.insert( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 105, in insert await self.execute(sql_query, values) File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 151, in execute return await self._db.execute(query, values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 190, in execute cursor = await self._execute(self._conn.execute, sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 133, in _execute return await future ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 106, in run result = function() ^^^^^^^^^^ sqlite3.OperationalError: table playlog has no column named media_type 2023-08-05 09:59:20.850 ERROR (MainThread) [music_assistant.webserver] [140471266292752] Error handling message: CommandMessage(message_id=26, command='players/queue/play_media', args={'queue_id': '57cd4a7d-6af7-b684-bcfb-33a72f38da59', 'media': ['library://playlist/2'], 'option': 'replace'}) Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/webserver.py", line 372, in _run_handler result = await result ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/player_queues.py", line 210, in play_media await self.mass.music.mark_item_played( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py", line 508, in mark_item_played await self.database.insert( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 105, in insert await self.execute(sql_query, values) File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 151, in execute return await self._db.execute(query, values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 190, in execute cursor = await self._execute(self._conn.execute, sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 133, in _execute return await future ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 106, in run result = function() ^^^^^^^^^^ sqlite3.OperationalError: table playlog has no column named media_type 2023-08-05 09:59:47.275 INFO (MainThread) [music_assistant.players] Player registered: 92e62147-7f8f-6368-0fc9-00226ec5c441/MIBOX4 2023-08-05 09:59:56.966 INFO (ThreadPoolExecutor-0_2) [pychromecast] Quitting current app 2023-08-05 09:59:56.966 INFO (ThreadPoolExecutor-0_2) [pychromecast.controllers] Receiver:Stopping current app 'E8C28D3C' 2023-08-05 09:59:56.978 INFO (ThreadPoolExecutor-0_2) [pychromecast.controllers] Receiver:Launching app CC1AD845 2023-08-05 10:00:04.452 ERROR (MainThread) [music_assistant.webserver] [140471266292752] Error handling message: CommandMessage(message_id=43, command='players/queue/play_media', args={'queue_id': '57cd4a7d-6af7-b684-bcfb-33a72f38da59', 'media': ['library://playlist/2'], 'option': 'replace'}) Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/webserver.py", line 372, in _run_handler result = await result ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/player_queues.py", line 210, in play_media await self.mass.music.mark_item_played( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py", line 508, in mark_item_played await self.database.insert( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 105, in insert await self.execute(sql_query, values) File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 151, in execute return await self._db.execute(query, values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 190, in execute cursor = await self._execute(self._conn.execute, sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 133, in _execute return await future ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 106, in run result = function() ^^^^^^^^^^ sqlite3.OperationalError: table playlog has no column named media_type 2023-08-05 10:00:10.329 ERROR (MainThread) [music_assistant.webserver] [140471266292752] Error handling message: CommandMessage(message_id=45, command='players/queue/play_media', args={'queue_id': '92e62147-7f8f-6368-0fc9-00226ec5c441', 'media': ['library://playlist/2'], 'option': 'replace'}) Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/webserver.py", line 372, in _run_handler result = await result ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/player_queues.py", line 210, in play_media await self.mass.music.mark_item_played( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py", line 508, in mark_item_played await self.database.insert( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 105, in insert await self.execute(sql_query, values) File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 151, in execute return await self._db.execute(query, values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 190, in execute cursor = await self._execute(self._conn.execute, sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 133, in _execute return await future ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 106, in run result = function() ^^^^^^^^^^ sqlite3.OperationalError: table playlog has no column named media_type 2023-08-05 10:00:26.813 ERROR (ThreadPoolExecutor-0_1) [asyncio] Task exception was never retrieved future: <Task finished name='Task-281' coro=<StreamsController.serve_queue_item_stream..read_audio() done, defined at /usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/streams.py:522> exception=OperationalError('table playlog has no column named media_type')> Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/audio.py", line 491, in get_media_stream raise err File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/audio.py", line 441, in get_media_stream async for chunk in ffmpeg_proc.iter_chunked(chunk_size): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/process.py", line 71, in iter_chunked chunk = await self.readexactly(n) ^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/process.py", line 89, in readexactly return await self._proc.stdout.readexactly(n) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/asyncio/streams.py", line 729, in readexactly await self._wait_for_data('readexactly') File "/usr/local/lib/python3.11/asyncio/streams.py", line 522, in _wait_for_data await self._waiter asyncio.exceptions.CancelledError

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/streams.py", line 524, in read_audio async for chunk in get_media_stream( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/audio.py", line 496, in get_media_stream await mass.music.mark_item_played( File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 106, in run result = function() ^^^^^^^^^^ sqlite3.OperationalError: table playlog has no column named media_type 2023-08-05 10:00:38.504 ERROR (MainThread) [music_assistant.webserver] [140471266292752] Error handling message: CommandMessage(message_id=46, command='players/queue/play_media', args={'queue_id': '92e62147-7f8f-6368-0fc9-00226ec5c441', 'media': ['library://playlist/2'], 'option': 'replace'}) Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/webserver.py", line 372, in _run_handler result = await result ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/player_queues.py", line 210, in play_media await self.mass.music.mark_item_played( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py", line 508, in mark_item_played await self.database.insert( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 105, in insert await self.execute(sql_query, values) File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 151, in execute return await self._db.execute(query, values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 190, in execute cursor = await self._execute(self._conn.execute, sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 133, in _execute return await future ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 106, in run result = function() ^^^^^^^^^^ sqlite3.OperationalError: table playlog has no column named media_type 2023-08-05 10:00:46.719 ERROR (MainThread) [music_assistant.webserver] [140471266292752] Error handling message: CommandMessage(message_id=47, command='players/queue/play_media', args={'queue_id': '57cd4a7d-6af7-b684-bcfb-33a72f38da59', 'media': ['library://playlist/2'], 'option': 'replace_next'}) Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/webserver.py", line 372, in _run_handler result = await result ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/player_queues.py", line 210, in play_media await self.mass.music.mark_item_played( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py", line 508, in mark_item_played await self.database.insert( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 105, in insert await self.execute(sql_query, values) File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 151, in execute return await self._db.execute(query, values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 190, in execute cursor = await self._execute(self._conn.execute, sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 133, in _execute return await future ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 106, in run result = function() ^^^^^^^^^^ sqlite3.OperationalError: table playlog has no column named media_type 2023-08-05 10:00:50.365 ERROR (MainThread) [music_assistant.webserver] [140471266292752] Error handling message: CommandMessage(message_id=48, command='players/queue/play_media', args={'queue_id': '57cd4a7d-6af7-b684-bcfb-33a72f38da59', 'media': ['library://playlist/2'], 'option': 'add'}) Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/webserver.py", line 372, in _run_handler result = await result ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/player_queues.py", line 210, in play_media await self.mass.music.mark_item_played( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py", line 508, in mark_item_played await self.database.insert( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 105, in insert await self.execute(sql_query, values) File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 151, in execute return await self._db.execute(query, values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 190, in execute cursor = await self._execute(self._conn.execute, sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 133, in _execute return await future ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 106, in run result = function() ^^^^^^^^^^ sqlite3.OperationalError: table playlog has no column named media_type 2023-08-05 10:01:39.349 INFO (MainThread) [music_assistant.players] Player registered: uuid:b81ad56d-a181-dbee-006c-5c55fa887052/[LG] webOS TV 2023-08-05 10:03:50.869 ERROR (MainThread) [music_assistant.webserver] [140471208142672] Error handling message: CommandMessage(message_id=12, command='players/queue/play_media', args={'queue_id': '57cd4a7d-6af7-b684-bcfb-33a72f38da59', 'media': ['library://playlist/2'], 'option': 'replace'}) Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/webserver.py", line 372, in _run_handler result = await result ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/player_queues.py", line 210, in play_media await self.mass.music.mark_item_played( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py", line 508, in mark_item_played await self.database.insert( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 105, in insert await self.execute(sql_query, values) File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 151, in execute return await self._db.execute(query, values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 190, in execute cursor = await self._execute(self._conn.execute, sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 133, in _execute return await future ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 106, in run result = function() ^^^^^^^^^^ sqlite3.OperationalError: table playlog has no column named media_type 2023-08-05 10:03:55.522 ERROR (MainThread) [music_assistant.webserver] [140471208142672] Error handling message: CommandMessage(message_id=13, command='players/queue/play_media', args={'queue_id': '57cd4a7d-6af7-b684-bcfb-33a72f38da59', 'media': ['library://playlist/2'], 'option': 'replace'}) Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/webserver.py", line 372, in _run_handler result = await result ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/player_queues.py", line 210, in play_media await self.mass.music.mark_item_played( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py", line 508, in mark_item_played await self.database.insert( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 105, in insert await self.execute(sql_query, values) File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 151, in execute return await self._db.execute(query, values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 190, in execute cursor = await self._execute(self._conn.execute, sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 133, in _execute return await future ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 106, in run result = function() ^^^^^^^^^^ sqlite3.OperationalError: table playlog has no column named media_type 2023-08-05 10:04:12.451 ERROR (MainThread) [music_assistant.webserver] [140471208142672] Error handling message: CommandMessage(message_id=17, command='players/queue/play_media', args={'queue_id': '57cd4a7d-6af7-b684-bcfb-33a72f38da59', 'media': ['library://playlist/2'], 'option': 'replace'}) Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/webserver.py", line 372, in _run_handler result = await result ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/player_queues.py", line 210, in play_media await self.mass.music.mark_item_played( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py", line 508, in mark_item_played await self.database.insert( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 105, in insert await self.execute(sql_query, values) File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 151, in execute return await self._db.execute(query, values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 190, in execute cursor = await self._execute(self._conn.execute, sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 133, in _execute return await future ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 106, in run result = function() ^^^^^^^^^^ sqlite3.OperationalError: table playlog has no column named media_type 2023-08-05 10:04:17.647 ERROR (MainThread) [asyncio] Task exception was never retrieved future: <Task finished name='Task-445' coro=<StreamsController.serve_queue_item_stream..read_audio() done, defined at /usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/streams.py:522> exception=OperationalError('table playlog has no column named media_type')> Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/audio.py", line 491, in get_media_stream raise err File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/audio.py", line 441, in get_media_stream async for chunk in ffmpeg_proc.iter_chunked(chunk_size): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/process.py", line 71, in iter_chunked chunk = await self.readexactly(n) ^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/process.py", line 89, in readexactly return await self._proc.stdout.readexactly(n) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/asyncio/streams.py", line 729, in readexactly await self._wait_for_data('readexactly') File "/usr/local/lib/python3.11/asyncio/streams.py", line 522, in _wait_for_data await self._waiter asyncio.exceptions.CancelledError

During handling of the above exception, another exception occurred:

using lookup-album(s): DĂvka s perlami ve vlasech (Best Of)/Papirovej drak/Divadlo snĹŻ/Legendy 2/AndÄ›l PoslednĂho Soudu/American Bull (New Edition)/HledaÄŤ PokladĹŻ/RĂˇno Ve DveĹ™Ăch ArmĂˇdy SpĂˇsy/RĹŻĹľe Pro Algernon/DĂvka s perlami ve vlasech (Best Of)/Papirovej drak/Divadlo snĹŻ/Legendy 2/AndÄ›l PoslednĂho Soudu/American Bull (New Edition)/HledaÄŤ PokladĹŻ/RĂˇno Ve DveĹ™Ăch ArmĂˇdy SpĂˇsy/RĹŻĹľe Pro Algernon
using lookup-track(s): DĂvka S Perlami Ve Vlasech/Nechte vlajky vlĂˇt/BarĂˇk Na VodstĹ™el/DĂvka s perlami ve vlasech 2000 (GyĂ¶ngyhajĂş lĂˇny)/VĂ˝let Do BĂˇjĂ/AndĂlek/Jednou To PochopĂĹˇ/Lidi Jsou Lidi/Peklo uĹľ ÄŤekĂˇ/Noc kouzel (Poison - Alice Cooper)/V UniformÄ› Lokaje/American Bull/ZemĹ™Ăt Je NepovinnĂ˝/Sirael/RĂˇno Ve DveĹ™Ăch ArmĂˇdy SpĂˇsy/NemĂˇm/PoslednĂ legionĂˇĹ™/BĂlĂˇ PanĂ/Jako Za Mlada (Live)/PlĂˇÄŤ spĂˇlĂ smĂch (Out In The Fields - Thin Lizzy)/TulĂˇk Po HvÄ›zdĂˇch/Spravedlnost BĂ˝vĂˇ SlepĂˇ/DĂky Za KaĹľdej Den/Satanica/DĂˇvno (feat. Blanka Ĺ rĹŻmovĂˇ)

2023-08-05 10:04:46.102 ERROR (MainThread) [music_assistant.webserver] [140471208142672] Error handling message: CommandMessage(message_id=27, command='players/queue/play_media', args={'queue_id': '57cd4a7d-6af7-b684-bcfb-33a72f38da59', 'media': ['library://playlist/2'], 'option': 'replace'}) Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/webserver.py", line 372, in _run_handler result = await result ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/player_queues.py", line 210, in play_media await self.mass.music.mark_item_played( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py", line 508, in mark_item_played await self.database.insert( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 105, in insert await self.execute(sql_query, values) File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 151, in execute return await self._db.execute(query, values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 190, in execute cursor = await self._execute(self._conn.execute, sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 133, in _execute return await future ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 106, in run result = function() ^^^^^^^^^^ sqlite3.OperationalError: table playlog has no column named media_type 2023-08-05 10:04:57.345 ERROR (MainThread) [music_assistant.webserver] [140471208142672] Error handling message: CommandMessage(message_id=31, command='music/recently_played_items', args={'limit': 20, 'media_types': ['track', 'radio']}) Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/webserver.py", line 372, in _run_handler result = await result ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py", line 301, in recently_played db_rows = await self.mass.music.database.get_rows_from_query(query, limit=limit) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 54, in get_rows_from_query return await self._db.execute_fetchall(query, params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 209, in execute_fetchall return await self._execute(self._execute_fetchall, sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 133, in _execute return await future ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 106, in run result = function() ^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 85, in _execute_fetchall cursor = self._conn.execute(sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ sqlite3.OperationalError: no such column: media_type 2023-08-05 10:04:57.374 ERROR (MainThread) [music_assistant.webserver] [140471208142672] Error handling message: CommandMessage(message_id=34, command='music/recently_played_items', args={'limit': 10, 'media_types': ['playlist']}) Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/webserver.py", line 372, in _run_handler result = await result ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py", line 301, in recently_played db_rows = await self.mass.music.database.get_rows_from_query(query, limit=limit) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 54, in get_rows_from_query return await self._db.execute_fetchall(query, params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 209, in execute_fetchall return await self._execute(self._execute_fetchall, sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 133, in _execute return await future ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 106, in run result = function() ^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 85, in _execute_fetchall cursor = self._conn.execute(sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ sqlite3.OperationalError: no such column: media_type 2023-08-05 10:04:57.378 ERROR (MainThread) [music_assistant.webserver] [140471208142672] Error handling message: CommandMessage(message_id=35, command='music/recently_played_items', args={'limit': 10, 'media_types': ['radio']}) Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/webserver.py", line 372, in _run_handler result = await result ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py", line 301, in recently_played db_rows = await self.mass.music.database.get_rows_from_query(query, limit=limit) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 54, in get_rows_from_query return await self._db.execute_fetchall(query, params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 209, in execute_fetchall return await self._execute(self._execute_fetchall, sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 133, in _execute return await future ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 106, in run result = function() ^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 85, in _execute_fetchall cursor = self._conn.execute(sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ sqlite3.OperationalError: no such column: media_type 2023-08-05 10:04:57.791 WARNING (Thread-6) [music_assistant.providers.chromecast] Load media failed: None - error code: 104 2023-08-05 10:05:16.696 ERROR (MainThread) [music_assistant.webserver] [140471208142672] Error handling message: CommandMessage(message_id=42, command='players/queue/play_media', args={'queue_id': '57cd4a7d-6af7-b684-bcfb-33a72f38da59', 'media': ['library://playlist/2'], 'option': 'replace'}) Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/webserver.py", line 372, in _run_handler result = await result ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/player_queues.py", line 210, in play_media await self.mass.music.mark_item_played( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py", line 508, in mark_item_played await self.database.insert( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 105, in insert await self.execute(sql_query, values) File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 151, in execute return await self._db.execute(query, values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 190, in execute cursor = await self._execute(self._conn.execute, sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 133, in _execute return await future ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 106, in run result = function() ^^^^^^^^^^ sqlite3.OperationalError: table playlog has no column named media_type 2023-08-05 10:05:23.183 ERROR (MainThread) [music_assistant.webserver] [140471208142672] Error handling message: CommandMessage(message_id=43, command='players/queue/play_media', args={'queue_id': '57cd4a7d-6af7-b684-bcfb-33a72f38da59', 'media': ['library://playlist/2'], 'option': 'replace'}) Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/webserver.py", line 372, in _run_handler result = await result ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/player_queues.py", line 210, in play_media await self.mass.music.mark_item_played( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py", line 508, in mark_item_played await self.database.insert( File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 105, in insert await self.execute(sql_query, values) File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py", line 151, in execute return await self._db.execute(query, values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 190, in execute cursor = await self._execute(self._conn.execute, sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 133, in _execute return await future ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/aiosqlite/core.py", line 106, in run result = function() ^^^^^^^^^^ sqlite3.OperationalError: table playlog has no column named media_type 2023-08-05 10:06:57.958 ERROR (MainThread) [asyncio] Task exception was never retrieved future: <Task finished name='Task-616' coro=<StreamsController.serve_queue_item_stream..read_audio() done, defined at /usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/streams.py:522> exception=OperationalError('table playlog has no column named media_type')> Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/audio.py", line 491, in get_media_stream raise err File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/audio.py", line 441, in get_media_stream async for chunk in ffmpeg_proc.iter_chunked(chunk_size): File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/process.py", line 71, in iter_chunked chunk = await self.readexactly(n) ^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/process.py", line 89, in readexactly return await self._proc.stdout.readexactly(n) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/asyncio/streams.py", line 729, in readexactly await self._wait_for_data('readexactly') File "/usr/local/lib/python3.11/asyncio/streams.py", line 522, in _wait_for_data await self._waiter asyncio.exceptions.CancelledError

During handling of the above exception, another exception occurred:

Additional information

No response

What version of Home Assistant Core are your running

2023.8.0

What type of installation are you running?

Home Assistant OS

On what type of hardware are you running?

Generic x86-64 (e.g. Intel NUC)

music-assistant / hass-music-assistant