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

Use of any contact greeting field in mixed profile causes DB error

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.1
    • Fix Version/s: 3.1
    • Component/s: CiviCRM Profile
    • Labels:
      None

      Description

      If we include any of contact greeting (email, postal, addressee) field in a mixed profile and if we use this profile in Event/ Contribution page, it fails and displays following db error

      [code] => -2
      [message] => DB Error: syntax error
      [mode] => 16
      [debug_info] =>
      SELECT v.label as label ,v.value as value, v.grouping as grouping
      FROM civicrm_option_value v,
      civicrm_option_group g
      WHERE v.option_group_id = g.id
      AND g.name = 'email_greeting'
      AND v.is_active = 1
      AND g.is_active = 1 AND (v.filter = 0 OR v.filter =) ORDER BY v.weight [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY v.weight' at line 7]
      [type] => DB_Error

      Steps to replicate:
      1. Create a profile and include a field which is one of for Contribution/ Participant.
      2. Include any contact greeting field in it so that it will become a mixed profile.
      3. Now if we use this profile in Contribution/ Event page, we get above db error.

      Same problem for profile preview.

        Attachments

          Activity

            People

            • Assignee:
              ashwini Ashwini Poharkar
              Reporter:
              shailesh Shailesh Lende
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: