backlog: PROD BUG #2 found — best-sellers images 404 (spoon_all_designs local_path mismatch); diagnosed, flagged for Steve (gated DB write)

eaae334614c563884ea9fbea6ff6eddce4587262 · 2026-06-03 14:11:17 -0700 · Steve

Files touched

M YOLO_BACKLOG.md

Diff

commit eaae334614c563884ea9fbea6ff6eddce4587262
Author: Steve <steve@designerwallcoverings.com>
Date:   Wed Jun 3 14:11:17 2026 -0700

    backlog: PROD BUG #2 found — best-sellers images 404 (spoon_all_designs local_path mismatch); diagnosed, flagged for Steve (gated DB write)
---
 YOLO_BACKLOG.md | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)

diff --git a/YOLO_BACKLOG.md b/YOLO_BACKLOG.md
index 55f8ba7..b8a4c87 100644
--- a/YOLO_BACKLOG.md
+++ b/YOLO_BACKLOG.md
@@ -180,6 +180,23 @@ reversible local commit** marked `[x]` w/ hash, then ScheduleWakeup ~1800s.
 > ItemList rewire. Future loop ticks will likely find only marginal/clean — the deploy is
 > the dominant pending action.
 
+## 🟠 PROD BUG #2 found via functional testing — 2026-06-03 (NEEDS STEVE — gated, sensitive schema)
+**Best-sellers card images 404 on prod.** `/api/best-sellers` (best-sellers.js) builds
+`image_url = /img/seed/<basename(row.local_path)>` from `spoon_all_designs WHERE kind='best_seller_seed'`.
+On PROD those rows' local_path basenames are `seed-N.png` → `/img/seed/seed-78.png` etc., which **do
+not exist** (404). The 70 real files in `public/img/seed/` are SKU-named (`DGW-806022-SAMPLE.jpg`).
+On LOCAL Mac2 the same rows return `image_url: null` (different DB state). So ~58 items on the
+customer-facing /best-sellers page render broken images (best-sellers.html line 215 does
+`src="'+i.image_url+'"` with NO onerror fallback).
+- **NOT auto-fixed** — the fix is a write to `spoon_all_designs` (sensitive shared dw_unified table,
+  the same best_seller_seed cohort flagged in MEMORY for the 2026-06-01 vendor-leak scrub) OR
+  regenerating the seed images, OR understanding the intended local_path→file mapping. Prod DB write
+  to an unfamiliar/sensitive schema = hard stop. NO seed-N.png generator script found in scripts/.
+- **Options for Steve:** (a) fix the best_seller_seed rows' local_path to point at the real SKU-named
+  files; (b) regenerate seed-N.png assets; (c) cheap band-aid = add an `onerror` placeholder on the
+  best-sellers card img so broken images degrade gracefully (autonomous-safe code change + deploy if
+  you want it). Pick one and I'll execute the non-gated part.
+
 ## ✅ RESOLVED — PROD BUG (art-archive 502) FIXED 2026-06-03 (loop #12)
 **Steve authorized restore; both bridge halves brought back; all 4 prod images verified 200.**

← 599ae58 backlog: art-archive 502 RESOLVED — restored local :9716 app · back to Thesetdecorator · TSD: graceful onerror fallback on best-sellers card images ( f314640 →