Can't sync audio

[Uatschitchun]

Whenever I try to add my Audio-library to kodi I get an error message:

There was an error, you can restart kodi tp progress the scanning (message is in german)

The kodi.log shows:

2019-03-02 19:33:25.692 T:140312462739200  NOTICE: JELLYFIN.entrypoint.default -> path: ?mode=addlibs params: {
                                                "mode": "addlibs"
                                            }
2019-03-02 19:33:25.692 T:140312462739200  NOTICE: JELLYFIN.default -> ---<[ default ]
2019-03-02 19:33:28.714 T:140312113293056  NOTICE: JELLYFIN.full_sync -> -->[ fullsync ]
2019-03-02 19:33:28.741 T:140312113293056  NOTICE: JELLYFIN.full_sync -> starting sync with [u'16795e3accb36058bd2737dc153fc696', u'Boxsets:', u'Boxsets:Refresh']
2019-03-02 19:33:28.795 T:140312113293056  NOTICE: JELLYFIN.helper.wrapper -> Processing Hörbücher: 16795e3accb36058bd2737dc153fc696
2019-03-02 19:33:29.011 T:140312113293056  NOTICE: JELLYFIN.objects.music -> UPDATE artist [2] (T)raumschiff Surprise Periode: abfcd8d0e584252b4889713f35cef20b
2019-03-02 19:33:29.210 T:140312113293056  NOTICE: JELLYFIN.objects.music -> UPDATE album [1] Loom - Das Hörspiel: 8fd29d90d88aec910face816ac5d8b7b
2019-03-02 19:33:29.239 T:140312113293056  NOTICE: JELLYFIN.database -> ERROR:: type: <class 'sqlite3.OperationalError'> value: no such column: strArtists
2019-03-02 19:33:29.240 T:140312113293056  NOTICE: JELLYFIN.database -> [jellyfin] 39 rows updated.
2019-03-02 19:33:29.258 T:140312113293056  NOTICE: JELLYFIN.database -> ERROR:: type: <class 'sqlite3.OperationalError'> value: no such column: strArtists
2019-03-02 19:33:29.259 T:140312113293056  NOTICE: JELLYFIN.database -> [music] 184 rows updated.
2019-03-02 19:34:17.796 T:140312113293056  NOTICE: JELLYFIN.full_sync -> ERROR:: full sync exited unexpectedly
2019-03-02 19:34:17.804 T:140312113293056  NOTICE: JELLYFIN.full_sync -> --<[ fullsync ]
2019-03-02 19:34:17.805 T:140312113293056  NOTICE: JELLYFIN.library -> ERROR:: no such column: strArtists
                                            Traceback (most recent call last):
                                              File "/home/uatschitchun/.kodi/addons/plugin.video.jellyfin/resources/lib/library.py", line 524, in add_library
                                                sync.libraries(library_id, update)
                                              File "/home/uatschitchun/.kodi/addons/plugin.video.jellyfin/resources/lib/full_sync.py", line 103, in libraries
                                                self.start()
                                              File "/home/uatschitchun/.kodi/addons/plugin.video.jellyfin/resources/lib/full_sync.py", line 193, in start
                                                self.process_library(library)
                                              File "/home/uatschitchun/.kodi/addons/plugin.video.jellyfin/resources/lib/full_sync.py", line 242, in process_library
                                                media[library['CollectionType']](library)
                                              File "/home/uatschitchun/.kodi/addons/plugin.video.jellyfin/resources/lib/helper/wrapper.py", line 38, in wrapper
                                                result = func(self, dialog=dialog, *args, **kwargs)
                                              File "/home/uatschitchun/.kodi/addons/plugin.video.jellyfin/resources/lib/full_sync.py", line 418, in music
                                                obj.album(album)
                                              File "/home/uatschitchun/.kodi/addons/plugin.video.jellyfin/resources/lib/helper/wrapper.py", line 97, in wrapper
                                                return func(*args, **kwargs)
                                              File "/home/uatschitchun/.kodi/addons/plugin.video.jellyfin/resources/lib/helper/wrapper.py", line 110, in wrapper
                                                return func(self, item, e_item=e_item, *args, **kwargs)
                                              File "/home/uatschitchun/.kodi/userdata/addon_data/plugin.video.jellyfin/jellyfin/objects/music.py", line 165, in album
                                                self.update_album(*values(obj, QU.update_album_obj))
                                              File "/home/uatschitchun/.kodi/userdata/addon_data/plugin.video.jellyfin/jellyfin/objects/kodi/music.py", line 154, in update_album
                                                self.cursor.execute(QU.update_album, args)
                                            OperationalError: no such column: strArtists
2019-03-02 19:34:19.294 T:140312487917312  NOTICE: JELLYFIN.entrypoint.default -> path: ?mode=managelibs params: {
                                                "mode": "managelibs"
                                            }
2019-03-02 19:34:19.316 T:140312487917312  NOTICE: JELLYFIN.default -> ---<[ default ]

What to do?

[jee-r]

Same issue with a large music library more than 1K albums, i remove the music library in the jellyfin-kodi settings for the moment. i can't provide any logs sorry :/

