CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • After upgrade, Civi complains about timezone
Pages: [1]

Author Topic: After upgrade, Civi complains about timezone  (Read 1881 times)

CityBloc

  • I post occasionally
  • **
  • Posts: 38
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: WordPress 3.9.2
  • MySQL version: 5.5.37
  • PHP version: 5.3.10
After upgrade, Civi complains about timezone
April 21, 2014, 01:24:28 pm
After I upgraded from 4.4 to 4.5, Civi complained about timezone being wrong

"Timestamps reported by MySQL (eg "2014-04-21 14:50") and PHP (eg "2014-04-21 19:50" ) are mismatched."

I fixed this by noticing that WP's time zone was wrong, but only after chasing around inside PHP, where phpinfo() was reporting the correct timezone.

So: is the above warning message in need of an update to include mentioning that host application time might also be wrong?




pcoutas

  • I’m new here
  • *
  • Posts: 27
  • Karma: 0
  • CiviCRM version: 4.4.5
  • CMS version: WordPress 3.9.1
  • MySQL version: 5.5.32
Re: After upgrade, Civi complains about timezone
May 12, 2014, 04:09:35 pm
We're having the same problem too -

http://forum.civicrm.org/index.php/topic,32549.0.html

But my WP install is on the same timezone as MySQL - seems like CiviCRM is doing its own thing. I have no idea how to correct it. Ideas? The help files helpfully suggest turning "automatic sync" on but I don't know where to find it (CiviCRM? WP? MySQL?)

CityBloc

  • I post occasionally
  • **
  • Posts: 38
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: WordPress 3.9.2
  • MySQL version: 5.5.37
  • PHP version: 5.3.10
Re: After upgrade, Civi complains about timezone
May 12, 2014, 05:37:38 pm
Long story short, WP ignores the timezone from the server and from PHP.  An administrative WP user has to set the time zone explicitly under Settings > General.

Sorry I didn't update this thread sooner.  Good luck!

pcoutas

  • I’m new here
  • *
  • Posts: 27
  • Karma: 0
  • CiviCRM version: 4.4.5
  • CMS version: WordPress 3.9.1
  • MySQL version: 5.5.32
Re: After upgrade, Civi complains about timezone
May 12, 2014, 06:59:00 pm
Yup, I've done that - there's still a mismatch between the two. My WP and Server are on UTC/GMT + 8 but CiviCRM is not.

questions

  • I post occasionally
  • **
  • Posts: 79
  • Karma: 2
  • CiviCRM version: 4.4.6
  • CMS version: Durpal, 7
  • MySQL version: 5.1
  • PHP version: 5.3
Re: After upgrade, Civi complains about timezone
May 15, 2014, 09:09:24 am
Maybe I should create a new issue.  I'm getting the same error after upgrading our test instance from 4.3.5 to 4.4.5 but the time difference is only 4 minutes.

Timestamps reported by MySQL (eg "2014-05-15 08:58") and PHP (eg "2014-05-15 08:54" ) are mismatched.

MySQL time is fast by not quite 4 mins.   I think the php time matches system time; though, I haven't a clue how to get it to give me back php time.   (My background is sql)

I'm guessing this check is new since I see the same mysql time difference on the unupgraded production instance (4.3.5).



questions

  • I post occasionally
  • **
  • Posts: 79
  • Karma: 2
  • CiviCRM version: 4.4.6
  • CMS version: Durpal, 7
  • MySQL version: 5.1
  • PHP version: 5.3
Re: After upgrade, Civi complains about timezone
May 15, 2014, 09:44:32 am
Hmm, we are running on Dreamhost and I believe the mysql doesn't really run on the same box as the php even though it feels like it.  I'll have to bug dreamhost or figure out the sync php sql stuff.

JoeMurray

  • Administrator
  • Ask me questions
  • *****
  • Posts: 578
  • Karma: 24
    • JMA Consulting
  • CiviCRM version: 4.4 and 4.5 (as of Nov 2014)
  • CMS version: Drupal, WordPress, Joomla
  • MySQL version: MySQL 5.5, 5.6, MariaDB 10.0 (as of Nov 2014)
Re: After upgrade, Civi complains about timezone
May 18, 2014, 11:02:12 am
Agreed that a) Dreamhost runs MySQL on a different server and b) being out by 4 minutes between PHP and MySQL would only happen in a case like that.
Co-author of Using CiviCRM https://www.packtpub.com/using-civicrm/book
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • After upgrade, Civi complains about timezone

This forum was archived on 2017-11-26.