Questions tagged [timezone]

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

Filter by
Sorted by
Tagged with
0 votes
2 answers
43 views

How do time zones work with CiviCRM?

I am using EventICS and some event registrants are reporting that the calendar item they get is for the wrong time, but when they forward to us, its correct, so we think its an issue with time zones. ...
user avatar
  • 3,222
0 votes
1 answer
77 views

API exception message after upgrade to CiviCRM 5.48.0

After a 'successful' upgrade to 5.48.0 there is an alert and System Status message: Event timezone check failed API Exception: Invalid field 'event_tz' while checking events for timezones. No other ...
user avatar
  • 533
0 votes
1 answer
22 views

"Cron not running" message, but definitely is

There are a lot of questions here on the message "Cron not running", but I have failed to find one that actually describes how CiviCRM keeps track of this, which might help explaining what ...
user avatar
  • 958
2 votes
2 answers
114 views

Event times not stored in UTC in 5.47

Just upgraded to CiviCRM 5.47 on WordPress, and some of my plugins are now displaying the incorrect time because they don't know how to interpret the start_date or end_date of an event. My server has ...
user avatar
  • 21
3 votes
3 answers
74 views

Wrong time after 5.47 update

After the 5.47 update, event time is displaying wrong values in CiviCRM. Stored in the DB / this is correct The stored timezone is Europe/Zurich / also correct In lists in the backend and in the ...
user avatar
  • 382
2 votes
1 answer
69 views

Event time zone field not showing in entry form

The event time zone field (new in CiviCRM 5.47) doesn't show up in the "new event" form. Impossible to store a new event to the DB, as the event time zone entry is mandatory. Joomla 3.10.6 / ...
user avatar
  • 382
0 votes
0 answers
17 views

Can Scheduled Jobs time out?

I have set up a few Scheduled Jobs that have started successfully started, but never finished. Is this due to a "time out" configuration? I would like to support some long running jobs.
user avatar
  • 355
0 votes
0 answers
15 views

How should I configure default time zones for Wordpress, CiviCRM, PHP, and MySQL?

Wordpress's time zone is set to "New York", PHP is set to "UTF", and MySQL is set to a UK time zone. Is the proper configuration to set each of these to "New York", or ...
user avatar
  • 355
1 vote
2 answers
32 views

CiviMobile local timezone

When I create activities etc. on CiviMobile in my Time Zone I am in it displays as 9 hours later. Currently I am -7 GMT and when setting an activity on the app it automatically changes it to +2 GMT (...
user avatar
  • 11
1 vote
1 answer
56 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:...
user avatar
1 vote
1 answer
34 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/...
user avatar
  • 31
5 votes
1 answer
88 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.
user avatar
  • 1,685
0 votes
0 answers
32 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 ...
user avatar
3 votes
1 answer
512 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 ...
user avatar
0 votes
0 answers
82 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? ...
user avatar
  • 499
1 vote
1 answer
617 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 ...
user avatar
3 votes
1 answer
716 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 ...
user avatar
  • 1,103
7 votes
2 answers
131 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. ...
user avatar
1 vote
0 answers
220 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 ...
user avatar
2 votes
3 answers
405 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") ...
user avatar
  • 123
0 votes
1 answer
118 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() ...
user avatar
  • 13
1 vote
1 answer
465 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/...
user avatar
  • 1,116
1 vote
0 answers
166 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/...
user avatar
  • 447
5 votes
1 answer
551 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 ...
user avatar
  • 351
6 votes
1 answer
76 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 ...
user avatar
  • 27.2k
3 votes
2 answers
62 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 ...
user avatar
2 votes
0 answers
753 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 ...
user avatar
3 votes
1 answer
305 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 "...
user avatar
  • 248
5 votes
5 answers
805 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 ...
user avatar
3 votes
1 answer
103 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 ...
user avatar
  • 1,561
2 votes
1 answer
120 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 ...
user avatar
3 votes
1 answer
45 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 ...
user avatar
5 votes
1 answer
308 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, ...
user avatar
3 votes
1 answer
604 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 ...
user avatar
5 votes
2 answers
946 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.
user avatar