Since Kodi video DB version 134 video versions are silently lost #1004
Description
Summary
All videos added to a Kodi instance with DB version >= 134 are invisible, and DB reset results in empty movie list because videoversion.itemType value 0 is now reserved, and previous values are shifted up by 1 (old value 0 is now 1, old value 1 is now 2).
See migration: https://github.com/xbmc/xbmc/blob/8fca3140aad3828a8381b022f1a68c5884472fe7/xbmc/video/VideoDatabase.cpp#L6791
Should probably really set videoversion.itemType based on a query to the videoversiontype table for the corresponding default type id (40400). Fetching the itemType from the DB will work for all versions, and any future updates to internal mappings. Even if one day the default type id gets changed or deleted, at least then we'll throw an error and be able to track down the issue easily, rather than silent data corruption as here, which took me an hour or two to work out.
I don't write Python unfortunately, or I'd look at implementing the above.
Steps to Reproduce
- Upgrade Kodi to recent build with MyVideos DB version >= 134
- Add any movie from Jellyfin
- Movie does not appear in movie view
Operating System
No response
Jellyfin Server Version
No response
Kodi Version
No response
Addon Mode
Direct-path mode ('native')
Logs
No relevant logs generated.
Server Logs
No response
Additional Information
No response