CiviCRM Community Forums (archive)

Multilingual was turned on in version 3.0.1.

In running the upgrade script for 3.0.2 I got an error (details below).  In looking at the error it seems that the code is looking for the field 'value' in 'civicrm_option_value' table.

In looking at the 'civicrm_option_value' table of the multilingual test site I do not see a 'label' field.  There is a 'label' field in my single language English live site.  Enabling multilingual seems to have removed the 'label' field from 'civicrm_option_value' and added the fields 'label_en_US' and 'label_fr_CA'

The 'civicrm_option_value_en_US' and 'civicrm_option_value_fr_CA' tables both have 'label' fields

Bob

-------------------------------------------------------------------------
Upgrade CiviCRM to Version 3.0.2

Sorry. A non-recoverable error has occurred.


DB Error: no such field
Database Error Code: Unknown column 'v.label' in 'field list', 1054
Return to home page.
Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] =>
SELECT  v.label as label ,v.value as value
FROM   civicrm_option_value v,
       civicrm_option_group 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=1054 ** Unknown column 'v.label' in 'field list']
    [type] => DB_Error
    [user_info] =>
SELECT  v.label as label ,v.value as value
FROM   civicrm_option_value v,
       civicrm_option_group 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=1054 ** Unknown column 'v.label' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT  v.label as label ,v.value as value
FROM   civicrm_option_value v,
       civicrm_option_group 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=1054 ** Unknown column 'v.label' in 'field list']"]
)




hi
This is bug; We have filed an issue for this: http://issues.civicrm.org/jira/browse/CRM-5350

And we’ll fix it soon.

Sunil

Hi,
Can you Enabled the Debug and Display Backtrace in Global setting, then post backtrace here.
However http://issues.civicrm.org/jira/browse/CRM-5350 has been fixed and will be part of v3.0.3

Here is fix.
you can back port  this fix.
http://fisheye2.atlassian.com/changelog/CiviCRM?cs=24836
Or you can also replace CRM/Upgrade/Form.php by from  v3.0.3 in you current version.

sunil