Ticket Queue - Closed Today Wrong Date

LewisHackfath

@ntozier additional information on this issue.
We had closed several tickets on 30/4/2019 and they were all being displayed when the date was in fact 1/5/2019.
We noticed that by 2pm on 1/5/2019 that the date had rolled over to match our day.
However coming in today 2/5/19 I can see that it is displaying closed today tickets for 1/5/19

LewisHackfath

RBGE

Maybe a daft question here, but is the time (and timezone setting) on the server itself correct??

Also, you're going to get asked to upgrade osTicket to 1.12... 1.11 is unsupported now!

LewisHackfath

Server Timezone is correct, OSticket is correct but this queue is incorrect.

I am in the process of testing 1.12 in accordance with our companies user acceptance testing guidelines

ramrajone

LewisHackfath
are you using custom time or default?

ntozier

Also what is your MySQL server timezone set to?

LewisHackfath

@ramrajone

@ntozier
MYSQL Timezone is set to System.
System is set to Australia/Sydney
PHP is set to Australia/Sydney

ramrajone

LewisHackfath
hmm, that all looks good, have you tried changing the timezone and see if it's taking effect, then change it back?

LewisHackfath

@ramrajone I just tried that and no luck.
Its still showing the wrong data.

ramrajone

LewisHackfath
Can you try restarting the Apache service, if something stuck maybe it will refresh

LewisHackfath

The entire server has been restarted several times since the upgrade to 1.11 to install other updates.

ramrajone

LewisHackfath
That very strange what changes have you done that started the problem?

LewisHackfath

I upgraded OSticket from 1.10.4 -> 1.11
This problem also exists in 1.12

ntozier

Try setting the actual timezone in mysql instead of relying on the "server"

LewisHackfath

@ntozier are you talking about the timezone in OSTicket Tables or the MYSQL system tables?

LewisHackfath

I have changed the MYSQL timezone to '+10:00' and performed select now() which is showing the correct date/time.
But OSTicket Closed today still shows yesterdays results.

ntozier

MySQL.

LewisHackfath

@ntozier no such luck.
Tried setting MySQL timezone still shows the wrong date.

LewisHackfath

I have now upgraded to 1.12 and this is still occurring.

LewisHackfath

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.