SQLite error: FetchAndParseImportListService: Error during Import List Sync of Custom List

Sonarr version (exact version):

Package Version release-38868c1 by [hotio](https://github.com/hotio)
.NET Yes (6.0.13)
Docker Yes
Database Sqlite 3.44.2

Mono version (if Sonarr is not running on Windows):
OS: Ubuntu 23.10
Running in docker
Debug logs:
Description of issue:

Sonarr runs fine but the console log shows an error recurring every 4 minutes, to do with a list. I will include:

  1. the stack trace

  2. the list parameters displayed/stored in Sonarr

  3. the details of the list created in listrrpro

  4. Stack trace:

2024-05-17T21:56:14.062421566Z [Info] ImportListSyncService: Starting Import List Refresh for List Listrrpro dir 
2024-05-17T21:56:14.321040490Z [Error] FetchAndParseImportListService: Error during Import List Sync of Custom List (Listrrpro dir) 
2024-05-17T21:56:14.321074739Z [v4.0.4.1491] code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
2024-05-17T21:56:14.321079059Z NOT NULL constraint failed: ImportListItems.Title
2024-05-17T21:56:14.321083233Z    at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
2024-05-17T21:56:14.321087388Z    at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
2024-05-17T21:56:14.321091505Z    at System.Data.SQLite.SQLiteDataReader.NextResult()
2024-05-17T21:56:14.321095613Z    at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
2024-05-17T21:56:14.321099908Z    at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
2024-05-17T21:56:14.321104050Z    at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior) in /_/Dapper/SqlMapper.cs:line 1075
2024-05-17T21:56:14.321108361Z    at Dapper.SqlMapper.QueryMultipleImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 1058
2024-05-17T21:56:14.321112891Z    at NzbDrone.Core.Datastore.BasicRepository`1.Insert(IDbConnection connection, IDbTransaction transaction, TModel model) in ./Sonarr.Core/Datastore/BasicRepository.cs:line 188
2024-05-17T21:56:14.321117173Z    at NzbDrone.Core.Datastore.BasicRepository`1.InsertMany(IList`1 models) in ./Sonarr.Core/Datastore/BasicRepository.cs:line 210
2024-05-17T21:56:14.321121356Z    at NzbDrone.Core.ImportLists.ImportListItems.ImportListItemService.SyncSeriesForList(List`1 listSeries, Int32 listId) in ./Sonarr.Core/ImportLists/ImportListItems/ImportListItemService.cs:line 35
2024-05-17T21:56:14.321125726Z    at NzbDrone.Core.ImportLists.FetchAndParseImportListService.<>c__DisplayClass6_0.<FetchSingleList>b__0() in ./Sonarr.Core/ImportLists/FetchAndParseImportListService.cs:line 137
2024-05-17T21:56:14.322628444Z [Info] ImportListSyncService: Processing 98 list items 
2024-05-17T21:56:14.332387206Z [Info] ImportListSyncService: Import List Sync Completed. Items found: 98, Series added: 0
  1. The list parameters of the failing Import list in Sonarr:

A ‘test’ done on this succeeds.

  1. Details of the list created in Listrrpro
  • Name: “Best tv by dir”
  • Last processed: 22 minutes ago
  • Type: Show
  • State: None
  • IsStatic: No
  • IsPrivate: Yes
  • Items: 100
  • Upvotes: 0
  • Created: One month ago
  • Modified: 22 minutes ago

This list currently has 100 items in it, including 2 occurrences of duplicate items, thus 98 actual unique items).

Details of this list: (if field omitted, defaults are used)
Basic filters:

  • Include: Between 2010 and 2024
  • Exclude: Between 1965 and 2009
    Rating filters:
  • TMDb Rating: Between 8 and 10 with at least 100 votes
  • IMDb Rating: Between 8 and 10
    Content rating filter:
    Include: Content rating country: Canada, United Kingdom of Great Britain and Northern Ireland, United States of America
    Nationality filter: Include: English

This should be fixed by Custom Import List improvements by markus101 · Pull Request #6914 · Sonarr/Sonarr · GitHub once it lands.