starred/jellyfin
1
0
Fork 0
mirror of https://github.com/jellyfin/jellyfin.git synced 2026-05-04 18:09:12 +03:00
Code Issues 822 Packages Projects Releases 10 Wiki Activity

Can't open user preferences for admin user #3116

New Issue
Closed
opened 2026-02-06 22:50:21 +03:00 by OVERLORD · 5 comments
OVERLORD commented 2026-02-06 22:50:21 +03:00
Owner
Copy Link

Originally created by @DomiStyle on GitHub (Jun 27, 2021).

Describe the bug
Trying to open any of the user settings (Display, Home, Playback, Subtitles) returns a 500 from the server and ends up causing infinite loading screens in the UI. This also affects the login screen.

System (please complete the following information):

  • OS: Ubuntu 20.04
  • Virtualization: Docker
  • Clients: Browser
  • Browser: Firefox 89
  • Jellyfin Version: 10.7.6
  • Playback: -
  • Installed Plugins: TheTVDB, Trakt
  • Reverse Proxy: nginx
  • Base URL: none
  • Networking: Bridge/NAT
  • Storage: local

To Reproduce

  • Login with admin user
  • Login screen gets stuck because request to /DisplayPreferences/usersettings fails

Expected behavior
Login user

Server Logs

[10:28:11] [ERR] [86] Microsoft.EntityFrameworkCore.Query: An exception occurred while iterating over the results of a query for context type 'Jellyfin.Server.Implementations.JellyfinDb'.
System.InvalidOperationException: The data is NULL at ordinal 5. This method can't be called on NULL values. Check using IsDBNull before calling.
   at Microsoft.Data.Sqlite.SqliteValueReader.GetString(Int32 ordinal)
   at lambda_method640(Closure , QueryContext , DbDataReader , ResultContext , SingleQueryResultCoordinator )
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
System.InvalidOperationException: The data is NULL at ordinal 5. This method can't be called on NULL values. Check using IsDBNull before calling.
   at Microsoft.Data.Sqlite.SqliteValueReader.GetString(Int32 ordinal)
   at lambda_method640(Closure , QueryContext , DbDataReader , ResultContext , SingleQueryResultCoordinator )
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
[10:28:11] [ERR] [86] Jellyfin.Server.Middleware.ExceptionMiddleware: Error processing request. URL GET /DisplayPreferences/usersettings.
System.InvalidOperationException: The data is NULL at ordinal 5. This method can't be called on NULL values. Check using IsDBNull before calling.
   at Microsoft.Data.Sqlite.SqliteValueReader.GetString(Int32 ordinal)
   at lambda_method640(Closure , QueryContext , DbDataReader , ResultContext , SingleQueryResultCoordinator )
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
   at System.Linq.Enumerable.ToDictionary[TSource,TKey,TElement](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)
   at Jellyfin.Api.Controllers.DisplayPreferencesController.GetDisplayPreferences(String displayPreferencesId, Guid userId, String client)
   at lambda_method499(Closure , Object , Object[] )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextResourceFilter>g__Awaited|24_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFilterPipelineAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
   at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
   at Jellyfin.Server.Middleware.ServerStartupMessageMiddleware.Invoke(HttpContext httpContext, IServerApplicationHost serverApplicationHost, ILocalizationManager localizationManager)
   at Jellyfin.Server.Middleware.WebSocketHandlerMiddleware.Invoke(HttpContext httpContext, IWebSocketManager webSocketManager)
   at Jellyfin.Server.Middleware.IpBasedAccessValidationMiddleware.Invoke(HttpContext httpContext, INetworkManager networkManager)
   at Jellyfin.Server.Middleware.LanFilteringMiddleware.Invoke(HttpContext httpContext, INetworkManager networkManager, IServerConfigurationManager serverConfigurationManager)
   at Microsoft.AspNetCore.Authorization.Policy.AuthorizationMiddlewareResultHandler.HandleAsync(RequestDelegate next, HttpContext context, AuthorizationPolicy policy, PolicyAuthorizationResult authorizeResult)
   at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
   at Swashbuckle.AspNetCore.ReDoc.ReDocMiddleware.Invoke(HttpContext httpContext)
   at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIMiddleware.Invoke(HttpContext httpContext)
   at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext, ISwaggerProvider swaggerProvider)
   at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
   at Jellyfin.Server.Middleware.RobotsRedirectionMiddleware.Invoke(HttpContext httpContext)
   at Jellyfin.Server.Middleware.LegacyEmbyRouteRewriteMiddleware.Invoke(HttpContext httpContext)
   at Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.Invoke(HttpContext context)
   at Jellyfin.Server.Middleware.ResponseTimeMiddleware.Invoke(HttpContext context)
   at Jellyfin.Server.Middleware.ExceptionMiddleware.Invoke(HttpContext context)

