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

Luxembourg needs another province, also called Luxembourg

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.2.0
    • Fix Version/s: 4.3.0
    • Component/s: Core CiviCRM
    • Labels:

      Description

      A new entry in the civicrm_state_province table is need : Luxembourg

      According to one of our users, and also wikipedia:
      http://en.wikipedia.org/wiki/Luxembourg

      Luxembourg District is one of the three Disctricts of Luxembourg (the country).

      Don't confuse this with another Luxembourg province, which is a province of Belgium.

      Around line 1227 on the sql/civicrm_generated.mysql file , for new installs.

      Maybe needs to be added to an upgrade script to, but we should just make sure that if someone has already added it to the database, it doesn't get re-added!
      Luxembourg the country is country_id = 1126
      the other provinces :Diekirch and GreveNmacher are abbrevieations D and G
      so maybe Luxembourg should be L

      I hope this is enough info.

        Attachments

          Activity

            People

            • Assignee:
              pratik.joshi Pratik Joshi
              Reporter:
              jimurl Jim Earl
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: