Answers.Body: <p>In the latest version, you can also rebuild the multilingual schema yourself by navigating to API Explorer <code>http://www.site-name/civicrm/api#explorer</code></p>
  
  <p>Select Entity = <code>System</code>, Action = <code>rebuildmultilingualschema</code> and click on Execute button.</p>
  
  <p><a href="https://i.sstatic.net/uVCg2.png" rel="noreferrer"><img src="https://i.sstatic.net/uVCg2.png" alt="enter image description here"></a></p>
  
  <p>If you aren't able to access the API explorer UI, try using the cv command from the terminal.</p>
  
  <pre><code>cv api System.rebuildmultilingualschema
  </code></pre>
  
  <p>Or using drush -</p>
  
  <pre><code>drush cvapi System.rebuildmultilingualschema
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-07-04T11:47:31.517Z
Answers.Text: Thanks, that is useful.  I'd read about it being possible, but it wasn't clear how one ran it.  But, shouldn't multilingual updates just work?
Answers.UserDisplayName: Stephen Palmstrom
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-07-04T13:50:21.397Z
Answers.Text: Agree multilingual should be handled during the update process. I use the above solution if it fails due to some unknown reason.
Answers.UserDisplayName: jitendra - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-07-04T17:22:04.290Z
Answers.Text: I found I could only get System -> rebuildmultilingualschema to work if I had first corrected the errors in the civicrm_uf_group view, so that is no solution to the upgrade issue.
Answers.UserDisplayName: Stephen Palmstrom
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-07-05T02:35:23.367Z
Answers.Text: Do you get any error while executing the above api OR the above page isn't loading for you? Can you paste any screenshot of the error in the description?
Answers.UserDisplayName: jitendra - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-07-06T08:50:01.840Z
Answers.Text: Basically, you just see System -> get and a rotating wheel waiting for the other actions to load after clicking on the down arrow that should bring up a list of actions
Answers.UserDisplayName: Stephen Palmstrom
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-07-06T09:50:24.403Z
Answers.Text: Updated the answer to use either `cv` or `drush`, if there is any problem on the API screen.
Answers.UserDisplayName: jitendra - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-07-07T11:07:45.147Z
Answers.Text: Presumably that only works in the Drupal environment under Linux? As aforesaid, multilingual upgrades should just work.
Answers.UserDisplayName: Stephen Palmstrom
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-07-18T18:19:41.233Z
Answers.Text: I think the way round this issue is that before you run the database upgrade process you compare …/CRM/Core/I18n/SchemaStructure.php with the last versioned example (SchemaStructure_x_y_z.php) and, if it is different create a new version (SchemaStructure_a_b_c.php) with class SchemaStructure_a_b_c if SchemaStructure.php is different.  I have tried this and it seems to solve the problem, so this could be an answer, but I should be grateful for comments.
Answers.UserDisplayName: Stephen Palmstrom
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-07-04T07:00:50.197Z
Answers.LastActivityDate: 2018-07-06T09:49:46.663Z
Answers.LastEditDate: 2018-07-06T09:49:46.663Z
Answers.UserDisplayName: jitendra - fuzion
Body: <p>I'm not sure if this is the forum where you want this issue raised, or whether Mattermost or a bug report is best, but here goes.  Please let me know if I should be raising this elsewhere.</p>
  
  <p>A recurring error after updating a multilingual site is 'no such field' for a number of fields.  It is still occurring after the 5.2.2 update, in particular in the civicrm_uf_group view, where the following fields are missing:</p>
  
  <ul>
  <li>frontend_title</li>
  <li>submit_button_text</li>
  <li>cancel_button_text</li>
  </ul>
  
  <p>Having got a bit fed up with errors like this occurring <em>every</em> update, it seemed, I have investigated further to discover the following:</p>
  
  <ol>
  <li>It seems that line 375 in CRM/Upgrade/Form.php
  should read </li>
  </ol>
  
  <p>CRM_Core_I18n_Schema::rebuildMultilingualSchema($this->locales, $rev, TRUE);
  not
  CRM_Core_I18n_Schema::rebuildMultilingualSchema($this->locales, $rev);</p>
  
  <p>to tell the function that we are doing an upgrade.</p>
  
  <ol start="2">
  <li>When the schema structure is updated, a file of the form 
  SchemaStructure_x_y_z.php should be included in CRM/Core/18n, as SchemaStructure.php doesn't appear to be called during the update/upgrade process.  That file should contain the class 18n_SchemaStructure_x_y_z</li>
  </ol>
  
  <p>The upgrade to 5.2.2 is giving 'no such field' errors because the latest schema structure file is Schematructure_4_7_alpha1.php, and so is the latest file to be called by the update process.</p>
  
  <p>Is this a correct analysis, or have I misunderstood something?</p>
  
