Answers.Body: <p>It runs these two sets of queries. You could try them manually and see what happens:</p>
  <p><code>SELECT CONVERT_TZ(&quot;2001-02-03 04:05:00&quot;, &quot;GMT&quot;, &quot;America/New_York&quot;);</code></p>
  <pre><code>SET @@time_zone = &quot;Europe/Berlin&quot;;
  SELECT FROM_UNIXTIME(981176700);
  </code></pre>
  <p><a href="https://github.com/civicrm/civicrm-core/blob/7e1617778fbaf1858aae25ca7511079024e7fa83/CRM/Utils/Check/Component/Timestamps.php" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/blob/7e1617778fbaf1858aae25ca7511079024e7fa83/CRM/Utils/Check/Component/Timestamps.php</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-06-23T17:08:28.820Z
Answers.LastActivityDate: 2024-06-23T17:08:28.820Z
Answers.UserDisplayName: Demerit
Body: <p>I look after a number of CiviCRM implementations. Some of them display the System Status alert  about &quot;MySQL Timezone Problem&quot;, and advise that timezone data needs to be loaded.</p>
  <p>However when I raise this issue with my system administrator they confirm that timezone data has been loaded as described in the linked MySQL server documentation at <a href="https://dev.mysql.com/doc/refman/8.0/en/mysql-tzinfo-to-sql.html" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/8.0/en/mysql-tzinfo-to-sql.html</a>.</p>
  <p>Presumably CiviCRM is running some sort of check to see whether the System Status alert should be displayed or not. Is this check reliable or is it prone to false positives? Why is it getting displayed on some of my CiviCRM installs (not all), when my sysadmin reports that timezone data is loaded on every server that we are using.</p>
  <p>We run MariaDB on Debian.</p>
  
Tags: <mysql><timezone>
Title: "MySQL Timezone Problem" Status alert: what test is run to display this alert?
ThreadText: # "MySQL Timezone Problem" Status alert: what test is run to display this alert?
  
  (Asked by: username_0 on 2024-06-22)
  
  I look after a number of CiviCRM implementations. Some of them display the System Status alert about "MySQL Timezone Problem", and advise that timezone data needs to be loaded.
  
  However when I raise this issue with my system administrator they confirm that timezone data has been loaded as described in the linked MySQL server documentation at <https://dev.mysql.com/doc/refman/8.0/en/mysql-tzinfo-to-sql.html>.
  
  Presumably CiviCRM is running some sort of check to see whether the System Status alert should be displayed or not. Is this check reliable or is it prone to false positives? Why is it getting displayed on some of my CiviCRM installs (not all), when my sysadmin reports that timezone data is loaded on every server that we are using.
  
  We run MariaDB on Debian.
  
  **Tags:** mysql, timezone
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2024-06-23. Score: 2
  
  It runs these two sets of queries. You could try them manually and see what happens:
  SELECT CONVERT_TZ("2001-02-03 04:05:00", "GMT", "America/New_York");
  SET @@time_zone = "Europe/Berlin";
  SELECT FROM_UNIXTIME(981176700);
  
  https://github.com/civicrm/civicrm-core/blob/7e1617778fbaf1858aae25ca7511079024e7fa83/CRM/Utils/Check/Component/Timestamps.php
  
  
  ---
  
  