Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-20627

Cannot "Edit Price Options" with multilingual enabled

    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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              alifrumin Alice Frumin
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: