Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
How to sync server and database timezones please?
Hi, I would like to get some help with servers and databases timezones issue please.
My localhost server timezone is UTC,
and I have set the Timezone setting in TXP preferences to Tokyo.
My live server timezone is America/Chicago,
and I have set the Timezone setting in TXP preferences to Tokyo.
By them being different it is causing wrong publishing times for articles.
I have create a php.ini file with the following line of code: date.timezone = "UTC" and uploaded it to the live server.
Now in the TXP diagnostics page is says that the live server timezone is UTC,
but the actual timezone GMT offset in seconds is different and not the right one as in my localhost.
Also the databases times are different, how can I solve this issue please?
local:
Server timezone: UTC
Server local time: 2020-11-26 10:48:23
Daylight Saving Time enabled?: 0
Automatically adjust Daylight Saving Time setting?: 0
Time zone (GMT offset in seconds): Asia/Tokyo (7200)
MySQL: 8.0.18 (MySQL Community Server – GPL)
Database server time: 2020-11-26 12:48:23
Database server time offset: 0 s
Database server timezone: SYSTEM
Database session timezone: SYSTEM
live:
Server timezone: UTC
Server local time: 2020-11-26 10:48:53
Daylight Saving Time enabled?: 0
Automatically adjust Daylight Saving Time setting?: 0
Time zone (GMT offset in seconds): Asia/Tokyo (32400)
MySQL: 5.6.41-84.1 (Percona Server (GPL), Release 84.1, Revision b308619)
Database server time: 2020-11-26 04:48:53
Database server time offset: 0 s
Database server timezone: SYSTEM
Database session timezone: SYSTEM
Offline
Re: How to sync server and database timezones please?
For a workaround I ended up using SQL queries to reduce 8 hours from the posted and expires times.
update textpattern
set Posted = Posted - interval 8 hour;update textpattern
set Expires = Expires - interval 8 hour;Offline