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.