SQL Backend has three "NULL" rows for TV Series and I can't figure out how to fix

SQL Backend has three "NULL" rows for TV Series and I can't figure out how to fix - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: SQL Backend has three "NULL" rows for TV Series and I can't figure out how to fix (/showthread.php?tid=355042)

SQL Backend has three "NULL" rows for TV Series and I can't figure out how to fix - FreeSoftwareServers - 2020-06-08

I recently rebuilt my Kodi setup and created a new fresh database. Everything seemed fine upon import, but I recently noticed that "The Simpsons" was missing from my list. I looked into the database and there is a row exactly where "Simpsons" should be, which has all values "NULL". I tried deleting this row, and when I re-start Kodi, it shows "Updating Library" and "Simpsons" at the top, but the show never appears in the GUI.

Any suggestions or a more thorough SQL Statement I could try to perhaps delete all artifcats of this "NULL" entry?

Specs:
MariaDB 10
Kodi 16 - Jarvis

I was going to post an image, but I guess that's to much for this support forum to handle... but you get the idea. Let me know if you require anything else.

PS: I am using PHPMyAdmin to do the queries/deleting etc, not sure it matters, but thought I'd share.

RE: SQL Backend has three "NULL" rows for TV Series and I can't figure out how to fix - Karellen - 2020-06-08

(2020-06-08, 01:29)FreeSoftwareServers Wrote: Everything seemed fine upon import,

How did you import? Library Update? Scraper, nfo files or single file export?

(2020-06-08, 01:29)FreeSoftwareServers Wrote: I was going to post an image, but I guess that's to much for this support forum to handle.

If the image is on your computer, use button 19.
If the image has already been uploaded to a public image hosting site, right click the image and select Copy image location then use button 14 and paste the link

RE: SQL Backend has three "NULL" rows for TV Series and I can't figure out how to fix - FreeSoftwareServers - 2020-06-08

(2020-06-08, 01:34)Karellen Wrote:
(2020-06-08, 01:29)FreeSoftwareServers Wrote: Everything seemed fine upon import,
How did you import? Library Update? Scraper, nfo files or single file export?

(2020-06-08, 01:29)FreeSoftwareServers Wrote: I was going to post an image, but I guess that's to much for this support forum to handle.
If the image is on your computer, use button 19.
If the image has already been uploaded to a public image hosting site, right click the image and select Copy image location then use button 14 and paste the link

Thanks, I was using button 14 Tongue

. So here is the image:

I imported just via "regular" methods, everything default, no NFO files in directory using "TheTVDB" as the scraper.

I just was reading about using an NFO File. I'm not sure if I'm doing it correctly, but that didn't work, but seems like a good fix for me to learn with future shows that might have problems. I created a file called "The Simpsons.nfo" under "The Simpsons" directory which has only subfolders of seasons in it. And inside that file I have simply "https://thetvdb.com/series/the-simpsons".

No luck on restart tho. Thanks again Smile

RE: SQL Backend has three "NULL" rows for TV Series and I can't figure out how to fix - FreeSoftwareServers - 2020-06-08

(2020-06-08, 01:41)FreeSoftwareServers Wrote:
(2020-06-08, 01:34)Karellen Wrote:
(2020-06-08, 01:29)FreeSoftwareServers Wrote: Everything seemed fine upon import,
How did you import? Library Update? Scraper, nfo files or single file export?

(2020-06-08, 01:29)FreeSoftwareServers Wrote: I was going to post an image, but I guess that's to much for this support forum to handle.
If the image is on your computer, use button 19.
If the image has already been uploaded to a public image hosting site, right click the image and select Copy image location then use button 14 and paste the link

Thanks, I was using button 14 . So here is the image:

I imported just via "regular" methods, everything default, no NFO files in directory using "TheTVDB" as the scraper.

I just was reading about using an NFO File. I'm not sure if I'm doing it correctly, but that didn't work, but seems like a good fix for me to learn with future shows that might have problems. I created a file called "The Simpsons.nfo" under "The Simpsons" directory which has only subfolders of seasons in it. And inside that file I have simply "https://thetvdb.com/series/the-simpsons".

No luck on restart tho. Thanks again

