(2019-11-26, 10:21)Karellen Wrote: @compuman
Please provide a --> Debug Log <-- that captures you scraping Doctor Who.
Is this show already in your library and you are adding new episodes, or is this the first time you are scraping it?
Hi,
the problem is still there after tvdb addon for kodi version 3.2.4 in KODI 18.5 (DB kodi_video116)
i see that in the log say (i write here only partial log because i think to have found the problem):
2020-02-29 18:20:29.462 T:14300 DEBUG: Mysql execute: UPDATE tvshow SET c00='Doctor Who (2005)',c01='Il Dottore è un Signore del Tempo...
2020-02-29 18:20:29.477 T:14300 ERROR: SQL: [kodi_video116] Undefined MySQL error: Code (1406)
Query: UPDATE tvshow SET c00='Doctor Who (2005)',c01='Il...
2020-02-29 18:20:29.477 T:14300 ERROR: CDatabase::ExecuteQuery - failed to execute query 'UPDATE tvshow SET c00='D...
2020-02-29 18:20:29.515 T:14300 DEBUG: Mysql rollback transaction
So the tvshow is found, kodi try to write in DB and then rollback the operation...
I try the command in the DB and the error is:
#1406 - Data too long for column 'c06' at row 1
So i think the problem is present for everyone that add TVSHOW
"Doctor who 2005"
In c06 there are 96529 characters .... with url with thumb and fanart !!!
c06='<thumb aspect=\"poster\" language=\"en\">https://artworks.thetvdb.com/banners/posters/78804-52.jpg</thumb><thumb aspect=\"poster\" language=\"en\">https://artworks.thetvdb.com/banners/posters/78804-13.jpg</thumb>...
Maybe there are "too many"
Can we set an option to read only "normal" information for tvshow to make it work with KODI ?