When viewing the ticket queue Closed today it shows the tickets closed yesterday.
We are in Australia and our system is set to use the AU/Sydney timezone.
Is there somewhere else this is set.
When viewing the ticket queue Closed today it shows the tickets closed yesterday.
We are in Australia and our system is set to use the AU/Sydney timezone.
Is there somewhere else this is set.
Please help us to help you by reading and following the posting guidelines located in this thread: Please read before requesting assistance. The more information you give us the better we will be able to assist you. Thank you.
Environment details?
Version of osTicket?
I cannot replicate this issue. I mouse over Closed, and click on Today. It shows me 0. Which is what I have closed today.
@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
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!
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
LewisHackfath
are you using custom time or default?
Also what is your MySQL server timezone set to?
@ntozier
MYSQL Timezone is set to System.
System is set to Australia/Sydney
PHP is set to Australia/Sydney
LewisHackfath
hmm, that all looks good, have you tried changing the timezone and see if it's taking effect, then change it back?
@ramrajone I just tried that and no luck.
Its still showing the wrong data.
LewisHackfath
Can you try restarting the Apache service, if something stuck maybe it will refresh
The entire server has been restarted several times since the upgrade to 1.11 to install other updates.
LewisHackfath
That very strange what changes have you done that started the problem?
I upgraded OSticket from 1.10.4 -> 1.11
This problem also exists in 1.12
Try setting the actual timezone in mysql instead of relying on the "server"
@ntozier are you talking about the timezone in OSTicket Tables or the MYSQL system tables?
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.
MySQL.