# Google Sheets Multiple Scripts: Resolving Conflicting `onEdit` Triggers ## Summary – Three separate functions named `onEdit` were implemented to handle spreadsheet edits – Conflicting trigger definitions caused only the final `onEdit` implementation to execute – Attempts to rename functions broke trigger registration while maintaining name collisions – Resolution required merging all logic into a … Read more
# `info.remote_addr()` – Method Not Found in warp::log::Info: A Production Postmortem ## Summary A compilation error occurred when using `info.remote_addr()` within `warp::log::custom`. The method `remote_addr` is absent in `warp::log::Info`, causing the Rust compiler to reject the code. The issue stems from API differences between Warp’s logging middleware and remote address extraction. ## Root Cause * … Read more
# Laravel Migration Rollbacks Fail to Trigger Model Deletion Events ## Summary – Model deletion events (`deleting`/`deleted`) are not triggered during Laravel migration rollbacks when using `Schema::drop()` or `Schema::dropIfExists()`. – This occurs because table dropping bypasses Eloquent model hooks and executes SQL-level `DROP TABLE` commands. – External API cleanup logic attached to model events fails … Read more
# API Design Postmortem: Handling Math Formulas in REST Responses ## Summary – A quiz application API returned mathematical formulas exclusively in LaTeX format within JSON payloads – This design forced clients to implement LaTeX rendering regardless of their capabilities – Scalability concerns emerged due to varied client requirements and rendering complexity ## Root Cause … Read more
# Postmortem: Subform RecordSource Update Failure in MS Access Production Database ## Summary A production database form stopped updating inspection questions after combobox selections. The main form (`frm_Inspections`) contained a combobox for inspection types, with a subform (`sub_Questions`) that should dynamically switch between four tables sharing identical schemas. Despite multiple attempts, the RecordSource change wasn’t … Read more
# Controller Assignment Failures in UE5 Multiplayer Fighting Game ## Summary Failure to assign distinct input devices (gamepad/keyboard) to specific characters in a 2.5D fighter resulted in both devices controlling Player 1. Implemented explicit controller-device assignment via Player Controller initialization and Enhanced Input subsystem separation. ## Root Cause – Unreal Engine’s default behavior binds all … Read more
# Postmortem: Ruff Format Collapsing Multi-Line Chained Method Calls Against Developer Intent ## Summary • Ruff formatter unexpectedly collapsed multiline chained method calls into a single line • Attempts to use `preview = true` and adjust `pyproject.toml` configuration didn’t preserve desired formatting • Behavior occurred inconsistently based on trailing comments or argument length ## Root … Read more
# Adding a Global Group Module (Header) to a Child Theme: Why CSS Failed to Load ## Summary – A developer cloned a global header module in a HubSpot CMS child theme. – The cloned module was referenced in `base.html` via the module path. – The header displayed structurally but rendered without CSS styling. – … Read more
# How to solve Xcode error “The i386 architecture is deprecated.” ## Summary – Deprecated i386 architecture prevented macOS app release builds – Project settings contained legacy 32-bit Intel (i386) architecture references – Debug builds succeeded due to “Build Active Architectures Only” masking the issue – Resolution required manual removal of i386 from build settings … Read more
# Postmortem: Incorrect Conditional Logic in Access Report Field Population ## Summary An attempt to dynamically populate an unbound text box on an Access report based on record-level conditions resulted in all records showing the same error message (“Missing General Citation”), regardless of actual field values. ## Root Cause – The conditional logic in the … Read more