Return to Single Language Error

[robbiemc]

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]

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

[robbiemc]

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]

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

[robbiemc]

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