CiviCRM Stack Exchange is a question and answer site for administrators and users of the CiviCRM Constituent Relationship Management software. It only takes a minute to sign up.
Sign up to join this community
Facing this warning Timestamps reported by MySQL (eg "2017-07-20 13:48") and PHP (eg "2017-07-20 08:18" ) are mismatched.
While MySql time matches with my local time. PHP is running 5:30 hrs less. My timezone is UTC+5:30 hrs.
Tried below options,
Didnt seem to work. What else I need to try?
Try setting your preferred timezone in civicrm.settings.php and/or wp-config.php?
ini_set('date.timezone', 'Asia/Calcutta');
You might want to adapt the timezone you set as appropriate to your MySQL server.
mysql -e 'SELECT @@system_time_zone;'
I believe India does not observe daylight savings? For that and similar reasons it's probably better to match the timezones in both systems. If MySQL is set to UTC offset, use that for PHP, and if MySQL is set to a regional timezone, follow suit.
