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

Use insert IGNORE when adding states

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.5
    • Fix Version/s: 4.5
    • Component/s: None
    • Labels:
      None

      Description

      this is a follow up on CRM-14755. We had some discussion around using INSERT IGNORE rather than INSERT when adding countries & states because organisations sometimes add these themselves (e.g some organisations added South Sudan to their database the day it was created).

      So, given that we agreed it made sense that upgrades should not fail because organisations have edited their own states & countries - how do we get future commits to respect that - I see in alpha 2 upgrade

      CRM-14843 Added States for Chile and Modify Santiago Metropolitan for consistency
      INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
      (NULL, 1044, "LR", "Los Rios"),
      (NULL, 1044, "AP", "Arica y Parinacota");

      Would communicating to a list of people mean that multiple people are watching for it ? Planning list?

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                dgg David Greenberg
                Reporter:
                eileen Eileen McNaughton
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: