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

Manage Group Page unavailable with DB Error

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Critical
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.6.3
    • Fix Version/s: 4.6.4
    • Component/s: CiviCRM Search
    • Labels:
      None
    • Documentation Required?:
      None

      Description

      Anyone who has a smart group using the contribution fulfilled date will not be able to get to their Manage Group page. The issue it is looking for the fulfilled date in the contribution table when it should be looking in the contribution_product table.

      DB Error: no such field
      Unknown column 'civicrm_contribution.fulfilled_date' in 'where clause'

      SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( ( civicrm_contribution.fulfilled_date IS NOT NULL ) ) AND (contact_a.is_deleted = 0) ORDER BY UPPER(LEFT(contact_a.sort_name, 1)) asc

      [nativecode=1054 ** Unknown column 'civicrm_contribution.fulfilled_date' in 'where clause']

      Steps to reproduce:
      In search builder, attempt to create a search based on the contribution > "fulfillment date" you will get an error. This is the same error you will get if you already had a smart group based on fulfilled date and try to go your manage group page.

        Attachments

          Activity

            People

            • Assignee:
              rell Tyrell Dwayne Cook
              Reporter:
              rell Tyrell Dwayne Cook
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: