[bteamstephen]

So it was actually in the library?

Yes, it was already in the KODI Library, but not in the MySQL database. I removed it from KODI and rescanned it with the same result.

Here is what I am trying now:
1. I "Set Content" to "None" on my Movies source in KODI and performed a clean up, cleared thumbnails and cleared cache.
     - Now there are no entries in the MySQL database - "movie" table
     - However there are still entries in the "streamdetails" table. I wonder, is this normal?
     
2. I close KODI
3. Reopen KODI, change content back to "Movies" and let it rescan the entire library so I can save the log file - in case this helps...
      - The options I change when scanning are to toggle "Movies are in separate folders that match the movie title" and in Settings I turn off "Add keywords as tags" as it's a personal preference.


Results:
After everything was re-scanned in, I check my database in MySQL Workbench.
     - This time I was able to find the movie "Meet Cute (2022)" in the movie table. So I wrote down the idFile number so I could search the streamdetails table for a match.
          - I could not find the matching idFile number in the streamdetails table
     - I exported the movie table and streamdetails table to a .csv and discovered that each table only had a header and 1,000 lines of data in each. I have a total of 5,673 movies in my KODI Movie Library.
          - I have a feeling something is limiting the database to only 1,000 lines because that is too round of a number for it just be made up of errors.
          - This could also explain why I can't match up the idFile number between the tables
          - the actor table is also limited to 1,000 entries
          - Also noting that the files table does not have an entry for "Meet Cute (2022).mp4"
     - My log file has thousands of lines like this, where it says "does not exist - skipping scan.":
          

log file:
2024-06-17 12:30:55.987 T:25200 warning <general>: VIDEO::CVideoInfoScanner:rocess directory 'smb://192.168.4.100/Videos/Movies/White Men Can't Jump (1992)/' does not exist - skipping scan.

So it seems to me the issue is with the MySQL database - somehow limiting to 1,000 entries - and that is what I need to sort out to solve my original issue.
Does it make sense to open a new thread to discuss that in particular and hopefully find help with that first, then link this thread to it once I resolve it?
          - thankfully my WatchedList table only has 937 entries so far, but I fear once I hit 1,000 then it will not be able to track my watched movies any longer

[Karellen]

discovered that each table only had a header and 1,000 lines of data in each

Look at your first image, top of the image. You have the display set to "Limit to 1000 rows"

As for the streamdetails table. When you delete a movie, the streamdetails are also deleted. But if you browse through your video files through Videos>Files, the streamdetails are added again.

[bteamstephen]

Look at your first image, top of the image. You have the display set to "Limit to 1000 rows"

Oh my god... I feel so stupid. Thanks!

Now, all of a sudden my example movie "Meet Cute (2022)" is working.
     - I found the movie in the movie table and matched it with the streamdetails table, which looks good - strSubtitleLanguage = eng, and KODI shows the language on the details view

However, other movies are still not working. For example, "Wind River (2017)"
     - The streamdetails table does not show a subtitle entry
     - I am gathering that for iStreamType 0=video, 1=audio and 2=subtitle - this movie is only showing entries for 0 and 1


Here is the .nfo file for this movie: https://paste.kodi.tv/enapomofah.kodi

[Karellen]

Now, all of a sudden my example movie "Meet Cute (2022)" is working.
     - I found the movie in the movie table and matched it with the streamdetails table, which looks good - strSubtitleLanguage = eng, and KODI shows the language on the details view

Great. Does this movie have external subtitles or subtitles embedded in the video file?

- I am gathering that for iStreamType 0=video, 1=audio and 2=subtitle

Yes

However, other movies are still not working. For example, "Wind River (2017)"
     - The streamdetails table does not show a subtitle entry

Hmm, that was fixed for v21... https://github.com/xbmc/xbmc/pull/23835
Is your library an upgrade from a previous version, or was it built new for v21?
What is in the nfo file? I am thinking that if the nfo file does not have the subtitle nominated, then it won't be scanned by Kodi.
It's either...
a. Scan all streamdetails from nfo file. (No need to scan files as all info should be in nfo file), or
b. No nfo file, so Kodi scans folders and files to collate all the available streamdetails.

Also, you can expand the naming of the subtitle file so Kodi knows how to deal with it. Read my post here... https://forum.kodi.tv/showthread.php?tid...pid2861861

[bteamstephen]

Meet Cute (2022) has external subtitles, none embedded in the video file. Same with Wind River (2017).

I created the MySQL library on v20 of KODI. I am still running KODI Build 20.2 where the database version is myvideos121
...So it was built new for v20

The streamdetails portion of the .nfo file for Wind River (2017) reads:

Wind River (2017) :
<streamdetails>

            <video>

                <width>1920</width>

                <height>808</height>

                <aspect>2.40</aspect>

                <codec>h264</codec>

                <format>avc1</format>

                <durationinseconds>6407</durationinseconds>

                <bitrate>2 500 kb/s</bitrate>

                <container>.mp4</container>

                <scantype>Progressive</scantype>

                <framerate>23.976</framerate>

                <NumVideoBits>8</NumVideoBits>

            </video>

            <audio>

                <language>eng</language>

                <DefaultTrack>Yes</DefaultTrack>

                <codec>aac</codec>

                <channels>6</channels>

                <bitrate>224 kb/s</bitrate>

            </audio>

            <subtitle>

                <language>eng</language>

                <default>False</default>

                <forced>False</forced>

            </subtitle>

        </streamdetails>

Regarding your link to v21, it looks like this is saying that v20 does not read the external subtitle into the streamdetails (or it was broken), so this could be why I'm having the issue...
but this was fixed in v21? If so, I would need to upgrade to v21 for this to work properly?

If so, I am willing to upgrade to v21 in order to make this work... Is there a guide you could point me to that would help me update the MySQL database so I don't destroy my library in the process? (cause with me that's bound to happen haha)

[bteamstephen]

Ok, so I updated KODI to the latest v21 Omega, and fortunately the MySQL database updated itself.
     - I checked the database streamdetails table and it still did not have all of the subtitle entries for my external .srt's - I assumed it's because it simply updated the database and did not re-scan, so
     - Then I set the content of my Movies library to None, performed a library clean and then set it back to Movies in order to rescan the library

*After the rescan, all subtitles appear in the streamdetails table and working correctly in KODI - I can see the subtitle language displayed in the video info screen.

TLDR:
So the problem was that KODI v20 does not scan external subtitle details into the streamdetails table, but v21 has fixed this.
Update to v21 and update the database to the new version solved it all. Just be sure to re-scan the library after it has updated to the new version.

Thanks @Karallen and @Hitcher for all the help and indulging this somewhat small detail that most users might not even care about. I don't know how to mark this thread as "issue solved" or mark this as the solution.

[Karellen]

I assumed it's because it simply updated the database and did not re-scan,

That is correct.

*After the rescan, all subtitles appear in the streamdetails table and working correctly in KODI - I can see the subtitle language displayed in the video info screen.

That is great. Glad it is working.

Thanks @Karallen and @Hitcher for all the help and indulging this somewhat small detail that most users might not even care about. I don't know how to mark this thread as "issue solved" or mark this as the solution.

You are welcome.
To mark it solved, you edit the (your) first post in the thread, then set the title to solved from the drop down box. But don't worry, I'll do that now.

[Karellen]

Thread marked solved.