CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Return to Single Language Error
Pages: [1]

Author Topic: Return to Single Language Error  (Read 1153 times)

robbiemc

  • I post occasionally
  • **
  • Posts: 66
  • Karma: 0
  • CiviCRM version: 4.5.0
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.37
  • PHP version: 5.3.28
Return to Single Language Error
January 15, 2014, 12:56:25 am
Hi

Drupal 7, CiviCRM 4.3.5

Not sure if this is the correct section of the forum but I have had some issues when trying to upgrade Civi which seem to be pointing to the multilingual installation. Our situation has changed and we now only need the db to be in English_UK (we also have Dutch and Catalonian enabled).

The problem is when I try to revert to a single language installation I get the error detailed below.

I have no idea what I am looking for to try and resolve this and would be fab if anyone can give me any pointers.

Best regards

Robbie


Initialization Error

Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
  • [1] => simpleHandler
            )

       
Code: [Select]
=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] =>
SELECT
   option_value.id          as id,
   option_value.label       as label,
   option_value.value       as value,
   option_value.name        as name,
   option_value.description as description,
   option_value.weight      as weight,
   option_value.is_active   as is_active,
   option_value.is_default  as is_default
FROM
   civicrm_option_value_en_GB  as option_value,
   civicrm_option_group_en_GB  as option_group  WHERE option_group.id = option_value.option_group_id  AND option_group.name = 'languages' ORDER BY weight [nativecode=1146 ** Table 'ehfa_civicrm.civicrm_option_value_en_GB' doesn't exist]
    [type] => DB_Error
    [user_info] =>
SELECT
   option_value.id          as id,
   option_value.label       as label,
   option_value.value       as value,
   option_value.name        as name,
   option_value.description as description,
   option_value.weight      as weight,
   option_value.is_active   as is_active,
   option_value.is_default  as is_default
FROM
   civicrm_option_value_en_GB  as option_value,
   civicrm_option_group_en_GB  as option_group  WHERE option_group.id = option_value.option_group_id  AND option_group.name = 'languages' ORDER BY weight [nativecode=1146 ** Table 'ehfa_civicrm.civicrm_option_value_en_GB' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info="
SELECT
   option_value.id          as id,
   option_value.label       as label,
   option_value.value       as value,
   option_value.name        as name,
   option_value.description as description,
   option_value.weight      as weight,
   option_value.is_active   as is_active,
   option_value.is_default  as is_default
FROM
   civicrm_option_value_en_GB  as option_value,
   civicrm_option_group_en_GB  as option_group  WHERE option_group.id = option_value.option_group_id  AND option_group.name = 'languages' ORDER BY weight [nativecode=1146 ** Table 'ehfa_civicrm.civicrm_option_value_en_GB' doesn't exist]"]
)


mathieu

  • Administrator
  • Ask me questions
  • *****
  • Posts: 620
  • Karma: 36
    • Work
  • CiviCRM version: 4.7
  • CMS version: Drupal
  • MySQL version: MariaDB 10
  • PHP version: 7
Re: Return to Single Language Error
January 21, 2014, 06:39:05 am
Hi,

Thanks for reporting the issue. It's the correct forum :)

Could you send the backtrace? (either enable in in "admin -> system -> debugging" and restore DB/re-run the switch to uni-lingual, or the backtrace might already be in your logs, found in templates_c/ConfigAndLog/)

Mathieu
CiviCamp Montréal, 29 septembre 2017 | Co-founder / consultant / turn-key CiviCRM hosting for Quebec/Canada @ SymbioTIC.coop

robbiemc

  • I post occasionally
  • **
  • Posts: 66
  • Karma: 0
  • CiviCRM version: 4.5.0
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.37
  • PHP version: 5.3.28
Re: Return to Single Language Error
April 28, 2014, 05:10:32 am
Hi Mattieu

Apologies for not getting back to you sooner...been buy with a re-branding project and now have to face up to this issue. Could you please advise as to where exactly I can find the logs 'templates_c'

If can't locate will again try to rever to single language and backtrace.

Cheers

Robbie

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Return to Single Language Error
April 28, 2014, 05:24:22 am
Quote from: robbiemc on April 28, 2014, 05:10:32 am

Apologies for not getting back to you sooner...been buy with a re-branding project and now have to face up to this issue. Could you please advise as to where exactly I can find the logs 'templates_c'

The logs are normally in sites/default/files/civicrm/ConfigAndLog
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

robbiemc

  • I post occasionally
  • **
  • Posts: 66
  • Karma: 0
  • CiviCRM version: 4.5.0
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.37
  • PHP version: 5.3.28
Re: Return to Single Language Error
June 04, 2014, 04:42:37 pm
Have posted as a new topic as this one was getting old due to my being too busy to commit to a backtrace.

Please see; http://forum.civicrm.org/index.php/topic,32969.0.html

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Return to Single Language Error

This forum was archived on 2017-11-26.