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

Error: advanced search with conditions on relationship (active) and membership at the same time

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 2.1.2
    • Fix Version/s: 2.1.4
    • Component/s: CiviMember, Core CiviCRM
    • Labels:
      None

      Description

      http://forum.civicrm.org/index.php/topic,5747.0.html

      I am getting an error
      ---------------------------------------------------------------------------
      DB Error: a515ac9c2796ca0e23adbe92c68fc9fc

      Database Error Code: Column 'end_date' in where clause is ambiguous, 1052
      ---------------------------------------------------------------------------
      when trying to do advanced search with conditions on relationship (active) and membership at the same time

      when 'all' is selected on a relationship condition the error goes away

        Attachments

          Activity

            People

            • Assignee:
              yashodha Yashodha Chaku
              Reporter:
              kurund Kurund Jalmi
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: