[solved] Database time vs PHP time

[psy]

First time I've ever encountered this warning message and unsure how to resolve.

Scenario:

1. Customer is a long-time PW client in Australia who is moving to the UK.
2. The web host created a new account hosted in Germany and copied all the AU files and DB to the new hosting account/location, Germany being their closest hosting centre to the UK.
3. Time diff between Germany and UK is 1hr
4. Time diff between Australia and Germany is 10hrs
5. Site is working with new URL, etc
6. The new PHP time zone needs to be "Europe/London" and $config->timezone is set to same

Times are important as the client will be taking online appointment bookings.

How do I match the DB time to the new UK time zone?

Solution:

In 'site/config.php' immediately after the database connection info:

$config->dbInitCommand = "SET NAMES '{charset}', time_zone = 'Europe/London' ";

Where {charset} can be utf8 or utf8mb4 depending on your setup

[bernhard]

This is how you can set the DB timezone: https://stackoverflow.com/questions/930900/how-do-i-set-the-time-zone-of-mysql

If you don't have access to that talk to your hosting provider.

[Marty Walker]

I just wanted to add something for anyone who searches and lands here.

With the host I'm on, even if the PHP timezone is set to (in my case) 'Australia/Sydney' and the PW installer matches that, the dates are still out. The only way for me to install PW without modding the config each and every time is to set the PW installer to UTC. I don't know if this is the right or wrong way to go about it but it seems to work.

[JamesFletcher]

Thanks! I’ll update MySQL timezone, appreciate the clear guidance!