Unable to add The Simpsons to library

Help and Support Vero 4K / Vero 4K +
1

Not sure where it is going wrong but I did a fresh rescan of my libary and all shows are imported Okay except The Simpsons.
It shows as an empty folder

Running on Vero 4K+ latest version.
Shared MySQL database
Using TheTVDB as provider

In my KODI log I see the following after a Refresh info, each time I delete the empty folder again and do a rescan or doe Refresh Info from Internet it is the same result.

https://paste.osmc.tv/gojefuvere

2

It seems to be related to this
https://forums.thetvdb.com/viewtopic.php?f=18&t=62639&p=171142&hilit=Simpsons#p171142

current mySQL Mode is

+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value                                                                                                                                     |
+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+
| sql_mode      | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+

How do I enable code formatting on this forum? Found it, same as Github

3

I think your problem is this.

I changed mine with HeidiSQL fairly easily to fix the same issue with Doctor Who.

1 Like
4

This looks like its related to the size of the field:

020-04-13 18:15:54.512 T:4071305216   ERROR: SQL: [mastervideo116] Undefined MySQL error: Code (1406)
                                            Query: UPDATE tvshow SET c00='The Simpsons',c01='Set in Springfield, the average American town, the show focuses on the antics and everyday adventures of the Simpson family; Homer, Marge, Bart, Lisa and Maggie, as well as a virtual cast of thousands. Since the beginning, the series has been a pop culture icon, attracting hundreds of celebrities to guest star. The show has also made name for itself in its fearless satirical take on politics, media and American life in general.',c02='',c04='18108',c05='1987-04-19',c06='<thumb aspect=\"poster\"

There is a Kodi issue open for this:

@darwindesign just beat me to it :slight_smile:

2 Likes
5

Changing SQL mode to

+---------------+------------------------+
| Variable_name | Value                  |
+---------------+------------------------+
| sql_mode      | NO_ENGINE_SUBSTITUTION |
+---------------+------------------------+

also works after the import I can switch back, it was only when doing a refresh that it is giving errors.

Thanks to the both of you.