Summary
AuditLogRepository.CountByDateAsync explicitly throws NotSupportedException for non-SQLite databases. StreakService calls it unconditionally. Any SQL Server deployment will crash at runtime on every call.
Location
backend/src/Taskdeck.Infrastructure/Repositories/AuditLogRepository.cs, lines 282-286
Suggested Fix
Implement the non-SQLite path using EF.Functions.DateDiffDay or raw SQL, or guard in StreakService to return empty result rather than throw.
Source
Found during codebase health analysis (2026-06-06).
Summary
AuditLogRepository.CountByDateAsyncexplicitly throwsNotSupportedExceptionfor non-SQLite databases.StreakServicecalls it unconditionally. Any SQL Server deployment will crash at runtime on every call.Location
backend/src/Taskdeck.Infrastructure/Repositories/AuditLogRepository.cs, lines 282-286Suggested Fix
Implement the non-SQLite path using
EF.Functions.DateDiffDayor raw SQL, or guard inStreakServiceto return empty result rather than throw.Source
Found during codebase health analysis (2026-06-06).