Facing Issue with Task due time

Subrahmanyam-avance

Hi Team i'm facing issue with Task due time setting

Subrahmanyam-avance

KevinTheJedi

Set your database timezone la to UTC (there are multiple timezone setting in MySQL). Once you do this make sure you have the system timezone and your profile timezone set accordingly. After all that you can retest.

Cheers.

Subrahmanyam-avance

Hi KevinTheJedi I changed mysql database time as well system time and osticket application default time but the task due date issue is still the same.

KevinTheJedi

Subrahmanyam-avance

Can you please list your MySQL time zones, PHP timezone, System Timezone, and Profile timezone?

Also please post a screenshot of Admin Panel > Dashboard > Information.

Cheers.

Subrahmanyam-avance

KevinTheJedi Sure

Please find above attachments

KevinTheJedi

Subrahmanyam-avance

You didn’t change your database timezone to UTC as I explained earlier. Please do so and retest.

Cheers.

Subrahmanyam-avance

Please check here once but still the same
Please don't mind guiding me step by step if possible

Thank you in advance

KevinTheJedi

Subrahmanyam-avance

That is quite strange. I had someone with this issue using Asia/Kolkata and we changed the database timezone to UTC (not +00:00) and that fixed it. Can you try maybe setting your PHP timezone to UTC as well? Also, share a screenshot of Admin Panel > Settings > System > Date and Time Options section.

Cheers.

Subrahmanyam-avance

I changed the database, PHP, and system time zones to UTC. but still same

Then I clicked Done it show's same 11:30 PM

Subrahmanyam-avance

KevinTheJedi

Subrahmanyam-avance

Do you have any browser extensions enabled? If so, can you please disable them and retest? Can you try a different browser altogether?

Can you please share a full screenshot of Admin Panel > Dashboard > Information?

Cheers.

Subrahmanyam-avance

I tried in Different browser also still same

KevinTheJedi

Subrahmanyam-avance

That is quite strange, I cannot replicate this. What does your Admin Panel > Settings > System > Date and Time Options section look like?

Cheers.

Subrahmanyam-avance

TonyO

I cant replicate it. The other places I would check, besides your profile:

In Admin Panel, Settings, Default TimeZone. This should be Asia/Kolkata

The server time config. On Ubuntu, execute "date" and make sure the server shows the correct time zone, +5:30.

On my system, php.ini timezone isn't set, which is the default. osTicket Information shows UTC.

In MySQL, SELECT @@global.time_zone returns 'SYSTEM'

Subrahmanyam-avance

TonyO

From the date command, the server has the wrong timezone. In this case, IST means Israel Standard Time (+2:00). If the times are 3:30 off, this is the cause.
Use the timedatectl command to set Ubuntu to your local timezone. For example, 'timedatectl set-timezone Asia/Kolkata'

Subrahmanyam-avance

TonyO

Subrahmanyam-avance
When you view a new ticket, how much is the discrepancy?

Subrahmanyam-avance

Hi TonyO Actually we are facing an issue with the task due time. we select some date and time then update. but It updates at different time