2021-01-11, 14:36
I have a problem with one Movie. I receive "No Information found".
The film is correctly recognized by the scraper, but then the information can probably not be written to the DB.
I am using an external MariaDB.
It seems like the information does not fit into the db field c08.
Edit:
This could be the solution: https://github.com/xbmc/xbmc/issues/1576...-749001187
Yes. The following command altered the Table on my DB:
The film is correctly recognized by the scraper, but then the information can probably not be written to the DB.
I am using an external MariaDB.
Code:
2021-01-11 13:33:08.236 T:6856 ERROR: SQL: [MyVideos116] Undefined MySQL error: Code (1406)
Query: UPDATE movie SET c00='Halloween - Die Nacht des Grauens',c01='1963, Halloween-Nacht im Kaff Haddonfield: Die Teenagerin Judith Myers wird in ihrem Elternhaus von ihrem sechsjährigen Bruder brutal erstochen - Michael Myers hat das erste Mal zugeschlagen! Der Junge kommt daraufhin in das Smith’s Grove Warren County Sanatorium in die Obhut von Psychiater Sam Loomis. Schon bald ist dieser davon überzeugt, dass sich in der Gestalt des Kindes das absolut Böse verbirgt. 15 Jahre danach, am Vorabend von Halloween, gelingt Michael die Flucht aus der Heilanstalt. Der maskierte Killer macht sich auf den Weg nach Haddonfield, wo sich arglose Teenager wie Laurie Strode auf ein bisschen Horrorspaß freuen...',c02='',c03='The night he came home!',c05='9553',c06='Debra Hill / John Carpenter',c08='<thumb aspect=\"set.poster\" preview=\"https://assets.fanart.tv/preview/movies/91361/movieposter/halloween-collection-5ce0310587585.jpg\">https://assets.fanart.tv/fanart/movies/91361/movieposter/halloween-collection-5ce0310587585.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://assets.fanart.tv/preview/movies/91361/movieposter/halloween-collection-5f53ce91abf58.jpg\">https://assets.fanart.tv/fanart/movies/91361/movieposter/halloween-collection-5f53ce91abf58.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/7BAoBjLCdS5dQQDqRDBbllNpyqR.jpg\">https://image.tmdb.org/t/p/original/7BAoBjLCdS5dQQDqRDBbllNpyqR.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/2uqHV6YcD9jEL2WuJYjXiiuRDqd.jpg\">https://image.tmdb.org/t/p/original/2uqHV6YcD9jEL2WuJYjXiiuRDqd.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/cLBt7Suqm6fNwhrJZAtnwENDMLo.jpg\">https://image.tmdb.org/t/p/original/cLBt7Suqm6fNwhrJZAtnwENDMLo.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/9rH2XjftQHm4OeiOFCYQAcxjF2r.jpg\">https://image.tmdb.org/t/p/original/9rH2XjftQHm4OeiOFCYQAcxjF2r.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/1vRkDRigitF6igyfQvjb2i3GG95.jpg\">https://image.tmdb.org/t/p/original/1vRkDRigitF6igyfQvjb2i3GG95.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/rCnjVKC7K5uBWtS7BSjcnLBLwS.jpg\">https://image.tmdb.org/t/p/original/rCnjVKC7K5uBWtS7BSjcnLBLwS.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/wyXaCnXYGB5fvb8rdZIlhr847bE.jpg\">https://image.tmdb.org/t/p/original/wyXaCnXYGB5fvb8rdZIlhr847bE.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/eyfZegVKa8golMdNPeZbctXveQ9.jpg\">https://image.tmdb.org/t/p/original/eyfZegVKa8golMdNPeZbctXveQ9.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/5Xyr3hNax5IVmCgFb5seXdzpZnr.jpg\">https://image.tmdb.org/t/p/original/5Xyr3hNax5IVmCgFb5seXdzpZnr.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/akUATrscWfijUlBpdyOYhHryQE5.jpg\">https://image.tmdb.org/t/p/original/akUATrscWfijUlBpdyOYhHryQE5.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/5K8k1lqFE67e5r3Xzifb8Na4VP3.jpg\">https://image.tmdb.org/t/p/original/5K8k1lqFE67e5r3Xzifb8Na4VP3.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/rWNU5cPg0oeaXtPBoZ5wFPfNHJ6.jpg\">https://image.tmdb.org/t/p/original/rWNU5cPg0oeaXtPBoZ5wFPfNHJ6.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/beCi8tfUDcvas4QAzv2hBjheNVn.jpg\">https://image.tmdb.org/t/p/original/beCi8tfUDcvas4QAzv2hBjheNVn.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/sDNv9fzlk5EyN8dUaM1xSDm1UcF.jpg\">https://image.tmdb.org/t/p/original/sDNv9fzlk5EyN8dUaM1xSDm1UcF.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/ypmNAVYIkrNSmaPyj1WPWt1C90k.jpg\">https://image.tmdb.org/t/p/original/ypmNAVYIkrNSmaPyj1WPWt1C90k.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/kCLTEMwxqUmq3SZzc6RW3AHbCpf.jpg\">https://image.tmdb.org/t/p/original/kCLTEMwxqUmq3SZzc6RW3AHbCpf.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/mmNlxzYovQ9Oa4Bd2ZzIzp7dikt.jpg\">https://image.tmdb.org/t/p/original/mmNlxzYovQ9Oa4Bd2ZzIzp7dikt.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/ezLeuHXAXpZ08JHgnZHapiFWdJO.jpg\">https://image.tmdb.org/t/p/original/ezLeuHXAXpZ08JHgnZHapiFWdJO.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/39K37T4DXR63EwaCgLV8xWb9QlE.jpg\">https://image.tmdb.org/t/p/original/39K37T4DXR63EwaCgLV8xWb9QlE.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/68z17oANEG7t2OextIy0l7nfgVt.jpg\">https://image.tmdb.org/t/p/original/68z17oANEG7t2OextIy0l7nfgVt.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/eyFBWepNXgCe69gO3EhQ6UX5UbB.jpg\">https://image.tmdb.org/t/p/original/eyFBWepNXgCe69gO3EhQ6UX5UbB.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/7BD44Vmpi7WsMZZAdZP0U5ao3vI.jpg\">https://image.tmdb.org/t/p/original/7BD44Vmpi7WsMZZAdZP0U5ao3vI.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/4DlCXdCix04yOREAsHUEV98BAS4.jpg\">https://image.tmdb.org/t/p/original/4DlCXdCix04yOREAsHUEV98BAS4.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/2jeOoWdJHFHuBGlQ4zCNY6s62X0.jpg\">https://image.tmdb.org/t/p/original/2jeOoWdJHFHuBGlQ4zCNY6s62X0.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/xthUZ9cIDkcCR2ia8PcA3RhfntZ.jpg\">https://image.tmdb.org/t/p/original/xthUZ9cIDkcCR2ia8PcA3RhfntZ.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/pesDNbxTG7NE3KrtXtEK4lAhqkg.jpg\">https://image.tmdb.org/t/p/original/pesDNbxTG7NE3KrtXtEK4lAhqkg.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/jagA2hfObpQALgmCST3gwtn4ykV.jpg\">https://image.tmdb.org/t/p/original/jagA2hfObpQALgmCST3gwtn4ykV.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/yxVa9Uo6cguW5NuxcbPCQnPaOhC.jpg\">https://image.tmdb.org/t/p/original/yxVa9Uo6cguW5NuxcbPCQnPaOhC.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/uCeHDn4BM6WerSmWi4Z8dyhmaDX.jpg\">https://image.tmdb.org/t/p/original/uCeHDn4BM6WerSmWi4Z8dyhmaDX.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/4lPmC1tOihpFGMLflh9EYeM54nV.jpg\">https://image.tmdb.org/t/p/original/4lPmC1tOihpFGMLflh9EYeM54nV.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/2J71N4rydw5KnXP059XgGcuhyCv.jpg\">https://image.tmdb.org/t/p/original/2J71N4rydw5KnXP059XgGcuhyCv.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/doSJx75U7HTCBhKAUnVd14Z7gfA.jpg\">https://image.tmdb.org/t/p/original/doSJx75U7HTCBhKAUnVd14Z7gfA.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/7csAdmybfz0FpTkVCioWQWpAsDC.jpg\">https://image.tmdb.org/t/p/original/7csAdmybfz0FpTkVCioWQWpAsDC.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/2alzm93syz6cLesC0EtvAHxnvLZ.jpg\">https://image.tmdb.org/t/p/original/2alzm93syz6cLesC0EtvAHxnvLZ.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/rasOw28YdzdPywznFEaaUdoCLkO.jpg\">https://image.tmdb.org/t/p/original/rasOw28YdzdPywznFEaaUdoCLkO.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/mhSpCA6Y19nQFVZl7s4O4V1ppVY.jpg\">https://image.tmdb.org/t/p/original/mhSpCA6Y19nQFVZl7s4O4V1ppVY.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/g492BzKolXGlFFx8elAxoa38Slk.jpg\">https://image.tmdb.org/t/p/original/g492BzKolXGlFFx8elAxoa38Slk.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://image.tmdb.org/t/p/w500/xsnuGsQxhYABrCvMeNY52UQhwuI.jpg\">https://image.tmdb.org/t/p/original/xsnuGsQxhYABrCvMeNY52UQhwuI.jpg</thumb><thumb aspect=\"se
2021-01-11 13:33:08.236 T:6856 ERROR: CVideoDatabase::SetDetailsForMovie (smb://XYZ/Halloween - Die Nacht des Grauens (1978) (tt0077651) (x264).mkv) failed
2021-01-11 13:33:08.268 T:6856 WARNING: VideoInfoScanner: Error 1 occurred while retrievinginformation for smb://XYZ/Halloween - Die Nacht des Grauens (1978) (tt0077651) (x264).mkv.
2021-01-11 13:33:09.611 T:6856 NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:05It seems like the information does not fit into the db field c08.
Edit:
This could be the solution: https://github.com/xbmc/xbmc/issues/1576...-749001187
Yes. The following command altered the Table on my DB:
Code:
ALTER TABLE MyVideos116.movie MODIFY COLUMN c08 mediumtext DEFAULT NULL NULL;