aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJPVenson <github@jpb.email>2024-11-11 06:14:08 +0000
committerJPVenson <github@jpb.email>2024-11-11 06:14:08 +0000
commitfb48d0790f4b9be762443d239faaf77057713a51 (patch)
treea31e31e9fe158cb92ceb1a3fa21649ba07d72b0b
parent8dbbb3e243a417464e620721bdb6c567c02ee4f8 (diff)
Fixed Library DB lookup
-rw-r--r--Jellyfin.Server.Implementations/Item/BaseItemRepository.cs7
-rw-r--r--Jellyfin.Server/Migrations/Routines/MigrateLibraryDb.cs2
2 files changed, 7 insertions, 2 deletions
diff --git a/Jellyfin.Server.Implementations/Item/BaseItemRepository.cs b/Jellyfin.Server.Implementations/Item/BaseItemRepository.cs
index d862ecf6c..619863fd5 100644
--- a/Jellyfin.Server.Implementations/Item/BaseItemRepository.cs
+++ b/Jellyfin.Server.Implementations/Item/BaseItemRepository.cs
@@ -261,7 +261,12 @@ public sealed class BaseItemRepository(
PrepareFilterQuery(filter);
using var context = dbProvider.CreateDbContext();
- var dbQuery = TranslateQuery(context.BaseItems.AsNoTracking(), context, filter);
+ IQueryable<BaseItemEntity> dbQuery = context.BaseItems.AsNoTracking()
+ .Include(e => e.TrailerTypes)
+ .Include(e => e.Provider)
+ .Include(e => e.Images)
+ .Include(e => e.LockedFields);
+ dbQuery = TranslateQuery(dbQuery, context, filter);
if (filter.Limit.HasValue || filter.StartIndex.HasValue)
{
var offset = filter.StartIndex ?? 0;
diff --git a/Jellyfin.Server/Migrations/Routines/MigrateLibraryDb.cs b/Jellyfin.Server/Migrations/Routines/MigrateLibraryDb.cs
index 5cb89f9ac..571ac95eb 100644
--- a/Jellyfin.Server/Migrations/Routines/MigrateLibraryDb.cs
+++ b/Jellyfin.Server/Migrations/Routines/MigrateLibraryDb.cs
@@ -292,7 +292,7 @@ public class MigrateLibraryDb : IMigrationRoutine
private (UserData? Data, string? LegacyUserDataKey) GetUserData(ImmutableArray<User> users, SqliteDataReader dto)
{
var indexOfUser = dto.GetInt32(1);
- var user = users.ElementAtOrDefault(indexOfUser + 1);
+ var user = users.ElementAtOrDefault(indexOfUser - 1);
if (user is null)
{