Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.6
-
Fix Version/s: 4.6
-
Component/s: CiviContribute, CiviCRM Search
-
Labels:None
-
Documentation Required?:None
Description
Advanced Search > Contributions > Status = Completed
Fatal error caused by this phrase (note missing IN or = and status_id is wrong for Completed, s/b 1)
WHERE ( civicrm_contribution.contribution_status_id 0 )
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.contribution_status_id 0 ) AND (contact_a.is_deleted = 0) ORDER BY UPPER(LEFT(contact_a.sort_name, 1)) asc
[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 '0 ) AND (contact_a.is_deleted = 0) ORDER BY UPPER(LEFT(contact_a.sort_name, ' at line 1]