2 Commits

Author	SHA1	Message	Date
unkin-agent	face8ac653	fix(api): normalise the Next Up cutoff to UTC ... The query-string cutoff binds as DateTimeKind.Unspecified, which Npgsql refuses to write to timestamp with time zone, so /Shows/NextUp 500s.	2026-09-20 23:47:23 +10:00
unkin-agent	6e405af1dc	fix(db): collapse presentation-key groups without min(uuid) ... PostgreSQL has no min(uuid) aggregate, so every query that picked a group representative with MIN over the item id failed with 42883: library browse, search, Recently Added, the by-name endpoints and Upcoming. - Pick the representative with an anti-join on (primary version, id) - Cover the collapse with a repository test against a real PostgreSQL	2026-09-13 13:18:11 +10:00