Fix parents.name = "Vince Ifote Ifote" (double-filled last name) #421

New issue

Open

opened 2026-04-10 18:34:02 +00:00 by forgejo_admin · 0 comments

forgejo_admin commented

2026-04-10 18:34:02 +00:00

Owner

Type

Bug

Lineage

Standalone — discovered during 2026-04-10 Westside Ops session while investigating Marcus's player list.

Repo

forgejo_admin/basketball-api

What Broke

The parent row for player Vince Ifote (id 189) has parents.name = "Vince Ifote Ifote" — the last name is duplicated. This is a form field fill artifact, not the real parent's name. The registration form probably double-wrote the last name (either an autocomplete repeat or a user typing it twice).

Repro Steps

SELECT p.name AS player, par.name AS parent FROM players p JOIN parents par ON par.id = p.parent_id WHERE p.name = 'Vince Ifote';
Observe: parent name is "Vince Ifote Ifote"

Expected Behavior

The parent row should hold the real first + last name of Vince's dad/guardian. Until we know the real first name, a sane fallback is stripping the duplicated "Ifote" → parents.name = "Vince Ifote" (which is clearly wrong for a parent if the player is also named Vince, but at least removes the obvious duplication). Ideally: ask the family for the actual parent first name on next contact.

Environment

Cluster/namespace: prod (basketball-api)
Service version/commit: current main
Affected tables: parents (row for parent_id linked to player id 189)
Related alerts: none
Discovery: Streamlit Westside Ops query on 2026-04-10

Acceptance Criteria

parents.name for Vince Ifote's parent no longer contains the duplicated "Ifote"
If real name is known (from family contact), use it; otherwise use "Vince Ifote Sr." as placeholder pending confirmation
Low priority — not blocking Vince's contract flow since contracts use player name + parent email, not parent name
Verify no other parent rows have obvious double-fill artifacts: SELECT name FROM parents WHERE name ~ '(\w+) \1'; — clean up any others found

westside-basketball — project this affects

### Type Bug ### Lineage Standalone — discovered during 2026-04-10 Westside Ops session while investigating Marcus's player list. ### Repo `forgejo_admin/basketball-api` ### What Broke The parent row for player Vince Ifote (id 189) has `parents.name = "Vince Ifote Ifote"` — the last name is duplicated. This is a form field fill artifact, not the real parent's name. The registration form probably double-wrote the last name (either an autocomplete repeat or a user typing it twice). ### Repro Steps 1. `SELECT p.name AS player, par.name AS parent FROM players p JOIN parents par ON par.id = p.parent_id WHERE p.name = 'Vince Ifote';` 2. Observe: parent name is "Vince Ifote Ifote" ### Expected Behavior The parent row should hold the real first + last name of Vince's dad/guardian. Until we know the real first name, a sane fallback is stripping the duplicated "Ifote" → `parents.name = "Vince Ifote"` (which is clearly wrong for a parent if the player is also named Vince, but at least removes the obvious duplication). Ideally: ask the family for the actual parent first name on next contact. ### Environment - Cluster/namespace: prod (basketball-api) - Service version/commit: current main - Affected tables: `parents` (row for parent_id linked to player id 189) - Related alerts: none - Discovery: Streamlit Westside Ops query on 2026-04-10 ### Acceptance Criteria - [ ] `parents.name` for Vince Ifote's parent no longer contains the duplicated "Ifote" - [ ] If real name is known (from family contact), use it; otherwise use "Vince Ifote Sr." as placeholder pending confirmation - [ ] Low priority — not blocking Vince's contract flow since contracts use player name + parent email, not parent name - [ ] Verify no other parent rows have obvious double-fill artifacts: `SELECT name FROM parents WHERE name ~ '(\w+) \1';` — clean up any others found ### Related - `westside-basketball` — project this affects