Enable Multiple Languages - Error

[yogibear]

Hi, on CiviCRM 2.2.7 I want to test out multilingual capabilities, so ticked the

"Enable Multiple Languages"

check box and the following error was returned.

(I should note that I did have to grant my db user SUPER and CREATE VIEW privileges to get that far - as follows for those wondering:
mysql> GRANT SUPER ON *.* TO 'dbuser'@'localhost';
ditto for CREATE VIEW)

Code: [Select]

Settings - Localization

unrecoverable error
    We apologise but there appears to be a problem, please go back and try again, if you still experience an issue please contact us for support.

    DB Error: not found

    Database Error Code: Can't DROP 'UI_title_extends'; check that column/key exists, 1091

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -4
    [message] => DB Error: not found
    [mode] => 16
    [debug_info] => DROP INDEX UI_title_extends ON civicrm_custom_group [nativecode=1091 ** Can't DROP 'UI_title_extends'; check that column/key exists]
    [type] => DB_Error
    [user_info] => DROP INDEX UI_title_extends ON civicrm_custom_group [nativecode=1091 ** Can't DROP 'UI_title_extends'; check that column/key exists]
    [to_string] => [db_error: message="DB Error: not found" code=-4 mode=callback callback=CRM_Core_Error::handle prefix="" info="DROP INDEX UI_title_extends ON civicrm_custom_group [nativecode=1091 ** Can't DROP 'UI_title_extends'; check that column/key exists]"][/size]


Any hints or suggestions anyone?

I am planning upgrade to 3.0[/code]

[Piotr Szotkowski]

Code: [Select]

Database Error Code: Can't DROP 'UI_title_extends'; check that column/key exists, 1091


Hm, UI_title_extends is an index on civicrm_custom_group indexing title+extends – can you verify that both columns exist in your db?

[yogibear]

Fields as follows.

Field
id
name
extends
extends_entity_column_id
extends_entity_column_value
style
collapse_display
weight
is_active
table_name
is_multiple
min_multiple
max_multiple
title_en_US
help_pre_en_US
help_post_en_US

[yogibear]

Have downloaded the l10n package and placed under civicrm folder but it strikes me I should be doing something with the sql files in that archive?

[Piotr Szotkowski]

Ok, just a quick check so I can reproduce this: you’re using CiviCRM 2.2.7?

[yogibear]

Correct - 2.2.7.

This was originally a 2.2.3 installation upgraded to 2.2.7 if that is relevant.

Thanks for your help.

[Piotr Szotkowski]

Hey, sorry for the late reply. 2.2.7 was a bit of a problematic version when it comes to multilingual capabilities – it pulled in new schema for reports, and one of the new columns was set to be multilingual, while the multilingual engine at that time didn’t support per-minor-version schema changes.

Can you try upgrading your (single-language) site to 2.2.9 and try going multilingual from there?