I'll try to get to that now.
I'm IN the osTicket database when i do the above SQL queries, am i not?
So, if my wall-clock shows 1500 and the osTicket timestamp shows 2000 it seems to be neither right?

I'm sorry to be confused here, i'm reporting the values i see and trying not to interpret them.
Does that timestamp difference show that osT is displaying CDT or UTC?
It is a 5 hour difference but neither, isn't it?

Best,
michael grimes

yes, good post - i previously reported the settings i found ...

PHP's "date.timezone" is 'DEFAULT'
MySQL's "system time zone" is 'UTC'
MySQL's "timezone" is "America/Chicago" with a time zone (session value) of 'UTC'
MySQL's "session track system variables" contains 'time_zone'
OST's "Default Time Zone" is 'America / New_York'

Because this is a shared host, on SiteGround, i don't have 'full control' and can't do many of the things in that post.

Thanks for the comment though - if i knew what was wrong i wouldn't be here ;-)

miC

    _SAmiC

    Let me provide clearer steps I guess. Please go to the _ticket table in your osTicket database, find a ticket where you know what time it was created (or simply create a new one and write down the time you created it), and look at the created column value for that specific ticket record to see what it says. See if it matches the time you wrote down or if it is 5 hours behind/ahead. This will help us understand what time the database is using so we can better understand what’s happening.

    Cheers.

      and the 'updated' value which should match my initial snip of the ticket is

      _SAmiC

      So it’s showing a created time of 16:05 in the db, showing 17:05 in the UI, and the UI should be showing 12:05?

      Cheers.

        9 days later

        Sorry for delay in responding -- other issues took precedence.
        Yes, you've summarized the issue.

        Any idea what could be going on?
        Have i configured something incorrectly?

        Best,
        miC

          _SAmiC

          Maybe your system time zone or maybe profile time zone is off? Db should be UTC so UI is an hour ahead means the time zone in the UI (ie. user/system time zone) is most likely wrong.

          Cheers.

            @KevinTheJedi
            sorry to add yet another post -- here is the current status -- no change yet and SiteGround has closed their ticket saying nothing is wrong with their settings for PHP or MySQL on their end.

            notes-2024-1108-timezone-issue-after-ost-upgrade-to-v181.pdf
            126kB

            my next attempt to fix this will be making some osT timezone setting changes to see if we can see differences in the values being displayed.

            miC

            @KevinTheJedi

            You're busy with more important things, so no worries on this i guess?
            The best i could come up with is to believe that something is wrong with SiteGround's MySQL cofiguration.

            So, i've set osT system TZ to be America/Chicago which matches SiteGrounds's MySQL "timezone" variable.
            Then set my ost profile TZ to be America/New_York.

            The seemingly bizarre result to me is that the ost Ticket display values now show UTC timestamp.
            While this is not ideal, at least it seems consistent from ticket to ticket.

            For now i think i'm done fiddling.
            I'd rather you were able to work on V2 of osTicket which all of us anxiously await!

            Again, thanks for all your attention to this issue.

            Best regards,
            michael grimes

              _SAmiC

              Ah, so the way your system is setup (and since you can't change it) you should look here and use the highlighted line. Comment out the lines above it so it always uses the @@global.system_time_zone variable in your system. Then set your system and profile timezones back to normal and everything should be good.

              function db_timezone() {
    //$timezone = db_get_variable('time_zone', 'global');
    //if ($timezone == 'SYSTEM')
        $timezone = db_get_variable('system_time_zone', 'global');

    return $timezone;
}

              Cheers.

                Write a Reply...