2021-07-05, 09:52
I have set up Kodi 19.1 to use a MySQL database. I use
The movie gets scanned into the library successfully:
However, as soon as I enter the Movies menu, the following happens:
As you see, not only
I don't care much for the double scanning but I care for the lost
metadata.themoviedb.org.python
to scrape the metadata in. I have a blank profile with no addons and the only ones getting loaded are those packaged with Kodi.The movie gets scanned into the library successfully:
Code:
Mysql execute: DELETE FROM streamdetails WHERE idFile = 1
...
Mysql execute: UPDATE files SET dateAdded='2020-04-24 18:33:58' WHERE idFile=1
Mysql execute: insert into movie (idMovie, idFile) values (NULL, 1)
...
Mysql execute: DELETE FROM uniqueid WHERE media_id=31 AND media_type='movie'
Mysql execute: INSERT INTO uniqueid (media_id, media_type, value, type) VALUES (31, 'movie', 'tt7541106', 'imdb')
Mysql execute: INSERT INTO uniqueid (media_id, media_type, value, type) VALUES (31, 'movie', '611605', 'tmdb')
However, as soon as I enter the Movies menu, the following happens:
Code:
------ Window Init (MyVideoNav.xml) ------
...
CGUIMediaWindow::GetDirectory (videodb://movies/titles/)
...
Mysql execute: DELETE FROM streamdetails WHERE idFile = 1
Mysql execute: INSERT INTO streamdetails (idFile, iStreamType, strVideoCodec, fVideoAspect, iVideoWidth, iVideoHeight, iVideoDuration, strStereoMode, strVideoLanguage) VALUES (1,0,'hevc',2.400000,1920,800,5412,'','und')
Mysql execute: INSERT INTO streamdetails (idFile, iStreamType, strAudioCodec, iAudioChannels, strAudioLanguage) VALUES (1,1,'aac',6,'eng')
... 35ms later
Mysql execute: DELETE FROM streamdetails WHERE idFile = 1
... 35ms later
Mysql execute: DELETE FROM uniqueid WHERE media_id=31 AND media_type='movie'
Mysql execute: INSERT INTO uniqueid (media_id, media_type, value, type) VALUES (31, 'movie', '611605', 'tmdb')
... 10ms later
Mysql execute: DELETE FROM streamdetails WHERE idFile = 1
Mysql execute: INSERT INTO streamdetails (idFile, iStreamType, strVideoCodec, fVideoAspect, iVideoWidth, iVideoHeight, iVideoDuration, strStereoMode, strVideoLanguage) VALUES (1,0,'hevc',2.400000,1920,800,5412,'','und')
Mysql execute: INSERT INTO streamdetails (idFile, iStreamType, strAudioCodec, iAudioChannels, strAudioLanguage) VALUES (1,1,'aac',6,'eng')
As you see, not only
streamdetails
is populated twice, but also the uniqueid
entries are replaced and in the process, one is lost. The full log can be found here.I don't care much for the double scanning but I care for the lost
uniqueid
; while not shown in this log, rating
entries are also removed and only one is retained (always the TMDB one). What I am trying to figure out is if this is a bug with the scraper or with Kodi, or if there is some setting that has to be adjusted to retain the extra information. Any help would be much appreciated.