CiviCRM Community Forums (archive)

I was trying to run a custom search specifically, Contributions made in Year X and not Year Y.  I generated results and in the result page I clicked the radio button for All XX records.  I chose to add the records to a group and then I get the following error.

"1054 ** Unknown column 'contact_a.id' in 'field list'"

This also happens on the demo site using the same process.  I found the resulting SQL to be

SELECT contact_a.id as contact_id FROM civicrm_contact AS contact LEFT JOIN civicrm_contribution contrib_1 ON contrib_1.contact_id = contact.id LEFT JOIN XG_CustomSearch_SYBNT xg ON xg.contact_id = contact.id WHERE contrib_1.contact_id = contact.id AND contrib_1.is_test = 0 AND contrib_1.receive_date >= 20130505000000 AND contrib_1.receive_date <= 20130511000000 AND xg.contact_id IS NULL GROUP BY contact.id ORDER BY donation_amount desc

The problem is neither civicrm_contact nor civicrm_contribution have a "contact_a". I think you just need to chagne contact_a to simple be contact so that is is contact.id as contact_id.   I am just not sure where the SQL for this particular search is generated.  If anyone has any pointers that would be helpful. 

I got the SQl above from the following file
CRM\Contact\Selector\Custom.php

Hmm I will file a bug tracker report just to make it official.

For now what I did is I just hacked the SQL manually to get to function... simple str_replace.  It worked but its certainly not production quality and its limited to just the specific search at hand.  Once I used the action I reverted the code back to the original.