Answers.Body: <p>In the file /CRM/Core/BAO/WordReplacement.php you've got this delightful stanza:</p>
  <pre><code>// So. Weird. Some bizarre/probably-broken multi-lingual thing where
  // data isn't really stored in civicrm_word_replacements. Probably
  // shouldn't exist.
  $stringOverride = self::_getLocaleCustomStrings($id);
  $stringOverride[$config-&gt;lcMessages] = $overrides;
  </code></pre>
  <p>And digging in, you'll see it does this:</p>
  <pre><code>$domain = CRM_Core_DAO::executeQuery('SELECT locale_custom_strings FROM civicrm_domain WHERE id = %1', [
    1 =&gt; [$domainId, 'Integer'],
  ]);
  </code></pre>
  <p>In other words, it's pulling word replacement information from a field in the civicrm_domain file which is no longer accessible or used in the UI.</p>
  <p>I looked in there and sure enough, I had an old collection of translations. By setting the field to empty, it solved the problem.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-10-02T20:38:51.663Z
Answers.Text: https://lab.civicrm.org/dev/core/-/issues/2085
Answers.UserDisplayName: Alan Dixon
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-10-02T20:26:52.503Z
Answers.LastActivityDate: 2020-10-02T20:26:52.503Z
Answers.UserDisplayName: Alan Dixon
Body: <p>My site is translating Yes to Si for French (fr_FR). I've confirmed that:</p>
  <ol>
  <li>I don't have any word replacments for Yes.</li>
  <li>Most everything else is translated correctly.</li>
  <li>I've got an up-to-date civicrm.po file for fr_FR and it contains the correct translation of &quot;Oui&quot;.</li>
  </ol>
  <p>I've even installed the brilliant de.systopia.l10nmo and org.civicrm.l10nx extensions and uploaded an override .mo file.</p>
  <p>WTF?</p>
  
Tags: <i18n>
Title: Why is CiviCRM mistranslating my string?
ThreadText: # Why is CiviCRM mistranslating my string?
  
  (Asked by: username_0 on 2020-10-02)
  
  My site is translating Yes to Si for French (fr\_FR). I've confirmed that:
  
  1. I don't have any word replacments for Yes.
  2. Most everything else is translated correctly.
  3. I've got an up-to-date civicrm.po file for fr\_FR and it contains the correct translation of "Oui".
  
  I've even installed the brilliant de.systopia.l10nmo and org.civicrm.l10nx extensions and uploaded an override .mo file.
  
  WTF?
  
  **Tags:** i18n
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2020-10-02. Score: 1
  
  In the file /CRM/Core/BAO/WordReplacement.php you've got this delightful stanza:
  
  ```
  // So. Weird. Some bizarre/probably-broken multi-lingual thing where
  // data isn't really stored in civicrm_word_replacements. Probably
  // shouldn't exist.
  $stringOverride = self::_getLocaleCustomStrings($id);
  $stringOverride[$config->lcMessages] = $overrides;
  
  ```
  
  And digging in, you'll see it does this:
  
  ```
  $domain = CRM_Core_DAO::executeQuery('SELECT locale_custom_strings FROM civicrm_domain WHERE id = %1', [
    1 => [$domainId, 'Integer'],
  ]);
  
  ```
  
  In other words, it's pulling word replacement information from a field in the civicrm\_domain file which is no longer accessible or used in the UI.
  
  I looked in there and sure enough, I had an old collection of translations. By setting the field to empty, it solved the problem.
  
  > **Comments:**
  > **username_0**: https://lab.civicrm.org/dev/core/-/issues/2085  
  
  ---
  
  