Purging of tickets is offset by timezone

Created on 31 July 2024, 2 months ago
Updated 15 August 2024, about 1 month ago

Problem/Motivation

When tickets are purged form the database, no timezone is used when creating the date string to compare against. During insertion of the ticket into the database, the UTC timezone is used.

If your site's timezone is GMT+10, then tickets are purged 10 hours earlier than expected.

Steps to reproduce

  1. Set your site timezone to GMT+10
  2. Set all ticket timeouts to a value that will expire inside the next 10 hours, but not too soon so it can be tested
  3. Trigger the creation of a ticket which will be stored with an expiry in UTC
  4. Run cron and observe all of the tickets being purged hours before their expiry

Proposed resolution

Use UTC when purging tickets.

Remaining tasks

  • ✅ File an issue
  • ✅ Addition/Change/Update/Fix
  • ✅ Release notes snippet
  • ❌ Release

User interface changes

  • N/A

API changes

  • N/A

Data model changes

  • N/A

Release notes snippet

🐛 Bug report
Status

Fixed

Version

2.1

Component

Code

Created by

🇦🇺Australia elc

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Merge Requests

Comments & Activities

Production build 0.71.5 2024