CiviCRM Community Forums (archive)

My site is multilingual, supporting 5 languages. I tried to upgrade to CiviCRM 3.2.1 and i got "DB Error: no such table" during the upgrade process. Below is the error details
Database Error Code: Table 'db_name.civicrm_option_value_en_US' doesn't exist, 1146
Additional Details:

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

    [code-] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] =>
SELECT  v.label as label ,v.value as value
FROM   civicrm_option_value_en_US v,
       civicrm_option_group_en_US g
WHERE  v.option_group_id = g.id
  AND  g.name            = 'activity_type'
  AND  v.is_active       = 1 
  AND  g.is_active       = 1 
  AND  v.name     = 'Inbound Email'
 [nativecode=1146 ** Table 'db_name.civicrm_option_value_en_US' doesn't exist]
    [type] => DB_Error
    [user_info] =>
SELECT  v.label as label ,v.value as value
FROM   civicrm_option_value_en_US v,
       civicrm_option_group_en_US g
WHERE  v.option_group_id = g.id
  AND  g.name            = 'activity_type'
  AND  v.is_active       = 1 
  AND  g.is_active       = 1 
  AND  v.name     = 'Inbound Email'
 [nativecode=1146 ** Table 'db_name.civicrm_option_value_en_US' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT  v.label as label ,v.value as value
FROM   civicrm_option_value_en_US v,
       civicrm_option_group_en_US g
WHERE  v.option_group_id = g.id
  AND  g.name            = 'activity_type'
  AND  v.is_active       = 1 
  AND  g.is_active       = 1 
  AND  v.name     = 'Inbound Email'
 [nativecode=1146 ** Table 'db_name.civicrm_option_value_en_US' doesn't exist]"]
)
I suppose it should be looking for 'db_name.civicrm_option_value' table instead of 'db_name.civicrm_option_value_en_US' , as 'db_name.civicrm_option_value' table is the default for en_US.

Also i checked value for locales from 'civicrm_domain' table and it is not empty.

Any help with be greatly appreciated.

Rajesh

Thanks for the reply.

I am upgrading from 3.0.1 to 3.2.1.

I have 5 languages enabled already and its working fine with 3.0.1 and looking at my current working database, it has a table named 'db_name.civicrm_option_value' ,but there is no such table named 'db_name.civicrm_option_value_en_US'. When i run the upgrade script, it is looking for table named 'db_name.civicrm_option_value_en_US' and throws the DB Error.

Do i need to upgrade it to 3.1 before i upgrade it to 3.2.1? Is there any major change in database structure in 3.2.1?

Thanks

Rajesh