Answers.Body: <p>If you interrupt the process while CiviCRM is creating the multilingual mode, you could have a corrupted database.</p>
  
  <p>If you don't have access to civicrm anymore, the best way is to reload a backup of the database as mentionned by <a href="https://civicrm.stackexchange.com/users/26/laryn">Laryn</a>.</p>
  
  <p>If you don't have any backup, i guess you could try reset the database to a monolingual by calling the function :</p>
  
  <pre><code>CRM_Core_I18n_Schema::makeSinglelingual($locale_to_keep)
  </code></pre>
  
  <p>with <code>$locale_to_keep = 'en_US'</code> or <code>'fr_CA'</code>...</p>
  
  <p>You need to build a standalone script for this. </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-08T15:25:41.680Z
Answers.LastActivityDate: 2015-05-08T15:25:41.680Z
Answers.LastEditDate: 2017-04-13T12:53:13.167Z
Answers.UserDisplayName: samuelsov
Body: <p>I'm running civicrm on a joomla 2.5 site and recently tried to update my localisation settings which at first appear to save but the new settings are not saved, it reverts to the default settings each time. I then clicked on enable multiple languages and since then I can no longer access CiviCRM at all in my admin panel - I just get the message: "Sorry but we are unable to provide for this at the moment. DB error: no such field. Return to home page" </p>
  
  <p>Help!</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-04-23T12:52:38.377Z
Comments.Text: Did you heed the warning about the "Multiple Languages" checkbox and back up your database?
Comments.UserDisplayName: Laryn
Tags: <joomla><localisation><i18n>
Title: Localisation settings not saving
ThreadText: # Localisation settings not saving
  
  (Asked by: username_0 on 2015-04-21)
  
  I'm running civicrm on a joomla 2.5 site and recently tried to update my localisation settings which at first appear to save but the new settings are not saved, it reverts to the default settings each time. I then clicked on enable multiple languages and since then I can no longer access CiviCRM at all in my admin panel - I just get the message: "Sorry but we are unable to provide for this at the moment. DB error: no such field. Return to home page"
  
  Help!
  
  **Tags:** joomla, localisation, i18n
  
  > **Comments:**
  > **username_1**: Did you heed the warning about the "Multiple Languages" checkbox and back up your database?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2015-05-08. Score: 1
  
  If you interrupt the process while CiviCRM is creating the multilingual mode, you could have a corrupted database.
  
  If you don't have access to civicrm anymore, the best way is to reload a backup of the database as mentionned by [username_1](https://civicrm.stackexchange.com/users/26/username_1).
  
  If you don't have any backup, i guess you could try reset the database to a monolingual by calling the function :
  
  ```
  CRM_Core_I18n_Schema::makeSinglelingual($locale_to_keep)
  
  ```
  
  with `$locale_to_keep = 'en_US'` or `'fr_CA'`...
  
  You need to build a standalone script for this.
  
  
  ---
  
  