Browser Console Logs

Requesting https://jellyfin.example.org/DisplayPreferences/usersettings?userId=1234&client=emby main.0f183787a2f78055e856.bundle.js:2:671171
XHR GET https://jellyfin.example.org/DisplayPreferences/usersettings?userId=1234&client=emby
[HTTP/2 500 Internal Server Error 5ms]

Request failed to https://jellyfin.example.org/DisplayPreferences/usersettings?userId=1234&client=emby [object Response] main.0f183787a2f78055e856.bundle.js:2:671551
Reporting request failure

Additional context
Refreshing Jellyfin in browser will lead to a successful login after it gets stuck, only the user preference request after the login fails.

Creating a new user works fine, user settings can be retrieved with no issues.

Probably related to https://github.com/jellyfin/jellyfin/issues/5953 https://github.com/jellyfin/jellyfin/issues/6012

Originally created by @DomiStyle on GitHub (Jun 27, 2021). **Describe the bug** Trying to open any of the user settings (Display, Home, Playback, Subtitles) returns a 500 from the server and ends up causing infinite loading screens in the UI. This also affects the login screen. **System (please complete the following information):** - OS: Ubuntu 20.04 - Virtualization: Docker - Clients: Browser - Browser: Firefox 89 - Jellyfin Version: 10.7.6 - Playback: - - Installed Plugins: TheTVDB, Trakt - Reverse Proxy: nginx - Base URL: none - Networking: Bridge/NAT - Storage: local **To Reproduce** * Login with admin user * Login screen gets stuck because request to /DisplayPreferences/usersettings fails **Expected behavior** Login user **Server Logs** ``` [10:28:11] [ERR] [86] Microsoft.EntityFrameworkCore.Query: An exception occurred while iterating over the results of a query for context type 'Jellyfin.Server.Implementations.JellyfinDb'. System.InvalidOperationException: The data is NULL at ordinal 5. This method can't be called on NULL values. Check using IsDBNull before calling. at Microsoft.Data.Sqlite.SqliteValueReader.GetString(Int32 ordinal) at lambda_method640(Closure , QueryContext , DbDataReader , ResultContext , SingleQueryResultCoordinator ) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() System.InvalidOperationException: The data is NULL at ordinal 5. This method can't be called on NULL values. Check using IsDBNull before calling. at Microsoft.Data.Sqlite.SqliteValueReader.GetString(Int32 ordinal) at lambda_method640(Closure , QueryContext , DbDataReader , ResultContext , SingleQueryResultCoordinator ) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() [10:28:11] [ERR] [86] Jellyfin.Server.Middleware.ExceptionMiddleware: Error processing request. URL GET /DisplayPreferences/usersettings. System.InvalidOperationException: The data is NULL at ordinal 5. This method can't be called on NULL values. Check using IsDBNull before calling. at Microsoft.Data.Sqlite.SqliteValueReader.GetString(Int32 ordinal) at lambda_method640(Closure , QueryContext , DbDataReader , ResultContext , SingleQueryResultCoordinator ) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() at System.Linq.Enumerable.ToDictionary[TSource,TKey,TElement](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer) at Jellyfin.Api.Controllers.DisplayPreferencesController.GetDisplayPreferences(String displayPreferencesId, Guid userId, String client) at lambda_method499(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextResourceFilter>g__Awaited|24_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFilterPipelineAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger) at Jellyfin.Server.Middleware.ServerStartupMessageMiddleware.Invoke(HttpContext httpContext, IServerApplicationHost serverApplicationHost, ILocalizationManager localizationManager) at Jellyfin.Server.Middleware.WebSocketHandlerMiddleware.Invoke(HttpContext httpContext, IWebSocketManager webSocketManager) at Jellyfin.Server.Middleware.IpBasedAccessValidationMiddleware.Invoke(HttpContext httpContext, INetworkManager networkManager) at Jellyfin.Server.Middleware.LanFilteringMiddleware.Invoke(HttpContext httpContext, INetworkManager networkManager, IServerConfigurationManager serverConfigurationManager) at Microsoft.AspNetCore.Authorization.Policy.AuthorizationMiddlewareResultHandler.HandleAsync(RequestDelegate next, HttpContext context, AuthorizationPolicy policy, PolicyAuthorizationResult authorizeResult) at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Swashbuckle.AspNetCore.ReDoc.ReDocMiddleware.Invoke(HttpContext httpContext) at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIMiddleware.Invoke(HttpContext httpContext) at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext, ISwaggerProvider swaggerProvider) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Jellyfin.Server.Middleware.RobotsRedirectionMiddleware.Invoke(HttpContext httpContext) at Jellyfin.Server.Middleware.LegacyEmbyRouteRewriteMiddleware.Invoke(HttpContext httpContext) at Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.Invoke(HttpContext context) at Jellyfin.Server.Middleware.ResponseTimeMiddleware.Invoke(HttpContext context) at Jellyfin.Server.Middleware.ExceptionMiddleware.Invoke(HttpContext context) ``` **Browser Console Logs** ``` Requesting https://jellyfin.example.org/DisplayPreferences/usersettings?userId=1234&client=emby main.0f183787a2f78055e856.bundle.js:2:671171 XHR GET https://jellyfin.example.org/DisplayPreferences/usersettings?userId=1234&client=emby [HTTP/2 500 Internal Server Error 5ms] Request failed to https://jellyfin.example.org/DisplayPreferences/usersettings?userId=1234&client=emby [object Response] main.0f183787a2f78055e856.bundle.js:2:671551 Reporting request failure ``` **Additional context** Refreshing Jellyfin in browser will lead to a successful login after it gets stuck, only the user preference request after the login fails. Creating a new user works fine, user settings can be retrieved with no issues. Probably related to https://github.com/jellyfin/jellyfin/issues/5953 https://github.com/jellyfin/jellyfin/issues/6012
OVERLORD added the bug label 2026-02-06 22:50:21 +03:00
OVERLORD commented 2026-02-06 22:50:24 +03:00
Author
Owner
Copy Link

