Skip to content

History / Storing Every Date In UTC

Revisions

  • GH #129: every page returned HTTP 500 after upgrading Write-up for the #1446 regression - dbConnectionOptions() was put in config.php, which is the operator's file, so upgrading delivered the eleven callers and left the definition behind. - Issue-129-Every-Page-Returned-HTTP-500.md (new) - Bugs-Resolved.md row - _Sidebar.md entry - Storing-Every-Date-In-UTC.md: the function's home is includes/db.php, not config.php

    @edmozley edmozley committed Sep 3, 2026
  • Storing every date in UTC (#1446) New page for the structural fix behind issue #126: the connection is now pinned to UTC so a column filled in by its own DEFAULT CURRENT_TIMESTAMP cannot be wrong - 302 statements across 220 tables. Covers the half that made it more than a one-liner: the naive wall clocks and bare dates that had to be given an explicit local clock first, the literal-vs-placeholder decision in naive_today_sql(), and why the test's positive control and offset-hour section are the parts that mean anything. Issue-126 section 8 updated from 'not fixed' to point here.

    @edmozley edmozley committed Sep 1, 2026