@ntozier no such luck.
Tried setting MySQL timezone still shows the wrong date.
Ticket Queue - Closed Today Wrong Date
5 days later
I have now upgraded to 1.12 and this is still occurring.
2 months later
Hi @ntozier ,
I have worked out what the cause of this is.
In the bootstrap.php file you do a number of checks against the php.ini default timezone starting on line 35.
However after all of that you then set the default timezone to UTC no matter the outcome of the checks. this is done on line 46
commenting out line 46 fixes my issue with the closed today queue being incorrect but it then creates problems with the lock system where no user can post a reply to tickets.
I've passed that along to the devs. You might want to open an issue report on github for this though.
@ntozier seems like someone else raised this quite some time ago
https://github.com/osTicket/osTicket/issues/3141
Hey @KevinTheJedi yeah tried that as well, it’s not a problem with just one agent profile it’s with everyone’s profiles.
It's very strange as we have thousands of people using v1.12.2 in all kinds of different timezones/time formats with no time issues whatsoever. I'll see what I can do to try and replicate this...going to be hard though.
Cheers.
I’m currently on 1.12 but will install a copy of 1.12.2 and verify if the issue is still present
@KevinTheJedi i have just tried a clean install of 1.12.2 and we are still getting the incorrect timezone on closed today queue. it is using the UTC timezone.
Admin Dashboard Timezone set to Australia/Sydney
PHP date.timezone set to Australia/Sydney
Agent Preferences Timezone set to Australia/Sydney
MySQL timezone matches PHP Timezone.
Contrary to my initial belief this does not stem from the bootstrap.php file.
However I am able to replicate this same problem on another server.
again:
Admin Dashboard Timezone set to Australia/Sydney
PHP date.timezone set to Australia/Sydney
Agent Preferences Timezone set to Australia/Sydney
MySQL timezone matches PHP Timezone.
But closed today still shows everything in UTC time.
- Edited
I know you said you've checked those timezone settings but have you tried resetting the System Timezone and Agent Profile Timezone? Sometimes you have to re-save things because of cache, etc. Try going to the System Timezone and set it to Auto Detect and Save Changes. Repeat same steps for Agent Profile timezone. Then retest to see if it was just a glitch, caching issue, etc.
Cheers.
Just tried setting them to Auto Detect and saving both settings and its still coming up with the UTC Timezone for my closed today queue.