[Skirge01]

I was really hoping this would finally fix my scraping issues for a handful of movies, but it hasn't worked.  I even tried the 'longtext' change and I'm still getting an 'error 1406' in the logs.  Is there a way to verify the db change actually did what it was supposed to?

EDIT:  In thinking about what this SQL change is actually doing, this appears to only be "fixing" the 1406 error for TV Shows.  Since I'm having the issue with movies and the log appears to show a VERY large c08 entry for posters, should I actually be making the following change?

ALTER TABLE MyVideos116.movie MODIFY COLUMN c08 mediumtext DEFAULT NULL NULL;

While I was looking at the DB in DBeaver, I also noticed there's a myvideos107.  Is there another table in there I need to be concerned about?

EDIT #2:  Changed the column from c06 to c08.

[Karellen]

Provide a Debug Log and we can confirm this is the issue.

There is a github report on this as well... https://github.com/xbmc/xbmc/issues/15768

The fix uses TV Shows as the example. You would also need to perform it on the movies table.

myvideos107 is from a previous version of Kodi and can be deleted. These are the current versions... https://kodi.wiki/view/Databases#Database_Versions

[Skirge01]

Provide a Debug Log and we can confirm this is the issue.

There is a github report on this as well... https://github.com/xbmc/xbmc/issues/15768

The fix uses TV Shows as the example. You would also need to perform it on the movies table.

myvideos107 is from a previous version of Kodi and can be deleted. These are the current versions... https://kodi.wiki/view/Databases#Database_Versions

The github report is where I started.  I can't put the entire log file onto pastebin (it's 58MB), but I put what should be more than enough for you to verify:  https://pastebin.com/1nAB8cL1

[Karellen]

I see the issue. Did you run those same instructions on the movie table?

[Skirge01]

I see the issue. Did you run those same instructions on the movie table?

Yep.  This is what I ran:

ALTER TABLE MyVideos116.movie MODIFY COLUMN c08 mediumtext DEFAULT NULL NULL;

...and it seems to have fixed the issue.