We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [timezone]

Questions relating to how CiviCRM handles date and time in different timezones.

Filter by
Sorted by
Tagged with
1
vote
1answer
35 views

Timezone issue - authenticated vs anonymous: a 6h time warp

When I'm logged in -> and make a Contribution at 4:20pm - all is well! I log out and then make a Contribution through the exact same Contribution page and notice that the Contribution clocks in at 10:...
1
vote
1answer
14 views

CiviCRM Scheduled Jobs Timezone Confusion

I am running a CiviCRM deployment in a GNU\Linux environment. When comparing the times reported by https://example.com/civicrm/admin/job (Settings - Scheduled Jobs) with https://example.com/civicrm/...
5
votes
1answer
54 views

Why do click and open reports show times in UTC rather than the site's timezone?

The mailing and click tracking reports are showing times in UTC. There is no PHP MySQL timezone mismatch - and mysql -e 'select now()' and date return the right times - as per timezone.
0
votes
0answers
29 views

How to create a dynamic timezone field for both display and input?

I have customers all over the world. Is it possible to have a field where you enter the timezone? Let's say Eastern Standard Time, I enter 8:pm, I'm in Thailand. So the field would display ...
3
votes
1answer
255 views

timestamp mismatch

I have a host running in a different time-zone from where I am operation and unless I set the website time zone to the hosting time zone I get the following error in CiviCRM: Timestamps reported by ...
0
votes
0answers
45 views

Displaying Time Zone on Event pages

I am using Civi 4.7.29 on Wordpress 4.9.4 Currently CiviEvent pages display the date and the time in the format you see in the screen shot. How are people supposed to know what time zone that is in? ...
1
vote
1answer
503 views

timezone in PHP is incorrect

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 ...
3
votes
1answer
324 views

Error: DateTimeZone::__construct: Unknown or bad timezone (7200)

I'm getting error "Error: DateTimeZone::__construct: Unknown or bad timezone (7200)" when opening CiviCRM on my Drupal6 site. Refreshing the page clears the error. The error occurred after I upgraded ...
7
votes
2answers
76 views

How do I create CiviEvents that occur in different timezones?

Our site will be host to many different events. Some will happen in meatspace and others online. However, they will all have participants from different timezones or be based in different timezones. ...
1
vote
0answers
192 views

CiviCRM Scheduled Mailing Timezone issue

We are facing an issue with timezone after upgrading CiviCRM to 4.6.14 from 4.5.8. Our CMS is Drupal 7.43. It seems if an admin sets a scheduled mail to be sent immediately, then the scheduled date ...
2
votes
3answers
305 views

Environment Settings, mismatch timezone

I have just done a new install of WordPress and CiviCRM, it has displayed this warning when looking at the CiviCRM dashboard: Environment Settings Timestamps reported by MySQL (eg "2016-03-22 14:45") ...
0
votes
1answer
107 views

Joomla timezone mismatch

For some reason Civi is using UTC and not the Joomla time. The system, and php and mysql times are reporting correctly (Brisbane) . For Mysql I have run the following to get its time; SELECT NOW() ...
1
vote
1answer
373 views

WP-CLI using GMT/UTC Timezone on cron jobs

Not sure what exactly broke, but upgrading to CiviCRM 4.7.1 on CentOS 6 required adding PHP 5.4 via the SCL repo. Something in that process broke the cURL/wget/php cron job calls. (Invalid username/...
1
vote
0answers
131 views

Timezone not correct even after setting php.ini

Timezone difference cause my civicrm site showing wrong membership date. For example: Payment Date: Today 10am Membership start date: Yesterday I made below timezone setting in drupal (admin/...
5
votes
1answer
228 views

How are timezones handled in CiviCRM?

We were running into issues with how CiviCRM activities are showing in Drupal Calendar (Views). Drupal is adjusting the provided activity date/time based on the user configured time zone. For us, this ...
6
votes
1answer
68 views

CiviMail scheduling problem due to timezone issues

i have a mailing that looks like it has been caught out due to timezone issues. The person who set it up was in NZ, but moved to Europe but didn't change their timezone. Looks like the Mailing got the ...
3
votes
2answers
59 views

1 hour discrepancy between created_date field in MySQL and CiviCRM report output

I hope I have a strange, but straight forward issue -- there's a 1 hour offset SOMETIMES in the created_date field in civicrm_contact table, and what gets outputted in a CiviCRM report (see the ...
2
votes
0answers
594 views

Does the 'timestamp mismatch' error cause any real problems?

I am getting the following error when I log in to CiviCRM: Timestamps reported by MySQL (eg "2015-11-06 13:44") and PHP (eg "2015-11-06 11:44" ) are mismatched. I have reported this separately ...
3
votes
1answer
199 views

Event Time Zone

My org has events that are often hosted online and participants who register to attend these events live all over the United States. When we create events we make sure to list the timezone in the "...
5
votes
5answers
609 views

Timestamp mismatch between MySQL and PHP

Every time I log in to CiviCRM I get the following error message: Timestamps reported by MySQL (eg "2015-11-06 13:44") and PHP (eg "2015-11-06 11:44" ) are mismatched. I am using CiviCRM 4.6.10 ...
3
votes
1answer
89 views

What timezones should we use on the server and database?

We run a Civicrm installation that spans a continent (a long way from UTC). What is the best practice? What time should our server be set to? How do we manage user timezones? What time should go ...
2
votes
1answer
115 views

email links not working - date.timezone function

I have used my CiviCRM email for many years. Today I had the following error message when I sent an email with links in it clicking through to an event on an external site. I have resolved the problem ...
3
votes
1answer
39 views

How do I get the time in the change log to be the same as my local time?

I am working with CiviCRM in a Joomla environment. The Joomla server time is set for UTC and can verify changes to articles are logged at the correct time. However changes made to CiviCRM consituent ...
5
votes
1answer
287 views

How do I correct mismatched Timestamps for MySQL and PHP without access to server?

I'm using civiCRM 4.6.2 under Wordpress. The PHP and MySQL timezone settings are reported as incompatible, MySQL as 12:38 (which is the current clock time here in Zurich) and PHP as 10:38. However, ...
3
votes
1answer
520 views

Why is CiviCRM not seeing the timezone correctly?

I have been unable to get the CiviCRM warning about timezone settings corrected after this just past daylight savings transition. Usually I would correct it by changing the timezone setting of the ...
5
votes
2answers
804 views

How do I set the time zones in order to correct mismatched Timestamps for MySQL and PHP?

I currently have a warning on Environment settings. Timestamps reported by MySQL and PHP are mismatched.