Author Topic: Database error when i want to enable civicase componements (Read 1679 times)

p.gervaix · July 04, 2012, 03:25:12 am

Hi,

I have this error when i want to enable civicase:
DB Error: no such field

Error Details:

Database Error Code: Unknown column 'label' in 'field list', 1054
Additional Details:
Array
(
[callback] => Array
(

=> CRM_Core_Error

Code: [Select]

 => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => INSERT INTO `civicrm_option_value` (  `option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`) 
(SELECT @option_group_id_case_type, 'Housing Support',  @max_val + 1, 'housing_support', NULL, 0,  0, @max_wt + 1, 'Help homeless individuals obtain temporary and long-term housing', 0, 0, 1
 FROM dual WHERE NOT EXISTS (SELECT * FROM `civicrm_option_value`  WHERE `name` = 'housing_support')) [nativecode=1054 ** Unknown column 'label' in 'field list']
    [type] => DB_Error
    [user_info] => INSERT INTO `civicrm_option_value` (  `option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`) 
(SELECT @option_group_id_case_type, 'Housing Support',  @max_val + 1, 'housing_support', NULL, 0,  0, @max_wt + 1, 'Help homeless individuals obtain temporary and long-term housing', 0, 0, 1
 FROM dual WHERE NOT EXISTS (SELECT * FROM `civicrm_option_value`  WHERE `name` = 'housing_support')) [nativecode=1054 ** Unknown column '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="INSERT INTO `civicrm_option_value` (  `option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`) 
(SELECT @option_group_id_case_type, 'Housing Support',  @max_val + 1, 'housing_support', NULL, 0,  0, @max_wt + 1, 'Help homeless individuals obtain temporary and long-term housing', 0, 0, 1
 FROM dual WHERE NOT EXISTS (SELECT * FROM `civicrm_option_value`  WHERE `name` = 'housing_support')) [nativecode=1054 ** Unknown column 'label' in 'field list']"]
)


Thx for Help

Dave Greenberg · July 04, 2012, 07:18:16 am

I assume this is a multi-language install? There's a known open bug:
http://issues.civicrm.org/jira/browse/CRM-10453

Problem is that CiviCase tries to install sample configuration data when enabled if there is no existing configuration data - but the SQL inserts are not handling multi-language site schemas.

Would be great if you could work with Leo to investigate and submit a fix.

As a work around, I "think" the code might not try to install sample data if you implement your own configuration files as described in the user guide:

http://book.civicrm.org/user/case-management/setup

CiviCRM Community Forums (archive)

News:

Author Topic: Database error when i want to enable civicase componements (Read 1679 times)

p.gervaix

Database error when i want to enable civicase componements

Dave Greenberg

Re: Database error when i want to enable civicase componements