Week 056 — Phinx, Missing Columns, and a Production Route Bug
The subscription page route fails in production but not development. The cash-reward column was never added to production's DB. Phinx is installed to manage migrations going forward.
The subscription page route fails in production but not development. The cash-reward column was never added to production's DB. Phinx is installed to manage migrations going forward.
"The dev compose works across machines for the first time. The production image is built and pushed. The DigitalOcean droplet is configured. And three production bugs are found and fixed: a missing .env, a case-sensitivity filename issue, upload volume persistence, and a slow-save delay traced to a rogue PDO object."
The lost location map implementation hits a coordinates bug. Docker SSL configuration continues to resist resolution, blocking the move to production.
Lost item geotagging is implemented end-to-end — DTO, Service, Repository, UI, and save logic — but the load display is broken. Deciding to show a map instead of raw coordinates changes the scope mid-week.
"Geotagging lost items begins: the database schema is updated to store coordinates and search radius for lost item reports."