Details
-
Type: Bug
-
Status: Won't Do
-
Priority: Minor
-
Resolution: Won't Do
-
Affects Version/s: 4.7.17
-
Fix Version/s: None
-
Component/s: CiviContribute
-
Labels:None
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:None
-
Funding Source:Needs Funding
-
Verified?:No
Description
One can create a price field in a price set that has multiple options (radio or select) but one cannot edit said price options after they are created. You get a database error like the one below:
"
"$Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => exceptionHandler ) [code] => -19 [message] => DB Error: no such field [mode] => 16 [debug_info] => SELECT a.id as id, a.price_field_id as price_field_id, a.name as name, a.label as label, a.description as description, a.help_pre as help_pre, a.help_post as help_post, a.amount as amount, a.count as count, a.max_value as max_value, a.weight as weight, a.membership_type_id as membership_type_id, a.membership_num_terms as membership_num_terms, a.is_default as is_default, a.is_active as is_active, a.financial_type_id as financial_type_id, a.non_deductible_amount as non_deductible_amount FROM civicrm_price_field_value_en_US a WHERE (a.price_field_id = "112") LIMIT 25 OFFSET 0 [nativecode=1054 ** Unknown column 'a.help_pre' in 'field list'] [type] => DB_Error [user_info] => SELECT a.id as id, a.price_field_id as price_field_id, a.name as name, a.label as label, a.description as description, a.help_pre as help_pre, a.help_post as help_post, a.amount as amount, a.count as count, a.max_value as max_value, a.weight as weight, a.membership_type_id as membership_type_id, a.membership_num_terms as membership_num_terms, a.is_default as is_default, a.is_active as is_active, a.financial_type_id as financial_type_id, a.non_deductible_amount as non_deductible_amount FROM civicrm_price_field_value_en_US a WHERE (a.price_field_id = "112") LIMIT 25 OFFSET 0 [nativecode=1054 ** Unknown column 'a.help_pre' in 'field list'] [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="SELECT a.id as id, a.price_field_id as price_field_id, a.name as name, a.label as label, a.description as description, a.help_pre as help_pre, a.help_post as help_post, a.amount as amount, a.count as count, a.max_value as max_value, a.weight as weight, a.membership_type_id as membership_type_id, a.membership_num_terms as membership_num_terms, a.is_default as is_default, a.is_active as is_active, a.financial_type_id as financial_type_id, a.non_deductible_amount as non_deductible_amount FROM civicrm_price_field_value_en_US a WHERE (a.price_field_id = "112") LIMIT 25 OFFSET 0 [nativecode=1054 ** Unknown column 'a.help_pre' in 'field list']"] )"
"
Im pretty sure this is because when multilingual is enabled help_pre becomes a translated field ie help_pre_en_us