fix: designs had empty image_url -> blank cards on /designs. Backfill all 8618 + persistDesign now sets image_url=/designs/img/by-id/<id>

498edd445566502d8aa935f6adb53093b31bcb48 · 2026-05-19 11:47:32 -0700 · SteveStudio2

Files touched

M scripts/generate_designs.js

Diff

commit 498edd445566502d8aa935f6adb53093b31bcb48
Author: SteveStudio2 <steve@designerwallcoverings.com>
Date:   Tue May 19 11:47:32 2026 -0700

    fix: designs had empty image_url -> blank cards on /designs. Backfill all 8618 + persistDesign now sets image_url=/designs/img/by-id/<id>
---
 scripts/generate_designs.js | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

diff --git a/scripts/generate_designs.js b/scripts/generate_designs.js
index 0f98473..ec7f935 100644
--- a/scripts/generate_designs.js
+++ b/scripts/generate_designs.js
@@ -361,7 +361,14 @@ VALUES (
   '${category.replace(/'/g, "''")}',
   FALSE
 ) RETURNING id;`;
-  return psql(sql);
+  const idStr = psql(sql);
+  const newId = parseInt(idStr, 10);
+  // image_url can't be known until the row exists — set it to the by-id image
+  // route so every grid / hero / search renderer has a working <img> src.
+  if (Number.isFinite(newId)) {
+    try { psql(`UPDATE spoon_all_designs SET image_url='/designs/img/by-id/${newId}' WHERE id=${newId};`); } catch {}
+  }
+  return idStr;
 }
 
 // ---- main -----------------------------------------------------------------

← 152bba8 wallco: CTA heading -> 'Every Design is an Original.' · back to Wallco Ai · refiner_compare: skip already-rendered images so a crash+res 252f179 →