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 »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Timestamp Mismatch
Pages: [1]

Author Topic: Timestamp Mismatch  (Read 808 times)

penguintrax

  • I post frequently
  • ***
  • Posts: 230
  • Karma: 2
  • CiviCRM version: 3.3x and 4.x depending on site
  • CMS version: Joomla 1.5 or 1.7 depending on site
  • MySQL version: 5.0.92-community
  • PHP version: 5.2.17
Timestamp Mismatch
February 02, 2015, 08:34:33 am
I'm getting this error on several installs of CiviCRM (Wordpress Joomla 2.5x, Joomla 3.x).
According to my server manager, PHP and MySQL timezones are identical and correct on the affected servers.
Joomla/Wordpress timezones are correct.
PHP.ini is set to America/New York per http://forum.civicrm.org/index.php/topic,34055.msg144395.html#msg144395

On two servers the offset is only an hour, but on another one it's 5 hours.

I'm guessing that this mismatch is what is causing all (free) memberships to be entered as pending instead of completed on one of the sites?

I don't know where else to look for a cause and could use a push in the right direction.

Thanks!



Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Timestamp Mismatch
February 03, 2015, 05:19:54 am
Do your CMS, PHP and MySQL all have "America/New York" as the time zone?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

penguintrax

  • I post frequently
  • ***
  • Posts: 230
  • Karma: 2
  • CiviCRM version: 3.3x and 4.x depending on site
  • CMS version: Joomla 1.5 or 1.7 depending on site
  • MySQL version: 5.0.92-community
  • PHP version: 5.2.17
Re: Timestamp Mismatch
February 03, 2015, 08:02:11 am
Yes, they do. This is maddening.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Timestamp Mismatch
February 03, 2015, 11:36:41 am
You may have to find where this error is generated in the code and see what detection methods the code uses to determine these time zones. My guess is that your server configuration is different than others and so one of these detection methods is sending the wrong answer.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

penguintrax

  • I post frequently
  • ***
  • Posts: 230
  • Karma: 2
  • CiviCRM version: 3.3x and 4.x depending on site
  • CMS version: Joomla 1.5 or 1.7 depending on site
  • MySQL version: 5.0.92-community
  • PHP version: 5.2.17
Re: Timestamp Mismatch
February 03, 2015, 12:36:38 pm
I guess turning on debug and outputting to the screen or do you recommend another method?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Timestamp Mismatch
February 04, 2015, 02:46:01 am
I am suggesting you read the PHP code manually to see what checks are used to test for timestamp mismatch and then test each of those individually on your server.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

penguintrax

  • I post frequently
  • ***
  • Posts: 230
  • Karma: 2
  • CiviCRM version: 3.3x and 4.x depending on site
  • CMS version: Joomla 1.5 or 1.7 depending on site
  • MySQL version: 5.0.92-community
  • PHP version: 5.2.17
Re: Timestamp Mismatch
February 04, 2015, 08:03:20 am
Unfortunately, I wouldn't have a clue as to what files to check or what to look for once I found them. I'm not really a developer, although I can get by with most debugging scenarios and then have someone go in to fix them (or apply a provided patch).

Thank you very much - I'll have to see if we can find someone to go on a hunt for this. Our server manager confirmed that the server, php, and mysql timestamps match and i low the cms timezone is the same as well.

penguintrax

  • I post frequently
  • ***
  • Posts: 230
  • Karma: 2
  • CiviCRM version: 3.3x and 4.x depending on site
  • CMS version: Joomla 1.5 or 1.7 depending on site
  • MySQL version: 5.0.92-community
  • PHP version: 5.2.17
Re: Timestamp Mismatch
March 04, 2015, 01:14:54 pm
Update for you.

In digging around the PHP website, I found a list of timezones and their accurate syntax. I changed php.ini from America/New York to America/New_York (per the list) and the mismatch error went away. I had used the space because in another forum post, that was the syntax given.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Timestamp Mismatch

This forum was archived on 2017-11-26.