Tags: <upgrade><localisation><i18n><multilingual>
Title: Multilingual instances show 'no such field' errors after update
ThreadText: # Multilingual instances show 'no such field' errors after update
  
  (Asked by: username_0 on 2018-07-03)
  
  I'm not sure if this is the forum where you want this issue raised, or whether Mattermost or a bug report is best, but here goes. Please let me know if I should be raising this elsewhere.
  
  A recurring error after updating a multilingual site is 'no such field' for a number of fields. It is still occurring after the 5.2.2 update, in particular in the civicrm\_uf\_group view, where the following fields are missing:
  
  * frontend\_title
  * submit\_button\_text
  * cancel\_button\_text
  
  Having got a bit fed up with errors like this occurring *every* update, it seemed, I have investigated further to discover the following:
  
  1. It seems that line 375 in CRM/Upgrade/Form.php
     should read
  
  CRM\_Core\_I18n\_Schema::rebuildMultilingualSchema($this->locales, $rev, TRUE);
  not
  CRM\_Core\_I18n\_Schema::rebuildMultilingualSchema($this->locales, $rev);
  
  to tell the function that we are doing an upgrade.
  
  2. When the schema structure is updated, a file of the form
     SchemaStructure\_x\_y\_z.php should be included in CRM/Core/18n, as SchemaStructure.php doesn't appear to be called during the update/upgrade process. That file should contain the class 18n\_SchemaStructure\_x\_y\_z
  
  The upgrade to 5.2.2 is giving 'no such field' errors because the latest schema structure file is Schematructure\_4\_7\_alpha1.php, and so is the latest file to be called by the update process.
  
  Is this a correct analysis, or have I misunderstood something?
  
  **Tags:** upgrade, localisation, i18n, multilingual
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2018-07-04. Score: 6
  
  In the latest version, you can also rebuild the multilingual schema yourself by navigating to API Explorer `http://www.site-name/civicrm/api#explorer`
  
  Select Entity = `System`, Action = `rebuildmultilingualschema` and click on Execute button.
  
  [![enter image description here](https://i.sstatic.net/uVCg2.png)](https://i.sstatic.net/uVCg2.png)
  
  If you aren't able to access the API explorer UI, try using the cv command from the terminal.
  
  ```
  cv api System.rebuildmultilingualschema
  
  ```
  
  Or using drush -
  
  ```
  drush cvapi System.rebuildmultilingualschema
  
  ```
  
  > **Comments:**
  > **username_0**: Thanks, that is useful.  I'd read about it being possible, but it wasn't clear how one ran it.  But, shouldn't multilingual updates just work?  
  > **username_1**: Agree multilingual should be handled during the update process. I use the above solution if it fails due to some unknown reason.  
  > **username_0**: I found I could only get System -> rebuildmultilingualschema to work if I had first corrected the errors in the civicrm_uf_group view, so that is no solution to the upgrade issue.  
  > **username_1**: Do you get any error while executing the above api OR the above page isn't loading for you? Can you paste any screenshot of the error in the description?  
  > **username_0**: Basically, you just see System -> get and a rotating wheel waiting for the other actions to load after clicking on the down arrow that should bring up a list of actions  
  > **username_1**: Updated the answer to use either `cv` or `drush`, if there is any problem on the API screen.  
  > **username_0**: Presumably that only works in the Drupal environment under Linux? As aforesaid, multilingual upgrades should just work.  
  > **username_0**: I think the way round this issue is that before you run the database upgrade process you compare …/CRM/Core/I18n/SchemaStructure.php with the last versioned example (SchemaStructure_x_y_z.php) and, if it is different create a new version (SchemaStructure_a_b_c.php) with class SchemaStructure_a_b_c if SchemaStructure.php is different.  I have tried this and it seems to solve the problem, so this could be an answer, but I should be grateful for comments.  
  
  ---
  
  