I was using an Intel NUC for Kodi (Windows) and just got the Vero working. I seem to be running into an issue I previously fixed in MySQL, where table MyVideos116.tvshow, as well as table MyVideos116.movie is having an issue with column c08 because of the length of data pulled down for fanart purposes. This is detailed for tvshows here: Fields too small in MySQL Database (Solution included) · Issue #15768 · xbmc/xbmc · GitHub
…and the comment describing the fix is here: Fields too small in MySQL Database (Solution included) · Issue #15768 · xbmc/xbmc · GitHub
I detailed the movie table issue and fix here: Too many fanart images for scrapers: Data too long for MySQL tables (error 1406)
I have not had this issue on my Windows box since changing c08 from type “text” to a type “mediumtext”. However, the same movies are now showing the same error in the log file on the Vero. Is there something different with the OSMC build which might be impacting this?
Here’s a snippet from the log while it’s trying to import The Avengers movie:
2020-08-24 01:38:12.878 T:3262108384 WARNING: VideoInfoScanner: Error 1 occurred while retrievinginformation for smb://w7-server/Videos/Movies/Marvel Cinematic Universe/MCU 22 Avengers Endgame (2019)/Avengers Endgame (2019)/Avengers Endgame (2019) 3D SBS [Bluray-Disk].mk3d.
Query: UPDATE movie SET c00='The Avengers',c01='Nick Fury is the director of S.H.I.E.L.D., an international peace-keeping agency. The agency is a who\'s who of Marvel Super Heroes, with Iron Man, The Incredible Hulk, Thor, Captain America, Hawkeye and Black Widow. When global security is threatened by Loki and his cohorts, Nick Fury and his team will need all their powers to save the world from disaster which is formed by Loki and his team',c02='Earth\'s mightiest heroes must come together and learn to fight as a team if they are going to stop the mischievous Loki and his alien army from enslaving humanity.',c03='Avengers Assemble!',c05='11092',c06='Joss Whedon / Zak Penn',c08='<thumb aspect=\"set.poster\" preview=\"https://assets.fanart.tv/preview/movies/86311/movieposter/the-avengers-collection-55c68ed2c629b.jpg\">https://assets.fanart.tv/fanart/movies/86311/movieposter/the-avengers-collection-55c68ed2c629b.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://assets.fanart.tv/preview/movies/86311/movieposter/the-avengers-collection-53c9574c98d77.jpg\">https://assets.fanart.tv/fanart/movies/86311/movieposter/the-avengers-collection-53c9574c98d77.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://assets.fanart.tv/preview/movies/86311/movieposter/the-avengers-collection-57a8963044617.jpg\">https://assets.fanart.tv/fanart/movies/86311/movieposter/the-avengers-collection-57a8963044617.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://assets.fanart.tv/preview/movies/86311/movieposter/the-avengers-collection-55c68ed2c629b.jpg\">https://assets.fanart.tv/fanart/movies/86311/movieposter/the-avengers-collection-55c68ed2c629b.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://assets.fanart.tv/preview/movies/86311/movieposter/the-avengers-collection-53c9574c98d77.jpg\">https://assets.fanart.tv/fanart/movies/86311/movieposter/the-avengers-collection-53c9574c98d77.jpg</thumb><thumb aspect=\"set.poster\" preview=\"https://assets.fanart.tv/preview/movies/86311/movieposter/the-avengers-collection-57a8963044617.jpg\">https://assets.fanart.tv/fanart/movies/86311/movieposter/the-avengers-collection-57a8963044617.jpg</thumb><thumb aspect=\"set.fanart\" preview=\"https://assets.fanart.tv/preview/movies/86311/moviebackground/the-avengers-collection-555648a1a691a.jpg\">https://assets.fanart.tv/fanart/movies/86311/moviebackground/the-avengers-collection-555648a1a691a.jpg</thumb><thumb aspect=\"set.fanart\" preview=\"https://assets.fanart.tv/preview/movies/86311/moviebackground/the-avengers-collection-5cb61d86d1aa8.jpg\">https://assets.fanart.tv/fanart/movies/86311/moviebackground/the-avengers-collection-5cb61d86d1aa8.jpg</thumb><thumb aspect=\"set.fanart\" preview=\"https://assets.fanart.tv/preview/movies/86311/moviebackground/the-avengers-collection-5cb4b00fa3b04.jpg\">https://assets.fanart.tv/fanart/movies/86311/moviebackground/the-avengers-collection-5cb4b00fa3b04.jpg</thumb><thumb aspect=\"set.fanart\" preview=\"https://assets.fanart.tv/preview/movies/86311/moviebackground/the-avengers-collection-5393367870445.jpg\">https://assets.fanart.tv/fanart/movies/86311/moviebackground/the-avengers-collection-5393367870445.jpg</thumb><thumb aspect=\"set.fanart\" preview=\"https://assets.fanart.tv/preview/movies/86311/moviebackground/the-avengers-collection-512952b5902b4.jpg\">https://assets.fanart.tv/fanart/movies/86311/moviebackground/the-avengers-collection-512952b5902b4.jpg</thumb><thumb aspect=\"set.fanart\" preview=\"https://assets.fanart.tv/preview/movies/86311/moviebackground/the-avengers-collection-5393346e4cba9.jpg\">https://assets.fanart.tv/fanart/movies/86311/moviebackground/the-avengers-collection-5393346e4cba9.jpg</thumb><thumb aspect=\"set.fanart\" preview=\"https://assets.fanart.tv/preview/movies/86311/moviebackground/the-avengers-collection-5606df109563f.jpg\">https://assets.fanart.tv/fanart/movies/86311/moviebackground/the-avengers-collection-5606df109563f.jpg</thumb><thumb aspect=\"set.fanart\" preview=\"https://assets.fanart.tv/preview/movies/86311/moviebackground/the-avengers-collection-512952c25255e.jpg\">https://assets.fanart.tv/fanart/movies/86311/moviebackground/the-avengers-collection-512952c25255e.jpg</thumb><thumb aspect=\"set.fanart\" preview=\"https://assets.fanart.tv/preview/movies/86311/moviebackground/the-avengers-collection-5bfbc95967087.jpg\">https://assets.fanart.tv/fanart/movies/86311/moviebackground/the-avengers-collection-5bfbc95967087.jpg</thumb><thumb aspect=\"set.fanart\" preview=\"https://assets.fanart.tv/preview/movies/86311/moviebackground/the-avengers-collection-57a896531fef9.jpg\">https://assets.fanart.tv/fanart/movies/86311/moviebackground/the-avengers-collection-57a896531fef9.jpg</thumb><thumb aspect=\"set.clearlogo\" preview=\"https://assets.fanart.tv/preview/movies/86311/hdmovielogo/the-avengers-collection-53c953dbcb6cb.png\">https://assets.fanart.tv/fanart/movies/86311/hdmovielogo/the-avengers-collection-53c953dbcb6cb.png</thumb><thumb aspect=\"set.clearlogo\" preview=\"https://assets.fanart.tv/preview/movies/86311/hdmovielogo/the-avengers-collection-5590a1de2f74b.png\">https://assets.fanart.tv/fanart/movies/86311/hdmovielogo/the-avengers-collection-5590a1de2f74b.png</thumb><thumb aspect=\"set.clearlogo\" preview=\"https://assets.fanart.tv/preview/movies/86311/hdmovielogo/the-avengers-collection-51fa5f09a630c.png\">https://assets.fanart.tv/fanart/movies/86311/hdmovielogo/the-avengers-collection-51fa5f09a630c.png</thumb><thumb aspect=\"set.clearlogo\" preview=\"https://assets.fanart.tv/preview/movies/86311/hdmovielogo/the-avengers-collection-51f8daf60ccb6.png\">https://assets.fanart.tv/fanart/movies/86311/hdmovielogo/the-avengers-collection-51f8daf60ccb6.png</thumb><thumb aspect=\"set.clearlogo\" preview=\"https://assets.fanart.tv/preview/movies/86311/hdmovielogo/the-avengers-collection-53c953dbcb6cb.png\">https://assets.fanart.tv/fanart/movies/86311/hdmovielogo/the-avengers-collection-53c953dbcb6cb.png</thumb><thumb aspect=\"set.clearlogo\" preview=\"https://assets.fanart.tv/preview/movies/86311/hdmovielogo/the-avengers-collection-5590a1de2f74b.png\">https://assets.fanart.tv/fanart/movies/86311/hdmovielogo/the-avengers-collection-5590a1de2f74b.png</thumb><thumb aspect=\"set.clearlogo\" preview=\"https://assets.fanart.tv/preview/movies/86311/hdmovielogo/the-avengers-collection-51fa5f09a630c.png\">https://assets.fanart.tv/fanart/movies/86311/hdmovielogo/the-avengers-collection-51fa5f09a630c.png</thumb><thumb aspect=\"set.clearlogo\" preview=\"https://assets.fanart.tv/preview/movies/86311/hdmovielogo/the-avengers-collection-51f8daf60ccb6.png\">https://assets.fanart.tv/fanart/movies/86311/hdmovielogo/the-avengers-collection-51f8daf60ccb6.png</thumb><thumb aspect=\"set.clearart\" preview=\"https://assets.fanart.tv/preview/movies/86311/hdmovieclearart/the-avengers-collection-57a8963c848ae.png\">https://assets.fanart.tv/fanart/movies/86311/hdmovieclearart/the-avengers-collection-57a8963c848ae.png</thumb><thumb aspect=\"set.clearart\" preview=\"https://assets.fanart.tv/preview/movies/86311/hdmovieclearart/the-avengers-collection-57a8963c848ae.png\">https://assets.fanart.tv/fanart/movies/86311/hdmovieclearart/the-avengers-collection-57a8963c848ae.png</thumb><thumb aspect=\"set.banner\" preview=\"https://assets.fanart.tv/preview/movies/86311/moviebanner/the-avengers-collection-55efec713808a.jpg\">https://assets.fanart.tv/fanart/movies/86311/moviebanner/the-avengers-collection-55efec713808a.jpg</thumb><thumb aspect=\"set.banner\" preview=\"https://assets.fanart.tv/preview/movies/86311/moviebanner/the-avengers-collection-57a8993cee66d.jpg\">https://assets.fanart.tv/fanart/movies/86311/moviebanner/the-avengers-collection-57a8993cee66d.jpg</thumb><thumb aspect=\"set.banner\" preview=\"https://assets.fanart.tv/preview/movies/86311/moviebanner/the-avengers-collection-51fa5f1cd80b7.jpg\">https://assets.fanart.tv/fanart/movies/86311/moviebanner/the-avengers-collection-51fa5f1cd80b7.jpg</thumb><thumb aspect=\"set.banner\" preview=\"https://assets.fanart.tv/preview/movies/86311/moviebanner/the-avengers-collection-59142a6cb8d4d.jpg\">https://assets.fanart.tv/fana
Here’s what the error looks like:
2020-08-24 04:13:58.827 T:3872383712 ERROR: CCurlFile::FillBuffer - Failed: HTTP returned error 400
2020-08-24 04:14:01.343 T:3872383712 ERROR: SQL: [mysql116] Undefined MySQL error: Code (1406)
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'
unix_err:'2' error : 'No such file or directory'