From f806ae40187ff5d853fff7cdd72709eab39bc9ac Mon Sep 17 00:00:00 2001 From: Shadowghost Date: Sun, 19 Apr 2026 10:27:47 +0200 Subject: Fix too many SQL variables error on large libraries --- Emby.Server.Implementations/Library/UserDataManager.cs | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'Emby.Server.Implementations/Library/UserDataManager.cs') diff --git a/Emby.Server.Implementations/Library/UserDataManager.cs b/Emby.Server.Implementations/Library/UserDataManager.cs index 9e138dbdaa..1281f1587f 100644 --- a/Emby.Server.Implementations/Library/UserDataManager.cs +++ b/Emby.Server.Implementations/Library/UserDataManager.cs @@ -219,7 +219,9 @@ namespace Emby.Server.Implementations.Library using var context = _repository.CreateDbContext(); var userDataArray = context.UserData .AsNoTracking() - .Where(e => allItemIds.Contains(e.ItemId) && allKeys.Contains(e.CustomDataKey) && e.UserId.Equals(user.Id)) + .Where(e => e.UserId.Equals(user.Id)) + .WhereOneOrMany(allItemIds, e => e.ItemId) + .WhereOneOrMany(allKeys, e => e.CustomDataKey) .ToArray(); var userDataByItem = userDataArray.GroupBy(e => e.ItemId).ToDictionary(g => g.Key, g => g.ToArray()); -- cgit v1.2.3