starred/jellyfin
1
0
Fork 0
mirror of https://github.com/jellyfin/jellyfin.git synced 2026-07-16 05:43:54 +03:00
Code Issues 822 Packages Projects Releases 17 Wiki Activity

[PR #9297] LiveTV fixes #12054

New Issue
Closed
opened 2026-02-07 06:49:12 +03:00 by OVERLORD · 0 comments
OVERLORD commented 2026-02-07 06:49:12 +03:00
Owner
Copy Link

Original Pull Request: https://github.com/jellyfin/jellyfin/pull/9297

State: closed
Merged: Yes

  • Filter out empty categories
  • Filter out empty item values

The following exception is thrown in InsertItemValues if values contains an empty string.

[2023-02-11 07:13:16.900 -07:00] [ERR] [22] Emby.Server.Implementations.LiveTv.LiveTvManager: Error getting programs for channel "ABC EAST"
Constraint: SQLitePCL.pretty.SQLiteException: NOT NULL constraint failed: ItemValues.Type
   at SQLitePCL.pretty.SQLiteException.Throw(Int32 rc, Int32 extended, String msg)
   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3_stmt stmt, Int32 rc)
   at SQLitePCL.pretty.StatementImpl.MoveNext()
   at Emby.Server.Implementations.Data.SqliteItemRepository.InsertItemValues(Byte[] idBlob, List`1 values, IDatabaseConnection db) in C:\Users\Cody\Documents\Code\jellyfin\Emby.Server.Implementations\Data\SqliteItemRepository.cs:line 5511
   at Emby.Server.Implementations.Data.SqliteItemRepository.UpdateItemValues(Guid itemId, List`1 values, IDatabaseConnection db) in C:\Users\Cody\Documents\Code\jellyfin\Emby.Server.Implementations\Data\SqliteItemRepository.cs:line 5462
   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItemsInTransaction(IDatabaseConnection db, IEnumerable`1 tuples) in C:\Users\Cody\Documents\Code\jellyfin\Emby.Server.Implementations\Data\SqliteItemRepository.cs:line 655
   at Emby.Server.Implementations.Data.SqliteItemRepository.<>c__DisplayClass34_0.<SaveItems>b__0(IDatabaseConnection db) in C:\Users\Cody\Documents\Code\jellyfin\Emby.Server.Implementations\Data\SqliteItemRepository.cs:line 617
   at SQLitePCL.pretty.DatabaseConnection.<>c__DisplayClass20_0.<RunInTransaction>b__0(IDatabaseConnection db)
   at SQLitePCL.pretty.DatabaseConnection.RunInTransaction[T](IDatabaseConnection This, Func`2 f, TransactionMode mode)
   at SQLitePCL.pretty.DatabaseConnection.RunInTransaction(IDatabaseConnection This, Action`1 action, TransactionMode mode)
   at Emby.Server.Implementations.Data.ManagedConnection.RunInTransaction(Action`1 action, TransactionMode mode) in C:\Users\Cody\Documents\Code\jellyfin\Emby.Server.Implementations\Data\ManagedConnection.cs:line 51
   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(IEnumerable`1 items, CancellationToken cancellationToken) in C:\Users\Cody\Documents\Code\jellyfin\Emby.Server.Implementations\Data\SqliteItemRepository.cs:line 614
   at Emby.Server.Implementations.Library.LibraryManager.CreateItems(IReadOnlyList`1 items, BaseItem parent, CancellationToken cancellationToken) in C:\Users\Cody\Documents\Code\jellyfin\Emby.Server.Implementations\Library\LibraryManager.cs:line 1770
   at Emby.Server.Implementations.LiveTv.LiveTvManager.RefreshChannelsInternal(ILiveTvService service, IProgress`1 progress, CancellationToken cancellationToken) in C:\Users\Cody\Documents\Code\jellyfin\Emby.Server.Implementations\LiveTv\LiveTvManager.cs:line 1210
**Original Pull Request:** https://github.com/jellyfin/jellyfin/pull/9297 **State:** closed **Merged:** Yes --- - Filter out empty categories - Filter out empty item values The following exception is thrown in `InsertItemValues` if `values` contains an empty string. ``` [2023-02-11 07:13:16.900 -07:00] [ERR] [22] Emby.Server.Implementations.LiveTv.LiveTvManager: Error getting programs for channel "ABC EAST" Constraint: SQLitePCL.pretty.SQLiteException: NOT NULL constraint failed: ItemValues.Type at SQLitePCL.pretty.SQLiteException.Throw(Int32 rc, Int32 extended, String msg) at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc) at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3_stmt stmt, Int32 rc) at SQLitePCL.pretty.StatementImpl.MoveNext() at Emby.Server.Implementations.Data.SqliteItemRepository.InsertItemValues(Byte[] idBlob, List`1 values, IDatabaseConnection db) in C:\Users\Cody\Documents\Code\jellyfin\Emby.Server.Implementations\Data\SqliteItemRepository.cs:line 5511 at Emby.Server.Implementations.Data.SqliteItemRepository.UpdateItemValues(Guid itemId, List`1 values, IDatabaseConnection db) in C:\Users\Cody\Documents\Code\jellyfin\Emby.Server.Implementations\Data\SqliteItemRepository.cs:line 5462 at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItemsInTransaction(IDatabaseConnection db, IEnumerable`1 tuples) in C:\Users\Cody\Documents\Code\jellyfin\Emby.Server.Implementations\Data\SqliteItemRepository.cs:line 655 at Emby.Server.Implementations.Data.SqliteItemRepository.<>c__DisplayClass34_0.<SaveItems>b__0(IDatabaseConnection db) in C:\Users\Cody\Documents\Code\jellyfin\Emby.Server.Implementations\Data\SqliteItemRepository.cs:line 617 at SQLitePCL.pretty.DatabaseConnection.<>c__DisplayClass20_0.<RunInTransaction>b__0(IDatabaseConnection db) at SQLitePCL.pretty.DatabaseConnection.RunInTransaction[T](IDatabaseConnection This, Func`2 f, TransactionMode mode) at SQLitePCL.pretty.DatabaseConnection.RunInTransaction(IDatabaseConnection This, Action`1 action, TransactionMode mode) at Emby.Server.Implementations.Data.ManagedConnection.RunInTransaction(Action`1 action, TransactionMode mode) in C:\Users\Cody\Documents\Code\jellyfin\Emby.Server.Implementations\Data\ManagedConnection.cs:line 51 at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(IEnumerable`1 items, CancellationToken cancellationToken) in C:\Users\Cody\Documents\Code\jellyfin\Emby.Server.Implementations\Data\SqliteItemRepository.cs:line 614 at Emby.Server.Implementations.Library.LibraryManager.CreateItems(IReadOnlyList`1 items, BaseItem parent, CancellationToken cancellationToken) in C:\Users\Cody\Documents\Code\jellyfin\Emby.Server.Implementations\Library\LibraryManager.cs:line 1770 at Emby.Server.Implementations.LiveTv.LiveTvManager.RefreshChannelsInternal(ILiveTvService service, IProgress`1 progress, CancellationToken cancellationToken) in C:\Users\Cody\Documents\Code\jellyfin\Emby.Server.Implementations\LiveTv\LiveTvManager.cs:line 1210 ```
OVERLORD added the pull-request label 2026-02-07 06:49:12 +03:00
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 pull-request
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#12054
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?