Two related issues after upgrading from the final 1.5 dev build to 1.6.0.69, both apparently tied to the UTC storage change.
- The dashboard “Imaging Over the last” chart shows 0 for every day
taskLog has completed runs on several days, but the chart is flat at zero. The get30day response confirms it: 0 for every date, including today.
a) Pre-upgrade runs are excluded. The fold in src/Audit/ImagingStats.php (_foldSql()) requires:
AND `logImageName` <> ''
Every taskLog row written before the upgrade has a blank logImageName (and logTaskTypeName), so all 1.5-era history is dropped:
day logImageName COUNT(*)
2026-10-07 4
2026-10-10 4
2026-10-12 6
2026-10-27 2
2026-10-28 2
2026-10-30 4
2026-11-03 1
2026-11-03 BigBox 5
Could the upgrade backfill logImageName from tasks/images, or could the fold fall back to the task’s image when it’s blank?
b) Post-upgrade runs are also missing. Running the fold’s SQL by hand with the same window returns today’s three runs, all named BigBox:
taskID started
11 2026-11-03 20:52:14
12 2026-11-03 21:27:37
13 2026-11-03 22:07:13
But get30day returns [“2026-11-03”, 0]. These runs fall within 26 hours of the UTC storage boundary, and their taskLog.createTime values are in server-local time (America/New_York) rather than UTC, which may be related. In the same tasks rows, taskCreateTime is local while taskCheckIn and taskStateChangedTime are UTC.
- New captures show UTC times with a misleading tooltip
Under Images → List All Images, captures made after the upgrade show the Captured time in UTC with an asterisk (2026-11-04 03:22:56 * for a capture that finished at 10:22 PM Eastern). The tooltip says “recorded before this server moved to UTC; written in America/New_York”. On 1.5, the same server showed local times.
From src/Base/StorageEpoch.php, I understand this is the BAND_HOURS = 26 window: values near the boundary are treated as pre-boundary and shown unadjusted. That makes sense, but for those in-band values the tooltip says they were written in America/New_York when they’re actually UTC. Wording like “recorded near this server’s move to UTC; time zone uncertain” would be more accurate.
Server time zone settings, for reference: timedatectl, FOG_TZ_INFO, PHP and MariaDB are all America/New_York. (MariaDB’s time zone tables aren’t loaded, but I see FOG deliberately avoids CONVERT_TZ().)
Version: 1.6.0.69 (Patches channel), Ubuntu 26.04 Server VM