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

Prevent extensions from passing invalid MySQL dates on install

          Details

          • Type: Bug
          • Status: Open
          • Priority: Important
          • Resolution: Unresolved
          • Affects Version/s: 4.7.17
          • Fix Version/s: None
          • Component/s: None
          • Labels:
            None
          • Versioning Impact:
            Patch (backwards-compatible bug fixes)
          • Documentation Required?:
            None
          • Funding Source:
            Needs Funding
          • Verified?:
            No

            Description

            The CiviVolunteer, CiviHR and Mailchimp extensions appear to have been hit by a bug where we pass 0000-00-00 00:00:00 like dates to mysql.

            https://civicrm.stackexchange.com/questions/15539/civihr-hrbank-incorrect-datetime-value-0-for-column-created-date/18931#18931

            https://github.com/veda-consulting/uk.co.vedaconsulting.mailchimp/issues/269

            https://issues.civicrm.org/jira/browse/VOL-299

            The NO_ZERO_DATE work around has been suggested a few times but it feels a little short sighted.

            We can do case by case fixes like https://github.com/veda-consulting/uk.co.vedaconsulting.mailchimp/issues/279 but I would have thought a global solution that catches all instances of the bug would be welcomed.

            I tested this on 4.7.16 and searched the issue queue. Apologies if I missed a fix in a later version.

              Attachments

                Activity

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    michaelmcandrew Michael McAndrew
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated: