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

Search Builder fails in an internationalised environment

    Details

    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Needs Funding
    • Verified?:
      No

      Description

      In an international environment, i.e. one whose base language is not en_US, the title and description columns in tables are in the form  title_ll_CC, where ll is the language and CC is the country.  So, for example civicrm_option_group has the following relevant columns in the en_GB environment.

      title_en_GB
      description_en_GB

      /administrator/components/com_civicrm/civicrm/CRM/Core/BAO/OptionGroup.php(197): CRM_Core_BAO_OptionGroup::getTitlesByNames() is, I think, returning name and title, not name and title_en_GB, so the subsequent query fails with unknown column.

      I intend to investigate further, but this is just to flag the issue.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              spalmstr Stephen Palmstrom
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: