RPi OSMC database seems out of sync?

Help and Support Raspberry Pi
1

I have just moved my library (Movies and TV Shows) to a new RPi4B with a 2TB SSD for the content. The issue I want to discuss here may be new and/or may have existed before on the previous RPi3B???

Using the SQL database and the MovieView table,

  • I have queried for the count of entry TITLE. I get 666.
  • If I get the count where the SET TITLE is NOT NULL then I get 555.
  • If I get the count where the SET TITLE is NULL then I get 151.
  • If I get the count where the length of the SET TITLE is 0, I get 0.

Which would imply that I have 151 movies which do not belong to a SET. I printed out the list of the 151 TITLEs and checked each using the “MANAGE” and “MANAGE MOVIE SET” functions.. From that process I found that they all belong to an appropriate/correct SET. Which seem to indicate the these functions are not using the MovieView table and/or that table is out-of-sync.

Thoughts, comments or suggestions? Thanks…RDK

2

Honestly, my first suggestion if all your movies are in sets you believe are right to stop worrying about it. The Kodi database is not a straightforward thing (multiple tables and views can be involved in one simple looking thing), and unless you are bored and really want to dig in deep, if what you have is working, just let it be.

3 Likes