Deleting SyncJobs

[adminExitium 173]

Encountered the following error while deleting a user:

 

2024-02-07 09:00:43.935 Info App: Sqlite: 1 - incomplete input in "delete from SyncJobItems2 where JobId in (Select Id from SyncJobs2 where UserId=19"
2024-02-07 09:00:43.938 Error UserManager: Error in OnUserDeleted
        *** Error Report ***
        Version: 4.8.0.80
        Command line: /app/emby/system/EmbyServer.dll -programdata /config -ffdetect /app/emby/bin/ffdetect -ffmpeg /app/emby/bin/ffmpeg -ffprobe /app/emby/bin/ffprob
e -restartexitcode 3
        Operating system: Linux version 6.1.77-x64v3-xanmod1 (root@runner-bjzlcsjfs-project-51590166-concurrent-0) (gcc-13 (Debian 13.2.0-10) 13.2.0, GNU ld (GNU Binu
tils for D
        Framework: .NET 6.0.25
        OS/Process: x64/x64
        Runtime: app/emby/system/System.Private.CoreLib.dll
        Processor count: 20
        Data path: /config
        Application path: /app/emby/system
        SQLitePCL.pretty.SQLiteException: Error: incomplete input - delete from SyncJobItems2 where JobId in (Select Id from SyncJobs2 where UserId=19
        SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
           at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, ReadOnlySpan`1& tail)
           at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
           at Emby.Sqlite.BaseSqliteRepository.PrepareStatement(IDatabaseConnection connection, String sql)
           at Emby.Server.Implementations.Data.SqliteItemRepository.Execute(IDatabaseConnection db, String query)
           at Emby.Server.Implementations.Data.SqliteItemRepository.OnUserDeleted(Int64 userId)
           at Emby.Server.Implementations.Library.LibraryManager.OnUserDeleted(User user)
           at Emby.Server.Implementations.Library.UserManager.OnUserDeleted(User user)
        Source: SQLitePCL.pretty
        TargetSite: SQLitePCL.pretty.IStatement PrepareStatement(System.String, System.ReadOnlySpan`1[System.Byte] ByRef)

Looks like the query is missing the closing braces after the UserID.

[Luke 37106]

Thanks, we'll take a look.