Kodi Community Forum
DB issue (I think) stopping new files from being recognised. - 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: DB issue (I think) stopping new files from being recognised. (/showthread.php?tid=360879)

DB issue (I think) stopping new files from being recognised. - hobleyd - 2021-02-27

I had a an issue recently where Kodi lost the content type for my TV Shows source. I found this by trying to add new episodes, and having them not be recognised. I fixed that and tried to rescan, but they are still not being recognised.

So I have had a play around with the database and I was wondering what the linkages should be for this to work. Let me give you an example:

When I try to update the library, I get this in my kodi.log file (I changed the names for privacy reasons, but it does exist and match):
Code:

2021-02-27 12:54:58.930 T:3919569120   DEBUG: VideoInfoScanner: Found episode match nfs://syn01/volume1/xbmc/Television/A TV Show/Season 3/03x01 - Episode1.mkv (s3e1) [[0]*([0-9]+)x[0]*([0-9]+)[^\\/]*]
2021-02-27 12:54:58.930 T:3919569120   DEBUG: VideoInfoScanner: Found episode match nfs://syn01/volume1/xbmc/Television/A TV Show/Season 3/03x02 - Episode2.mkv (s3e2) [[0]*([0-9]+)x[0]*([0-9]+)[^\\/]*]
2021-02-27 12:54:58.930 T:3919569120   DEBUG: VideoInfoScanner: Found episode match nfs://syn01/volume1/xbmc/Television/A TV Show/Season 3/03x03 - Episode3.mkv (s3e3) [[0]*([0-9]+)x[0]*([0-9]+)[^\\/]*]
2021-02-27 12:54:58.931 T:3919569120   DEBUG: VideoInfoScanner: Found episode match nfs://syn01/volume1/xbmc/Television/A TV Show/Season 3/03x04 - Episode4.mkv (s3e4) [[0]*([0-9]+)x[0]*([0-9]+)[^\\/]*]

so it can see the files; but they do not appear in anywhere other than the Files section; the normal TV Shows section insists I have nothing from Season 3.

The show exists:
Code:

MariaDB [xbmc_video116]> select idShow, c00 from tvshow where c00 like '%A TV Show%';
+--------+------------+
| idShow | c00        |
+--------+------------+
|    787 | A TV Show |
+--------+------------+
1 row in set (0.001 sec)

If I check my path table:
Code:

MariaDB [xbmc_video116]> select * from path where strPath like '%A TV Show%';
+--------+----------------------------------------------------------+------------+------------+----------------------------------+---------------+----------------+-------------+----------+---------+---------------------+--------------+
| idPath | strPath                                                  | strContent | strScraper | strHash                          | scanRecursive | useFolderNames | strSettings | noUpdate | exclude | dateAdded           | idParentPath |
+--------+----------------------------------------------------------+------------+------------+----------------------------------+---------------+----------------+-------------+----------+---------+---------------------+--------------+
|   2145 | nfs://syn01/volume1/xbmc/Television/A TV Show/Season 3/ | NULL       | NULL       | 3e41e034e26adc9dde8bf26abe207fdd |          NULL |           NULL | NULL        |     NULL |    NULL | NULL                |         1891 |
|   1890 | nfs://syn01/volume1/xbmc/Television/A TV Show/Season 1/ | NULL       | NULL       | 4241dbdc5828666d50135df2f6d30c07 |          NULL |           NULL | NULL        |     NULL |    NULL | NULL                |         1891 |
|   1891 | nfs://syn01/volume1/xbmc/Television/A TV Show/          | NULL       | NULL       | bba6ce5318358830dc65010d4d1d8cbe |          NULL |           NULL | NULL        |     NULL |    NULL | 2019-08-05 03:32:03 |          566 |
|   1907 | nfs://syn01/volume1/xbmc/Television/A TV Show/Season 2/ | NULL       | NULL       | ae0f43d0c8e06497b4b8e502a4b5bbb4 |          NULL |           NULL | NULL        |     NULL |    NULL | NULL                |         1891 |
+--------+----------------------------------------------------------+------------+------------+----------------------------------+---------------+----------------+-------------+----------+---------+---------------------+--------------+

However, the episodes table shows the problem:
Code:

MariaDB [xbmc_video116]> select idEpisode, c18 from episode where idShow = 787 and c18 like '%Season 3%';
Empty set (0.001 sec)

How can I get it to update the episodes table please?

Cheers,
David

RE: DB issue (I think) stopping new files from being recognised. - Karellen - 2021-02-27

Need the full Debug Log which captures you scraping the tv show.

RE: DB issue (I think) stopping new files from being recognised. - hobleyd - 2021-02-28

(2021-02-27, 10:23)Karellen Wrote: Need the full Debug Log which captures you scraping the tv show.

Thanks. I have looked further and interestingly, for some reason a whole bunch of TV shows have been parented to a non-existing show, but with their actual directory. Any shows which are impacted, I can simply remove manually and re-add and it then scans to the library keeping the watched status of the individual episodes. So solved.

RE: DB issue (I think) stopping new files from being recognised. - Karellen - 2021-02-28

(2021-02-28, 02:04)hobleyd Wrote: for some reason a whole bunch of TV shows have been parented to a non-existing show
Ok, seen that before many times. A corrupted database due to non-compatible nfo files.

Are you using nfo files, or at some stage did you add these tv shows into Kodi via nfo files from a 3rd party media manager?

RE: DB issue (I think) stopping new files from being recognised. - hobleyd - 2021-02-28

(2021-02-28, 02:13)Karellen Wrote:
(2021-02-28, 02:04)hobleyd Wrote: for some reason a whole bunch of TV shows have been parented to a non-existing show
Are you using nfo files, or at some stage did you add these tv shows into Kodi via nfo files from a 3rd party media manager?
No, I have never used nfo files for TV Shows; I use them for a subset of my Movies though if that might have affected things somehow? I have only managed the DB via standard Kodi (I don't use addons other than the screensaver).

RE: DB issue (I think) stopping new files from being recognised. - Karellen - 2021-02-28

(2021-02-28, 03:42)hobleyd Wrote: No, I have never used nfo files for TV Shows; I use them for a subset of my Movies though if that might have affected things somehow?
No, movies won't affect tv shows.

Can you delete that tv show from your library, and rescrape it, capturing it in a Debug Log. Ensure debug mode is enabled otherwise it is worthless.

RE: DB issue (I think) stopping new files from being recognised. - hobleyd - 2021-03-02

(2021-02-28, 04:08)Karellen Wrote:
(2021-02-28, 03:42)hobleyd Wrote: No, I have never used nfo files for TV Shows; I use them for a subset of my Movies though if that might have affected things somehow?
No, movies won't affect tv shows.

Can you delete that tv show from your library, and rescrape it, capturing it in a Debug Log. Ensure debug mode is enabled otherwise it is worthless.
It wouldn't be helpful any more, sorry - I have been cleaning the DB out by hand. It has taken a while to get my head around it, but I am almost complete now. Thanks for your help, though.