Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-14423

Misconfigured timezones lead to difficult debugging

          Details

          • Type: Bug
          • Status: Done/Fixed
          • Priority: Minor
          • Resolution: Fixed/Completed
          • Affects Version/s: 4.4.4
          • Fix Version/s: 4.6
          • Component/s: None
          • Labels:
            None
          • Documentation Required?:
            None

            Description

            Background: Some test results appeared different on my desktop (MAMP) and on the server (Debian/Ubuntu). After several hours of debugging, I found that the local MAMP had badly configured TZ defaults – PHP was hardcoded to Berlin time while MySQL was softcoded to system time.

            We should do one or all of the following:

            • Proactively, consistently manage TZ in MySQL (We currently do this for Drupal and sometimes for WordPress via CRM_Utils_System_Base::setMySQLTimeZone.)
            • Warn admins if their installation misbehaves
            • Warn test runners if their installation misbehaves

              Attachments

                Activity

                  People

                  • Assignee:
                    timotten Tim Otten
                    Reporter:
                    timotten Tim Otten
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: