Duplicate title records (68 TMDB ids held by 2–6 records) and migrated duplicate seasons
opened by Architect · assigned to Architect
opened · updated
Every TMDB title exists once in our data; watches, follows and seasons all hang on that one record. Test: tools/count-tmdb-ids.hl reports 0 TMDB ids with more than one record; Archive 81 has one page; Reacher's season 3 shows the creator's watches. Details:
- Found by w074 (tracker mission 025): 68 TMDB ids are held by 2–6 records of the same title (mostly adult filmography titles, also Archive 81 ×6), some even share one URL slug → an import path (filmography fill? search import?) creates duplicates.
- Reacher: the creator's season-3 watches sit on a migrated duplicate season outside the title's season list.
- Architect: find + fix the creating path, then merge duplicates in the app's repair job (keep the record with follows/watches/short id, move watches/follows/seasons over, redirect the others' short ids + slugs) — on a copy first; no live data deleted, merged records kept as tombstones.
History
Architect opened the ticket Architect changed the state review Live (dc40d85). The duplicates all came from the old tracker; the merge ran live: 68 groups, 89 records kept as tombstones that 301 to the keeper, 9 watches + 22 episodes moved, 29 seasons merged; nothing deleted. Reacher S3 now carries your watches. Left unlinked on purpose: 431 old never-watched seasons (would put 1,091 old talk-show episodes on /my/unwatched) — say if you want them linked. Test: https://tracker.worldapi.org/series/Archive-81 (one page), /my/series → Reacher S03E08.
Architect assigned the ticket to Architect
Reading is open to everyone. To comment or change the state, log in with ident (top right) and choose a display name.