jellyfin · JeroenED · Apr 21, 2025 · Apr 21, 2025 · May 6, 2025 · Jun 2, 2025
diff --git a/jellyfin_kodi/objects/kodi/movies.py b/jellyfin_kodi/objects/kodi/movies.py
@@ -142,9 +142,12 @@ def migrations(self):
 
         # Will run every time Kodi starts, but will be fast enough on
         # subsequent runs to not be a meaningful delay
-        if version_id >= 131:
+        if 131 <= version_id < 134:
             changes = self.omega_migration()
 
+        if version_id >= 134:
+            changes = self.piers_migration()
+
         return changes
 
     def omega_migration(self):
@@ -163,3 +166,20 @@ def omega_migration(self):
 
         LOG.info("Omega database migration is complete")
         return changes
+
+    def piers_migration(self):
+        """
+        Adds a video version for all existing movies
+        """
+        LOG.info("Starting migration for Piers database changes")
+        # Tracks if this migration made any changes
+        changes = False
+        self.cursor.execute(QU.get_missing_versions)
+
+        # Sets all existing movies without a version to standard version
+        for entry in self.cursor.fetchall():
+            self.add_videoversion(entry[0], entry[1], "movie", 40400, 40400)
+            changes = True
+
+        LOG.info("Piers database migration is complete")
+        return changes
diff --git a/jellyfin_kodi/objects/kodi/queries.py b/jellyfin_kodi/objects/kodi/queries.py
@@ -409,12 +409,12 @@
 add_set_obj = ["{Title}", "{Overview}"]
 add_video_version = """
 INSERT INTO     videoversion(idFile, idMedia, media_type, itemType, idType)
-VALUES          (?, ?, ?, ?, ?)
+VALUES          (?, ?, ?, (SELECT itemType FROM videoversiontype WHERE id = ?), ?)
 """
 check_video_version = """
 SELECT COUNT(name) FROM sqlite_master WHERE type='table' AND name='videoversion'
 """
-add_video_version_obj = ["{FileId}", "{MovieId}", "movie", "0", 40400]
+add_video_version_obj = ["{FileId}", "{MovieId}", "movie", 40400, 40400]
 add_musicvideo = """
 INSERT INTO     musicvideo(idMVideo, idFile, c00, c04, c05, c06, c07, c08, c09, c10,
                 c11, c12, premiered)

diff --git a/release.yaml b/release.yaml
@@ -23,7 +23,7 @@ changelog: |-
 dependencies:
   py3:
     - addon: 'xbmc.python'
-      version: '3.0.0'
+      version: '3.0.1'
     - addon: 'script.module.requests'
       version: '2.22.0+matrix.1'
     - addon: 'script.module.dateutil'