Answers.Body: <p>Some examples:</p>
  <ul>
  <li>To properly implement CiviEvent timezone support, the zones will need to be loaded. But since CiviEvent doesn't support timezones now then as a practical matter it's mostly that you won't be able to take advantage of any improvements there.</li>
  <li>Similarly activity datetimes don't currently support timezones.</li>
  <li>If you currently use trigger-based logging, you'll notice that dates on the other side of DST are off by an hour when looking at the contact changelog. The zones will fix that.</li>
  <li>There are some issues with the newer queue features.</li>
  </ul>
  <p>It might be useful to know which hosting so we can update the survey at <a href="https://docs.civicrm.org/installation/en/latest/general/requirements/#mysql-timezones" rel="nofollow noreferrer">https://docs.civicrm.org/installation/en/latest/general/requirements/#mysql-timezones</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-02-14T20:33:03.813Z
Answers.Text: It's ecowebhosting.co.uk,  I've just confirmed with their support that they can't/won't support it.
Answers.UserDisplayName: RobotToaster
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-02-09T02:00:20.977Z
Answers.LastActivityDate: 2023-02-09T02:00:20.977Z
Answers.UserDisplayName: Demerit
Body: <p>I recently installed CiviCRM 5.58.0 on wordpress, but under system status I am getting a warning that says:</p>
  <blockquote>
  <p>The MySQL database does not fully support timezones. Please ask the
  database administrator to load timezone data.</p>
  </blockquote>
  <p>Unfortunately we are on shared hosting so I can't load the timezone data myself.</p>
  <p>What sort of issues (if any) will we have from this?</p>
  <p>Thanks in advance.</p>
  
Tags: <database><mysql><timezone>
Title: What issues are there when running with a database that "does not fully support timezones"
ThreadText: # What issues are there when running with a database that "does not fully support timezones"
  
  (Asked by: username_0 on 2023-02-08)
  
  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 to load timezone data.
  
  Unfortunately we are on shared hosting so I can't load the timezone data myself.
  
  What sort of issues (if any) will we have from this?
  
  Thanks in advance.
  
  **Tags:** database, mysql, timezone
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2023-02-09. Score: 1 | Accepted answer
  
  Some examples:
  
  * To properly implement CiviEvent timezone support, the zones will need to be loaded. But since CiviEvent doesn't support timezones now then as a practical matter it's mostly that you won't be able to take advantage of any improvements there.
  * Similarly activity datetimes don't currently support timezones.
  * If you currently use trigger-based logging, you'll notice that dates on the other side of DST are off by an hour when looking at the contact changelog. The zones will fix that.
  * There are some issues with the newer queue features.
  
  It might be useful to know which hosting so we can update the survey at <https://docs.civicrm.org/installation/en/latest/general/requirements/#mysql-timezones>
  
  > **Comments:**
  > **username_0**: It's ecowebhosting.co.uk,  I've just confirmed with their support that they can't/won't support it.  
  
  ---
  
  