Too many fanart images for scrapers: Data too long for MySQL tables (error 1406)
#16
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?
Quote: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.
Reply
#17
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
My Signature
Links to : Official:Forum rules (wiki) | Official:Forum rules/Banned add-ons (wiki) | Debug Log (wiki)
Links to : HOW-TO:Create Music Library (wiki) | HOW-TO:Create_Video_Library (wiki) || Artwork (wiki) | Basic controls (wiki) | Import-export library (wiki) | Movie sets (wiki) | Movie universe (wiki) | NFO files (wiki) | Quick start guide (wiki)
Reply
#18
(2020-06-23, 20:55)Karellen Wrote: 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
Reply
#19
I see the issue. Did you run those same instructions on the movie table?
My Signature
Links to : Official:Forum rules (wiki) | Official:Forum rules/Banned add-ons (wiki) | Debug Log (wiki)
Links to : HOW-TO:Create Music Library (wiki) | HOW-TO:Create_Video_Library (wiki) || Artwork (wiki) | Basic controls (wiki) | Import-export library (wiki) | Movie sets (wiki) | Movie universe (wiki) | NFO files (wiki) | Quick start guide (wiki)
Reply
#20
(2020-06-23, 23:15)Karellen Wrote: I see the issue. Did you run those same instructions on the movie table?

Yep.  This is what I ran:
Quote:ALTER TABLE MyVideos116.movie MODIFY COLUMN c08 mediumtext DEFAULT NULL NULL;
...and it seems to have fixed the issue.
Reply



Logout Mark Read Team Forum Stats Members Help
Too many fanart images for scrapers: Data too long for MySQL tables (error 1406)0
This forum uses Lukasz Tkacz MyBB addons.