[dRiiik]

Hello everybody,

I don't really where I have to put this question, but I see here most valuable people

So... I have an issue about re scraping a tv show I already have for awhile, I've just deleted the old episode files and replaced it with the new ones in UHD.

But, when I launch a scrape on the folder, it finds the TV show but it's unable to add information and then the TV isn't recognized in Kodi.

I do the scrape from the folder in the sources, and I noticed that this folder, even if it has no information, is marked as "watched" and I can't change this status (I have made a shortcut on my keyboard to switch this status "watched/unwatched" quickly.

I tried to remove/erase the folder of this TV show from the source, update the library in Kodi... and when I recreate a folder with the name of the TV Show, the problem remains...

I think the problem comes from the database issue, but I don't know how to solve it...


For information, for new TV show, the scrape works really fine, and I've also seen that that the clearlogo, clearart and others are working well again too.

I'm on KODI 19, with the MOD from kodinerds, last version 3.0.7+matrix 10.

If you have a little idea, I will be very happy.

Thank you in advance.

Ok, so. I will answer to myself

I  finally found what was the problem...

After activating the debug mode, and check the kodi.log with LogExpert, I managed to this :

ERROR <general>: SQL: [MyVideos119] Undefined MySQL error: Code (1406)
                            Query: UPDATE tvshow SET c00='Game of Thrones',c01='Il y a très longtemps, blabla...

Looking for this ERROR <general>: SQL: [MyVideos119] Undefined MySQL error: Code (1406) in Google, I found this : Fields too small in MySQL Database (Solution included) https://github.com/xbmc/xbmc/issues/15768

"Fields too small in MySQL Database (Solution included)"

Series like "Game of Thrones" are well documented in The Movie Database and users have provided a huge amount of posters, fan art, etc.
Because of this, the amount of data returned by the TMDb API is quite big. A huge part of the response will be stored in the field tvshow.c06 - the type of this field is TEXT.

According to the MySQL Documentation, the maximum length of data in a field of type TEXT is 2^16 ( = 65536 Bytes). This seems to be too short for some TV Series.
After changing the type of the field to LONGTEXT everything works fine.
Maybe it is a good idea to check if other fields in other tables may have the same problem.


So, I changed the type of the c06 column to LONGTEXT as explained...



and then... after that, everything works finally fine AGAIN !

Hope this could help someone else.