I wanted to add, I have and am still able to add new shows, and 99% of my library imported upon first start of kodi, just these three shows (Doctor Who 2005, The Simpsons & I'm not sure the third yet).

RE: SQL Backend has three "NULL" rows for TV Series and I can't figure out how to fix - Karellen - 2020-06-08

(2020-06-08, 01:41)FreeSoftwareServers Wrote: created a file called "The Simpsons.nfo"

Nope. It is called tvshow.nfo. That is the actual name, don't replace it with the name of the show. Placing the link in there is correct for a Parsing NFO file.

Can you provide a Debug Log of you scraping The Simpsons, and I will try to spot what the issue is.

RE: SQL Backend has three "NULL" rows for TV Series and I can't figure out how to fix - FreeSoftwareServers - 2020-06-08

(2020-06-08, 01:52)Karellen Wrote:
(2020-06-08, 01:41)FreeSoftwareServers Wrote: created a file called "The Simpsons.nfo"
Nope. It is called tvshow.nfo. That is the actual name, don't replace it with the name of the show. Placing the link in there is correct for a Parsing NFO file.

Can you provide a Debug Log of you scraping The Simpsons, and I will try to spot what the issue is.

I'm not sure if this is what you want, but it's definitley got related errors. Just FYI, I use Kodi on Windows for the GUI and using "Portable" mode. This is my "kodi.log" under "portable_data".

kodi.log

RE: SQL Backend has three "NULL" rows for TV Series and I can't figure out how to fix - Karellen - 2020-06-08

Thanks. Plenty of errors but not enough info as you did not enable Debug Mode in Settings>System Settings>Logging. Try again

RE: SQL Backend has three "NULL" rows for TV Series and I can't figure out how to fix - FreeSoftwareServers - 2020-06-08

(2020-06-08, 02:18)Karellen Wrote: Thanks. Plenty of errors but not enough info as you did not enable Debug Mode in Settings>System Settings>Logging. Try again

Thank you for your guidance.... You mean I should, turn on debugging and look at the logs (Just kidding, but really, that's all it took). I've never used the debugging in Kodi before, only just looked at logs, but they don't show any relevant information without debugging.

The fix is related to the following:

TLDR:

Error --> `Undefined MySQL error: Code (1406)` & Fix --> `ALTER TABLE tvshow MODIFY COLUMN c06 mediumtext DEFAULT NULL NULL;`

MariDB-Jira Ticket

"The proper fix, of course, is for KODI to create the table with that data type for large columns."

I am using an outdated version of Kodi, so I can't gripe on that front, but the thread it points to uses a newer Kodi so the issue is still prevalent (For instance I use MyVideos99, not 116, but the fix still worked!)

RE: SQL Backend has three "NULL" rows for TV Series and I can't figure out how to fix - Karellen - 2020-06-08

Yes, the debug mode adds additional logging. Further you can enable various Component Logging items for even more detail, but only do that when asked if providing the log here, otherwise the log becomes difficult to read when looking for simple issues.

(2020-06-08, 02:52)FreeSoftwareServers Wrote: Error --> `Undefined MySQL error: Code (1406)` & Fix --> `ALTER TABLE tvshow MODIFY COLUMN c06 mediumtext DEFAULT NULL NULL;`
MariDB-Jira Ticket

I have it listed as a common problem and we have that ticketed as well. See item 1i here... https://forum.kodi.tv/showthread.php?tid=336969

(2020-06-08, 02:52)FreeSoftwareServers Wrote: "The proper fix, of course, is for KODI to create the table with that data type for large columns."

Yes, just needs a volunteer to step forward and undertake the fix. With so many areas in Kodi that are being worked on, as well as new features being added, this is one of those bugs that can be fixed by a user, so there is no urgency until somone happens to be working around the same area.

I thought there was another problem in your log also, but if you were able to scan The Simpsons, then all is ok.

RE: SQL Backend has three "NULL" rows for TV Series and I can't figure out how to fix - kindrudekid - 2021-03-23

(2020-06-08, 04:11)Karellen Wrote: Yes, the debug mode adds additional logging. Further you can enable various Component Logging items for even more detail, but only do that when asked if providing the log here, otherwise the log becomes difficult to read when looking for simple issues.

(2020-06-08, 02:52)FreeSoftwareServers Wrote: Error --> `Undefined MySQL error: Code (1406)` & Fix --> `ALTER TABLE tvshow MODIFY COLUMN c06 mediumtext DEFAULT NULL NULL;`
MariDB-Jira Ticket
I have it listed as a common problem and we have that ticketed as well. See item 1i here... https://forum.kodi.tv/showthread.php?tid=336969

(2020-06-08, 02:52)FreeSoftwareServers Wrote: "The proper fix, of course, is for KODI to create the table with that data type for large columns."
Yes, just needs a volunteer to step forward and undertake the fix. With so many areas in Kodi that are being worked on, as well as new features being added, this is one of those bugs that can be fixed by a user, so there is no urgency until somone happens to be working around the same area.

I thought there was another problem in your log also, but if you were able to scan The Simpsons, then all is ok.

This ever got fixed? Having same on simpsons with latest everything

RE: SQL Backend has three "NULL" rows for TV Series and I can't figure out how to fix - Karellen - 2021-03-23

(2021-03-23, 02:42)kindrudekid Wrote: This ever got fixed? Having same on simpsons with latest everything

You using MySQL or MariaDB? If you are, the issue is not fixed. You need to make a local fix.. https://github.com/xbmc/xbmc/issues/15768
or
change to the new TMDB TV Show scraper which limits the artwork

RE: SQL Backend has three "NULL" rows for TV Series and I can't figure out how to fix - kindrudekid - 2021-03-24

(2021-03-23, 03:08)Karellen Wrote:
(2021-03-23, 02:42)kindrudekid Wrote: This ever got fixed? Having same on simpsons with latest everything
You using MySQL or MariaDB? If you are, the issue is not fixed. You need to make a local fix.. https://github.com/xbmc/xbmc/issues/15768
or
change to the new TMDB TV Show scraper which limits the artwork

That worked thanks!