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

The search by state_province in Brazil not function properly if the state option is "Bahia" or "Tocantins"

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.0, 3.0.1, 3.0.2, 3.0.3, 3.0.4, 3.1, 3.1.1, 3.1.2, 3.1.3, 3.1.4, 3.1.5, 3.1.6
    • Fix Version/s: 3.2.1
    • Component/s: CiviCRM Search
    • Labels:
      None

      Description

      If you want to select for example individuals from database and select them by state, if their states are "Bahia" or "Tocantins" it will return an error.
      Checking the database I found that in table civicrm_state_province the names are mispelled,
      "Bahia" is spelt "Baia" - id 1921 and "Tocantins" are spelt "Tocatins" - id 1944.
      I corrected it on my database but I suggest you correct it on next versions of civicrm.
      Hugs,

        Attachments

        1. bug.png
          156 kB
          Decio Fabio de Oliveira Junior

          Activity

            People

            • Assignee:
              shot Piotr Szotkowski
              Reporter:
              deciofabio Decio Fabio de Oliveira Junior
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 30 minutes
                30m
                Remaining:
                Remaining Estimate - 30 minutes
                30m
                Logged:
                Time Spent - Not Specified
                Not Specified