Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [timezone]

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

0
votes
0answers
11 views

Is there such a thing as a pre-loaded timezone field? So can drop down for user timezone?

I would like this list to display this format: PDT – Pacific Daylight Time / Pacific Daylight Saving Time I there an extension for this or I have to fetch the data and add a custom field and ...
0
votes
0answers
23 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
111 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
30 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
288 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 ...
2
votes
1answer
241 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
66 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
177 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
255 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
99 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
309 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
110 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
174 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
62 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
57 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 ...
1
vote
0answers
487 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
171 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 "...
4
votes
5answers
536 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
80 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
108 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
37 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
279 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
489 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
753 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.