Ahoj, pročetl jsem si to zde snad celé.
Postupoval jsem podle návodu.
Databáze si Kodi v MySQL vytvořil sám. Poté jsem začal tagovat a filmy z ČSFD. Nechal jsem to jet celou noc a DB podle toho co v ní vidím naplněná je.
Ale když se podívám do filmů v Kodi, tak tam žádné obrázky a popisky nejsou a v logu je napsáno(výcuc):
22:00:54.711 T:7372 NOTICE: Checking resolution 16
22:00:54.879 T:8984 NOTICE: Running database version Addons27
22:00:54.880 T:8984 NOTICE: Running database version ViewModes6
22:00:54.881 T:8984 NOTICE: Running database version Textures13
22:00:54.928 T:8984 NOTICE: Running database version MyMusic60
22:00:54.971 T:8984 NOTICE: Running database version MyVideos107
22:00:54.972 T:8984 NOTICE: Running database version TV29
22:00:54.973 T:8984 NOTICE: Running database version Epg11
22:00:55.090 T:7372 WARNING: JSONRPC: Could not parse type "Setting.Details.SettingList"
22:00:55.192 T:7372 ERROR: SQL: [MyMusic60] The table does not exist
Query: select count(idSong) as NumSongs from songview
22:00:55.192 T:7372 ERROR: CMusicDatabase::GetSongsCount() failed
22:00:55.255 T:7372 NOTICE: initialize done
22:00:55.255 T:7372 NOTICE: Running the application...
22:00:55.256 T:7372 NOTICE: starting upnp client
22:00:55.258 T:9696 NOTICE: ES: Starting UDP Event server on port 9777
22:00:55.258 T:9696 NOTICE: UDP: Listening on port 9777 (ipv6 : false)
22:00:55.322 T:8692 ERROR: SQL: [MyMusic60] The table does not exist
Query: SELECT songview.*, songartistview.* FROM (SELECT idAlbum FROM album ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum = recentalbums.idAlbum JOIN songartistview ON songview.idSong = songartistview.idSong ORDER BY songview.idAlbum DESC, songview.idSong, songartistview.idRole, songartistview.iOrder
22:00:55.322 T:8692 ERROR: CMusicDatabase::GetRecentlyAddedAlbumSongs failed
22:00:55.323 T:8692 ERROR: SQL: [MyMusic60] The table does not exist
Query: SELECT albumview.*, albumartistview.* FROM (SELECT idAlbum FROM album WHERE strAlbum != '' ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN albumview ON albumview.idAlbum = recentalbums.idAlbum JOIN albumartistview ON albumview.idAlbum = albumartistview.idAlbum ORDER BY albumview.idAlbum desc, albumartistview.iOrder
22:00:55.323 T:8692 ERROR: CMusicDatabase::GetRecentlyAddedAlbums failed
22:00:55.344 T:8692 ERROR: SQL: [MyVideos107] The table does not exist
Query: select * from movie_view ORDER BY dateAdded desc, idMovie desc LIMIT 10
22:00:55.344 T:8692 ERROR: CVideoDatabase::GetMoviesByWhere failed
22:00:55.345 T:8692 ERROR: SQL: [MyVideos107] The table does not exist
Query: select * from episode_view ORDER BY dateAdded desc, idEpisode desc LIMIT 10
22:00:55.345 T:8692 ERROR: CVideoDatabase::GetEpisodesByWhere failed
22:00:55.347 T:8692 ERROR: SQL: [MyVideos107] The table does not exist
Query: select * from musicvideo_view ORDER BY dateAdded desc, idMVideo desc LIMIT 10
22:00:55.347 T:8692 ERROR: CVideoDatabase::GetMusicVideosByWhere failed
22:00:55.358 T:8692 ERROR: SQL: [MyMusic60] The table does not exist
Query: SELECT COUNT(DISTINCT artistview.idArtist) FROM artistview WHERE ((EXISTS (SELECT 1 FROM song_artist WHERE song_artist.idArtist = artistview.idArtist AND song_artist.idRole = 1) OR EXISTS (SELECT 1 FROM album_artist WHERE album_artist.idArtist = artistview.idArtist)) AND (artistview.strArtist != '')) AND (artistview.strArtist <> 'Various artists')
Ověřoval jsem to v DB a tyto tabulky v této DB opravdu nejsou. Jak tedy tyto tabulky nechat vytvořit, když si celou DB, včetně tabulek vytvořilo Kodi samo?
Díky
P.s. Je to Kodi v17 na OS Win10 ze Store MS
Postupoval jsem podle návodu.
Databáze si Kodi v MySQL vytvořil sám. Poté jsem začal tagovat a filmy z ČSFD. Nechal jsem to jet celou noc a DB podle toho co v ní vidím naplněná je.
Ale když se podívám do filmů v Kodi, tak tam žádné obrázky a popisky nejsou a v logu je napsáno(výcuc):
22:00:54.711 T:7372 NOTICE: Checking resolution 16
22:00:54.879 T:8984 NOTICE: Running database version Addons27
22:00:54.880 T:8984 NOTICE: Running database version ViewModes6
22:00:54.881 T:8984 NOTICE: Running database version Textures13
22:00:54.928 T:8984 NOTICE: Running database version MyMusic60
22:00:54.971 T:8984 NOTICE: Running database version MyVideos107
22:00:54.972 T:8984 NOTICE: Running database version TV29
22:00:54.973 T:8984 NOTICE: Running database version Epg11
22:00:55.090 T:7372 WARNING: JSONRPC: Could not parse type "Setting.Details.SettingList"
22:00:55.192 T:7372 ERROR: SQL: [MyMusic60] The table does not exist
Query: select count(idSong) as NumSongs from songview
22:00:55.192 T:7372 ERROR: CMusicDatabase::GetSongsCount() failed
22:00:55.255 T:7372 NOTICE: initialize done
22:00:55.255 T:7372 NOTICE: Running the application...
22:00:55.256 T:7372 NOTICE: starting upnp client
22:00:55.258 T:9696 NOTICE: ES: Starting UDP Event server on port 9777
22:00:55.258 T:9696 NOTICE: UDP: Listening on port 9777 (ipv6 : false)
22:00:55.322 T:8692 ERROR: SQL: [MyMusic60] The table does not exist
Query: SELECT songview.*, songartistview.* FROM (SELECT idAlbum FROM album ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum = recentalbums.idAlbum JOIN songartistview ON songview.idSong = songartistview.idSong ORDER BY songview.idAlbum DESC, songview.idSong, songartistview.idRole, songartistview.iOrder
22:00:55.322 T:8692 ERROR: CMusicDatabase::GetRecentlyAddedAlbumSongs failed
22:00:55.323 T:8692 ERROR: SQL: [MyMusic60] The table does not exist
Query: SELECT albumview.*, albumartistview.* FROM (SELECT idAlbum FROM album WHERE strAlbum != '' ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN albumview ON albumview.idAlbum = recentalbums.idAlbum JOIN albumartistview ON albumview.idAlbum = albumartistview.idAlbum ORDER BY albumview.idAlbum desc, albumartistview.iOrder
22:00:55.323 T:8692 ERROR: CMusicDatabase::GetRecentlyAddedAlbums failed
22:00:55.344 T:8692 ERROR: SQL: [MyVideos107] The table does not exist
Query: select * from movie_view ORDER BY dateAdded desc, idMovie desc LIMIT 10
22:00:55.344 T:8692 ERROR: CVideoDatabase::GetMoviesByWhere failed
22:00:55.345 T:8692 ERROR: SQL: [MyVideos107] The table does not exist
Query: select * from episode_view ORDER BY dateAdded desc, idEpisode desc LIMIT 10
22:00:55.345 T:8692 ERROR: CVideoDatabase::GetEpisodesByWhere failed
22:00:55.347 T:8692 ERROR: SQL: [MyVideos107] The table does not exist
Query: select * from musicvideo_view ORDER BY dateAdded desc, idMVideo desc LIMIT 10
22:00:55.347 T:8692 ERROR: CVideoDatabase::GetMusicVideosByWhere failed
22:00:55.358 T:8692 ERROR: SQL: [MyMusic60] The table does not exist
Query: SELECT COUNT(DISTINCT artistview.idArtist) FROM artistview WHERE ((EXISTS (SELECT 1 FROM song_artist WHERE song_artist.idArtist = artistview.idArtist AND song_artist.idRole = 1) OR EXISTS (SELECT 1 FROM album_artist WHERE album_artist.idArtist = artistview.idArtist)) AND (artistview.strArtist != '')) AND (artistview.strArtist <> 'Various artists')
Ověřoval jsem to v DB a tyto tabulky v této DB opravdu nejsou. Jak tedy tyto tabulky nechat vytvořit, když si celou DB, včetně tabulek vytvořilo Kodi samo?
Díky
P.s. Je to Kodi v17 na OS Win10 ze Store MS