yolo loop tick 1: read-only catalog audit + pre-staged SQL (dtd focus C)

6cdd086f35879936161d1d25b6ca2205a01f70eb · 2026-06-02 10:53:49 -0700 · Steve Abrams

3 BLEED_GHOST_REGEN rows live (#41043/41512/54984) flagged + unpublish SQL staged.
Dogs 201 + luxe 307 curation backlogs noted. mural-kind/vendor-leak/local_path-leak
all clean. edges-heal promotable cohort now 0 (TODO.md line 37 stale).

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

Files touched

A yolo-queue/AUDIT-2026-06-02.md

Diff

commit 6cdd086f35879936161d1d25b6ca2205a01f70eb
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Jun 2 10:53:49 2026 -0700

    yolo loop tick 1: read-only catalog audit + pre-staged SQL (dtd focus C)
    
    3 BLEED_GHOST_REGEN rows live (#41043/41512/54984) flagged + unpublish SQL staged.
    Dogs 201 + luxe 307 curation backlogs noted. mural-kind/vendor-leak/local_path-leak
    all clean. edges-heal promotable cohort now 0 (TODO.md line 37 stale).
    
    Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
---
 yolo-queue/AUDIT-2026-06-02.md | 45 ++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 45 insertions(+)

diff --git a/yolo-queue/AUDIT-2026-06-02.md b/yolo-queue/AUDIT-2026-06-02.md
new file mode 100644
index 0000000..89217c0
--- /dev/null
+++ b/yolo-queue/AUDIT-2026-06-02.md
@@ -0,0 +1,45 @@
+# wallco.ai autonomous audit — 2026-06-02 (yolo loop, dtd-decided focus C)
+
+Read-only catalog + curation-prep audit run while Steve was out. No writes to the
+catalog, no deploy. Findings ranked by actionability. Pre-staged SQL is below —
+review before running; nothing here has been applied.
+
+## 🔴 Actionable now (defects live)
+
+### G · 3 published rows carry a BLEED_GHOST_REGEN quality verdict (defect, live)
+These passed nothing — the verdict literally says "needs regen". They are visible
+on the live grid. Recommend unpublish (reversible, quality not legal).
+- #41043 (drunk-zoo-36 · deep-plum)
+- #41512 (drunk-animals)
+- #54984 (drunk-animals)
+
+Pre-staged (review, then run on Mac2; settlement override NOT needed for unpublish):
+```sql
+UPDATE all_designs SET is_published=false,
+       unpublish_reason='bleed_ghost_regen defect (audit 2026-06-02)'
+ WHERE id IN (41043,41512,54984) AND is_published=true;
+-- then: python3 scripts/refresh_designs_snapshot.py && ./deploy-kamatera.sh
+```
+
+## 🟡 Steve-gated curation backlogs (teed up, your call)
+
+- **B · dogs:** 201 unpublished awaiting hot-or-not → `/admin/dogs-curator`
+- **H · luxe-curator:** ~307 roots (924 queue entries) awaiting hot-or-not → `/luxe-curator`
+
+## 🟢 Clean / informational (no action)
+
+- **A · edges-heal promotable cohort: 0** — the ~454 figure in TODO.md is STALE;
+  no `pil-edge-heal` unpublished children remain matching. TODO line 37 can be closed.
+- **C · no-tif published: 3,450** — fine per CLAUDE.md (TIFs are lazy print masters,
+  NOT a publish prereq; nightly cron backfills; browse `/admin/needs-tif`).
+- **D · mural-kind misclassification: 0** — all mural categories correctly
+  kind=mural/mural_panel, never seamless_tile. CLAUDE.md mural rule satisfied. ✓
+- **E · catalog: 5,503 published / 39,491 total.**
+- **F · vendor-name leak (seed local_path): 0** — 2026-06-01 Thibaut vector closed. ✓
+- **I · broken-image published (no image_url+local_path): 0.** ✓
+- **J · public /api/designs local_path leak: CLEAN** — server.js localPathForDesign
+  strips the 5,342 rows that carry /Users/ paths internally. CLAUDE.md hard rule held. ✓
+
+## Damask (done earlier this session)
+759 published damasks, 100% settlement-OK, live + verified. 3 BLOCK + 1 NEEDS_REVIEW
+correctly held. Deployed.

← 6452ad3 yolo-backlog: open 2026-06-02 refinement loop (local-only pe · back to Wallco Ai · samples: fix unescaped apostrophe (We\'ll) that killed the s a805dc0 →