@redactedscribe commented on GitHub (Jul 6, 2021):

Same happens for me.

After logging in, the error messages appearing, and the UI getting stuck, loading http://localhost:8096/web/index.html will get you past the log-in page.

It looks like the same error occurs again when initiating a rescan of a library via the Dashboard.

  • OS: Windows 10 v21H1
  • Virtualization: -
  • Browser: Firefox 89.0.2
  • Jellyfin Version: 10.7.6
  • Installed Plugins: AniDB, AniList, AniSearch, Fanart, Intros, Kitsu, Kodi Sync Queue, Open Subtitles, Playback Reporting, Reports, TMDb Box Sets, TheTVDB, Trakt
  • Reverse Proxy: -
  • Storage: local
@redactedscribe commented on GitHub (Jul 6, 2021): Same happens for me. After logging in, the error messages appearing, and the UI getting stuck, loading `http://localhost:8096/web/index.html` will get you past the log-in page. It looks like the same error occurs again when initiating a rescan of a library via the Dashboard. - OS: Windows 10 v21H1 - Virtualization: - - Browser: Firefox 89.0.2 - Jellyfin Version: 10.7.6 - Installed Plugins: AniDB, AniList, AniSearch, Fanart, Intros, Kitsu, Kodi Sync Queue, Open Subtitles, Playback Reporting, Reports, TMDb Box Sets, TheTVDB, Trakt - Reverse Proxy: - - Storage: local
OVERLORD commented 2026-02-06 22:50:26 +03:00
Author
Owner
Copy Link

