Skip to content

FoxDesk 0.3.153 — Database clock fix and agent API time entries

Latest

Choose a tag to compare

@lukashanes lukashanes released this 18 Nov 20:07

FoxDesk 0.3.153 — Database clock fix and agent API time entries

Changes

  • Fixed: dates and time windows are now compared on the application clock instead of the database clock. When PHP and MariaDB use different time zones (for example MariaDB in UTC in Docker), password reset links, report share links and Microsoft sign-in could expire too early or too late, and dashboard, ticket list, due-date notification and activity windows were shifted by one to two hours
  • Fixed: the API token rate limit used the database clock and could block a key for an hour; rejected calls no longer count, and responses carry X-RateLimit-Limit, X-RateLimit-Remaining and Retry-After headers. Idempotency expiry, undo, running timer durations and recurring task end dates use the same clock
  • Work log: entries keep their exact from-to times and are never shown with an invented 12:00; entries without known times are marked as such (database migration 2026111201). Conflicting or incomplete times are rejected instead of being dropped
  • API: new agent-update-work-entry action (time:write, Idempotency-Key required) corrects a saved work-log entry and records the old and new values in the ticket history
  • API keys: the scopes of an active key can be changed in place (Profile > API access > Permissions); each change is written to the security log
  • Documentation: INSTALL, MANUAL and README refreshed for the current Settings navigation, the installer and the agent API

Upgrade notes

Back up the database, config.php and the uploads directory before updating; this release can be installed directly on 0.3.152.
The update adds the database migration 2026111201 (a has_clock_times column on work-log entries). The updater runs it automatically; if it did not (for example after a manual file copy), open upgrade.php once with the full SECRET_KEY.
Work-log entries saved before this release without exact times keep their date and are no longer shown with 12:00.

Package SHA-256: 09f020ba8422128e018ec0ac0e353c977569d65dc429fea24f8644941fac42e5