[devkid]

Hi guys,

I know scraper problems are very popular and usually a problem with the end user. I invested several hours messing around with testing this and that and I still fail to understand it.

The problem:
I am using a MySQL DB and scraping a TV show (The Walking Dead) fails. Every episode is discarded with a log message like this:

2019-12-01 15:24:10.029 T:140017782384384 ERROR: VideoInfoScanner: Asked to lookup episode smb://ben/MASS2/Video/TV2/The Walking Dead/Season 4/The Walking Dead - S04E04 - Im Zweifel.mkv online, but we have no episode guide. Check your tvshow.nfo and make sure the <episodeguide> tag is in place.

All other TV shows that I have seem to work fine. I really could not figure out what is so special about TWD.

The strange part: When I disable the MySQL DB and just use the regular local DB then the scraping works fine. I really could reproduce it several times back and forth: scraping of TWD works with local DB but fails with MySQL DB.

Full debug log of MySQL case:
http://ix.io/23id

This is the local DB working version:
https://privatebin.net/?14a7c68afe7030fc...9MdZa97UXW

Any ideas please?

[Klojum]

2019-12-01 15:23:37.497 T:140018466293504 NOTICE: MYSQL: Connected to version 10.1.38-MariaDB-1~bionic
2019-12-01 15:23:37.514 T:140018466293504 ERROR: Unable to open database: MyVideos116 [1049](Unknown database 'myvideos116')

Apparently your MariaDB database is not accessible, error 1049 suggests the database is not present, and may not have not been created properly. Doublecheck with a MySQL/MariaDB tool what is available on your database server.

Perhaps there is a problem with the database user ('xbmc') that has insufficient rights? BTW, a username like 'xbmc' is a bit outdated now.

[r3d007]

2019-12-01 15:23:37.497 T:140018466293504 NOTICE: MYSQL: Connected to version 10.1.38-MariaDB-1~bionic
2019-12-01 15:23:37.514 T:140018466293504 ERROR: Unable to open database: MyVideos116 [1049](Unknown database 'myvideos116')

Apparently your MariaDB database is not accessible, error 1049 suggests the database is not present, and may not have not been created properly. Doublecheck with a MySQL/MariaDB tool what is available on your database server.

Perhaps there is a problem with the database user ('xbmc') that has insufficient rights? BTW, a username like 'xbmc' is a bit outdated now.

I have the exact same problem with The Simpsons. See here: 349708 (thread)
Don't think it is a problem with the rights. He wrote that other TvShows are scaped fine and that only this one TvShow has the Problem. 

BTW: For me it is the excat same. When scaping to a local database everything works fine. When trying to scrap to a MariaDB The Simpsons won't work.

[Klojum]

I have the exact same problem with The Simpsons.

No you don't.
See your thread.

[r3d007]

I have the exact same problem with The Simpsons.

No you don't.
See your thread. 

You are right! 
Thank you!

[devkid]

I have the exact same problem with The Simpsons.

No you don't.
See your thread.  

Well, too be fair: he had the exact same problem

It turned out that:

SQL: [MyVideos116] Undefined MySQL error: Code (1406)

Means:

Error Code: 1406. Data too long for column - MySQL

So I could fix my problem also using that method in the thread you linked Thanks!

[DarrenHill]

This may also help - https://github.com/xbmc/xbmc/issues/15768