[jerome00253]

Same issue with audio sync.
No problems with video and Tv Show.

2019-05-08 14:16:54.900 T:1937576608 NOTICE: Log level changed to "LOG_LEVEL_NORMAL"
2019-05-08 14:24:20.147 T:1456460656 ERROR: GetDirectory - Error getting
2019-05-08 14:24:20.884 T:1464853360 ERROR: Previous line repeats 3 times.
2019-05-08 14:24:20.884 T:1464853360 NOTICE: JELLYFIN.entrypoint.default -> path: ?content_type=audio params: {
"content_type": "audio"
}
2019-05-08 14:24:21.054 T:1464853360 NOTICE: JELLYFIN.default -> ---<[ default ]
2019-05-08 14:24:24.517 T:1464853360 NOTICE: JELLYFIN.entrypoint.default -> path: ?mode=restartservice params: {
"mode": "restartservice"
}
2019-05-08 14:24:24.518 T:1464853360 NOTICE: JELLYFIN.default -> ---<[ default ]
2019-05-08 14:24:24.751 T:1562370928 NOTICE: JELLYFIN.entrypoint.service -> ---<[ EXITING ]
2019-05-08 14:24:24.756 T:1790935920 NOTICE: JELLYFIN.jellyfin.core.ws_client -> ERROR:: tuple index out of range
2019-05-08 14:24:24.756 T:1790935920 NOTICE: JELLYFIN.jellyfin.core.ws_client -> ---<[ websocket ]
2019-05-08 14:24:24.757 T:1562370928 NOTICE: Jellyfin.jellyfin.core.http -> --<[ session/1483683664 ]
2019-05-08 14:24:24.759 T:1562370928 NOTICE: Jellyfin -> ---[ STOPPED ALL JELLYFINCLIENTS ]---
2019-05-08 14:24:24.762 T:1807721328 NOTICE: JELLYFIN.webservice -> ---<[ webservice ]
2019-05-08 14:24:24.765 T:1562370928 NOTICE: JELLYFIN.entrypoint.service -> ---<<<[ JELLYFIN ]
2019-05-08 14:24:24.810 T:1562370928 NOTICE: JELLYFIN.entrypoint.service -> ---[ objects reloaded ]
2019-05-08 14:24:24.900 T:1562370928 NOTICE: JELLYFIN.entrypoint.service -> --->>>[ JELLYFIN ]
2019-05-08 14:24:24.901 T:1562370928 NOTICE: JELLYFIN.entrypoint.service -> Version: 10.1.0
2019-05-08 14:24:24.902 T:1562370928 NOTICE: JELLYFIN.entrypoint.service -> KODI Version: 18.1 Git:newclock5_18.1-Leia
2019-05-08 14:24:24.912 T:1562370928 NOTICE: JELLYFIN.entrypoint.service -> Platform: LibreElec
2019-05-08 14:24:24.913 T:1562370928 NOTICE: JELLYFIN.entrypoint.service -> Python Version: 2.7.15 (default, Feb 21 2019, 01:57:03)
[GCC 8.2.0]
2019-05-08 14:24:24.925 T:1562370928 NOTICE: JELLYFIN.entrypoint.service -> Using dynamic paths: True
2019-05-08 14:24:24.925 T:1562370928 NOTICE: JELLYFIN.entrypoint.service -> Log Level: 1
2019-05-08 14:24:24.930 T:1562370928 NOTICE: JELLYFIN.entrypoint.service -> ---[ db/None ]
2019-05-08 14:24:24.943 T:1562370928 NOTICE: JELLYFIN.jellyfin.core.configuration -> Begin http constructor.
2019-05-08 14:24:24.945 T:1562370928 NOTICE: Jellyfin -> ---[ START JELLYFINCLIENT ]---
2019-05-08 14:24:25.028 T:1562370928 NOTICE: JELLYFIN.views -> ERROR:: Unable to retrieve libraries: 'NoneType' object has no attribute 'encode'
2019-05-08 14:24:25.141 T:1502835568 NOTICE: JELLYFIN.monitor -> ---<[ listener ]
2019-05-08 14:24:26.418 T:1511228272 NOTICE: JELLYFIN.library -> ---<[ library ]
2019-05-08 14:24:29.058 T:1562370928 NOTICE: JELLYFIN.client -> DeviceId loaded: F562F6A58A91488BA3EAE1055DB02A03
2019-05-08 14:24:29.060 T:1511228272 NOTICE: JELLYFIN.monitor -> --->[ listener ]
2019-05-08 14:24:29.062 T:1519620976 NOTICE: JELLYFIN.webservice -> --->[ webservice/57578 ]
2019-05-08 14:24:29.083 T:1562370928 NOTICE: JELLYFIN.connect -> --[ server/default ]
2019-05-08 14:24:29.104 T:1562370928 NOTICE: JELLYFIN.jellyfin.core.configuration -> Begin app constructor.
2019-05-08 14:24:29.125 T:1562370928 NOTICE: JELLYFIN.jellyfin.core.connection_manager -> Begin connect
2019-05-08 14:24:29.126 T:1562370928 NOTICE: JELLYFIN.jellyfin.core.connection_manager -> Begin getAvailableServers
2019-05-08 14:24:30.135 T:1562370928 NOTICE: JELLYFIN.jellyfin.core.connection_manager -> Found Servers: []
2019-05-08 14:24:30.137 T:1562370928 NOTICE: JELLYFIN.jellyfin.core.connection_manager -> Begin connectToServers, with 1 servers
2019-05-08 14:24:30.138 T:1562370928 NOTICE: JELLYFIN.jellyfin.core.connection_manager -> begin connectToServer
2019-05-08 14:24:30.138 T:1562370928 NOTICE: JELLYFIN.jellyfin.core.connection_manager -> beginning connection tests
2019-05-08 14:24:30.139 T:1562370928 NOTICE: JELLYFIN.jellyfin.core.connection_manager -> testing connection mode 2 with server Jellyfin Jerome
2019-05-08 14:24:30.140 T:1562370928 NOTICE: JELLYFIN.jellyfin.core.connection_manager -> tryConnect url: http://192.168.0.99:8096/emby/system/info/public
2019-05-08 14:24:30.429 T:1562370928 NOTICE: JELLYFIN.jellyfin.core.connection_manager -> calling onSuccessfulConnection with connection mode 2 with server Jellyfin Jerome
2019-05-08 14:24:30.789 T:1562370928 NOTICE: JELLYFIN.jellyfin.client -> User is authenticated.
2019-05-08 14:24:30.936 T:1502835568 NOTICE: JELLYFIN.jellyfin.core.ws_client -> Websocket url: ws://192.168.0.99:8096/embywebsocket?api_key=f8d51180509d4960ba6589b9f7e33b6c&device_id=F562F6A58A91488BA3EAE1055DB02A03
2019-05-08 14:24:30.936 T:1562370928 NOTICE: JELLYFIN.setup -> ---<[ setup ]
2019-05-08 14:24:30.952 T:1502835568 NOTICE: JELLYFIN.jellyfin.core.ws_client -> --->[ websocket ]
2019-05-08 14:24:31.248 T:1791107952 NOTICE: JELLYFIN.library -> --->[ library ]
2019-05-08 14:24:31.249 T:1562370928 NOTICE: JELLYFIN.monitor -> --[ post capabilities/15138daf53394d75bf2a83b2756f7d4e ]
2019-05-08 14:24:31.358 T:1791107952 NOTICE: JELLYFIN.database -> [jellyfin] 1 rows updated.
2019-05-08 14:24:31.658 T:1791107952 NOTICE: Previous line repeats 2 times.
2019-05-08 14:24:31.658 T:1791107952 NOTICE: JELLYFIN.full_sync -> -->[ fullsync ]
2019-05-08 14:24:34.822 T:1791107952 NOTICE: JELLYFIN.full_sync -> starting sync with [u'7622a5d0a7ba423f4662b123e651938d']
2019-05-08 14:24:34.935 T:1791107952 NOTICE: JELLYFIN.helper.wrapper -> Processing Musique Jazz: 7622a5d0a7ba423f4662b123e651938d
2019-05-08 14:24:35.108 T:1791107952 NOTICE: JELLYFIN.objects.music -> UPDATE artist [2] Bebel Gilberto: b6911d632e8227708c65511656b58d0b
2019-05-08 14:24:35.191 T:1791107952 NOTICE: JELLYFIN.objects.music -> UPDATE album [1] Tanto Tempo: f2071885d6250df25d99fc22720d78b6
2019-05-08 14:24:35.194 T:1791107952 NOTICE: JELLYFIN.database -> ERROR:: type: <class 'sqlite3.OperationalError'> value: no such column: strArtists
2019-05-08 14:24:35.196 T:1791107952 NOTICE: JELLYFIN.database -> [jellyfin] 3 rows updated.
2019-05-08 14:24:35.199 T:1791107952 NOTICE: JELLYFIN.database -> ERROR:: type: <class 'sqlite3.OperationalError'> value: no such column: strArtists
2019-05-08 14:24:35.199 T:1791107952 NOTICE: JELLYFIN.database -> [music] 4 rows updated.

[jmeacoe]

In Kodi 18 they changed the music.db (music72) and are now using strArtistDisp in the album table.
They have also removed a couple tables. I am looking into it, but am not positive what all the fields are for as there isn't really a data dictionary available.

I have gotten to the point where I can load my full library, but am prompted to update my tags whenever I select any music in Kodi.

[macbean101]

I was looking to make the switch from emby to jellyfin but have run in to this issue. So far, the only library i've set up is music so i ran in to this issue. Is there a fix available for this?

to be specific, my error is identical to Uatschitchun's with the no such column

[oddstr13]

@macbean101 should be fixed in #32, but I would like an additional test in Kodi 18 before merging.

You can test by installing https://github.com/jmeacoe/jellyfin-kodi/archive/master.zip via install plugin from zip in Kodi, please report back in #32 if you do test it.