@nodiscc commented on GitHub (Jul 19, 2021):

I can confirm this bug is back (I originally reported https://github.com/jellyfin/jellyfin/issues/6012)

  • OS: Debian 10
  • jellyfin 10.7.6-1
  • virtualization: KVM
  • apache2 2.4.46-4~bpo10+1
  • chromium 90.0.4430.212-1~deb10u1 or firefox 78.12.0esr-1~deb10u1
  • plugins: LDAP, Open Subtitles
  • Storage: local

It doesn't look like this was caused by a jellyfin upgrade, my last upgrade was 10.7.5-1 -> 10.7.6-1 on 2021-06-20, and the problem only started appearing on July 10-11

@nodiscc commented on GitHub (Jul 19, 2021): I can confirm this bug is back (I originally reported https://github.com/jellyfin/jellyfin/issues/6012) - OS: Debian 10 - jellyfin `10.7.6-1` - virtualization: KVM - apache2 `2.4.46-4~bpo10+1` - chromium `90.0.4430.212-1~deb10u1` or firefox `78.12.0esr-1~deb10u1` - plugins: LDAP, Open Subtitles - Storage: local It doesn't look like this was caused by a jellyfin upgrade, my last upgrade was `10.7.5-1` -> `10.7.6-1` on 2021-06-20, and the problem only started appearing on July 10-11
OVERLORD commented 2026-02-06 22:50:29 +03:00
Author
Owner
Copy Link

@BeecherNetworks commented on GitHub (Aug 6, 2021):

Same problem here, can't get logged in on my Nvidia Shield or the Android app, can't access some config screens on everything else. Simple fixes don't work, don't want to recreate multiple users. Any workaround that work? If I can't watch on my TV.....

@BeecherNetworks commented on GitHub (Aug 6, 2021): Same problem here, can't get logged in on my Nvidia Shield or the Android app, can't access some config screens on everything else. Simple fixes don't work, don't want to recreate multiple users. Any workaround that work? If I can't watch on my TV.....
OVERLORD commented 2026-02-06 22:50:30 +03:00
Author
Owner
Copy Link

@sweisgerber commented on GitHub (Aug 7, 2021):

Related to: https://github.com/jellyfin/jellyfin-web/issues/2507

Workaround: https://github.com/jellyfin/jellyfin-web/issues/2507#issuecomment-873737288 (w/ clarifications in: https://github.com/jellyfin/jellyfin-web/issues/2507#issuecomment-894669973)

@sweisgerber commented on GitHub (Aug 7, 2021): Related to: https://github.com/jellyfin/jellyfin-web/issues/2507 Workaround: https://github.com/jellyfin/jellyfin-web/issues/2507#issuecomment-873737288 (w/ clarifications in: https://github.com/jellyfin/jellyfin-web/issues/2507#issuecomment-894669973)
OVERLORD commented 2026-02-06 22:50:32 +03:00
Author
Owner
Copy Link

@cvium commented on GitHub (Sep 8, 2021):

Fixed in 10.7.7 #6512

@cvium commented on GitHub (Sep 8, 2021): Fixed in 10.7.7 #6512
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
EFjellyfin.db
area:database
awaiting-feedback
backend
blocked
breaking change: web api
bug
build
ci
confirmed
discussion needed
dotnet future
downstream
duplicate
enhancement
feature
future
github-actions
good first issue
hdr
help wanted
invalid
investigation
librarydb
live-tv
lyrics
media playback
music
needs testing
nuget
performance
platform
pull-request
Mirrored from GitHub Pull Request
 question
regression
release critical
requires-web
roadmap
security
security
stale
support
syncplay
ui & ux
upstream
wontfix
No Label bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
OVERLORD
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/jellyfin#3116
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?