Questions tagged [timezone]
Questions relating to how CiviCRM handles date and time in different timezones.
36
questions
1
vote
1
answer
104
views
How can I resolve what seems to be a timezone-related error?
I am running CiviCRM 5.59.2 on Wordpress 6.2.
I am getting an occasional error in CiviCRM that I think has something to do with a timezone not being set correctly somewhere. In my Wordpress general ...
- 481
2
votes
1
answer
135
views
Repeatedly getting this error in CiviCRM WordPress version "1298 ** Unknown or incorrect time zone: 'Europe/Berlin'" - how do I fix this?
I've redacted the client name for privacy, but the following appears repeatedly in our CiviCRM error log. Can someone please help me with an explanation / solution? Thanks a bunch!
Feb 21 11:01:04 [...
- 53
1
vote
1
answer
198
views
What issues are there when running with a database that "does not fully support timezones"
I recently installed CiviCRM 5.58.0 on wordpress, but under system status I am getting a warning that says:
The MySQL database does not fully support timezones. Please ask the
database administrator ...
- 13
1
vote
2
answers
92
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. ...
- 3,352
0
votes
1
answer
148
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 ...
- 543
1
vote
2
answers
121
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 ...
- 1,231
2
votes
2
answers
138
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 ...
- 21
4
votes
3
answers
89
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 ...
- 422
2
votes
1
answer
88
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 / ...
- 422
1
vote
2
answers
34
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 (...
- 11
1
vote
1
answer
58
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:...
- 15.1k
1
vote
1
answer
38
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/...
- 31
5
votes
1
answer
92
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.
- 1,835
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 ...
- 368
3
votes
1
answer
557
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 ...
- 417
0
votes
0
answers
99
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? ...
- 285
1
vote
1
answer
650
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
1
answer
940
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 ...
- 1,114
7
votes
2
answers
137
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
0
answers
232
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 ...
- 11
2
votes
3
answers
420
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") ...
- 123
0
votes
1
answer
125
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() ...
- 13
1
vote
1
answer
485
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,146
1
vote
0
answers
170
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/...
- 447
6
votes
1
answer
712
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 ...
- 371
6
votes
1
answer
79
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 ...
- 28.1k
3
votes
2
answers
63
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 ...
- 571
3
votes
0
answers
795
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,314
3
votes
1
answer
325
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 "...
- 258
5
votes
5
answers
859
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,314
4
votes
1
answer
113
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 ...
- 1,571
2
votes
1
answer
122
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 ...
- 809
3
votes
1
answer
52
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
1
answer
312
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, ...
- 576
3
votes
1
answer
624
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 ...
- 307
5
votes
2
answers
964
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.
- 51