CiviCRM Community Forums (archive)

Morning,

  we're getting a weird error when we try to view some of our smart groups. Some smart groups we can view, but others we get the error "Database Error Code: Operand should contain 1 column(s), 1241"

 Same error when I try to run the query from the sql prompt. Here is the command:

SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name FROM civicrm_contact contact_a  LEFT JOIN civicrm_entity_tag `civicrm_entity_tag-7,9` ON ( `civicrm_entity_tag-7,9`.entity_id = contact_a.id AND `civicrm_entity_tag-7,9`.entity_table = 'civicrm_contact' )    LEFT JOIN civicrm_group_contact `civicrm_group_contact-2` ON contact_a.id = `civicrm_group_contact-2`.contact_id WHERE  ( contact_a.contact_type IN ('Individual') AND `civicrm_group_contact-2`.group_id IN ( 2 ) AND `civicrm_group_contact-2`.status IN ("Added") AND `civicrm_entity_tag-7,9`.tag_id = (7,9) )  AND (contact_a.is_deleted = 0)  GROUP BY contact_a.id;

Is this perhaps something we've overlooked setting up the mysql server? Or is it that our smart group wasn't created with the correct data/contacts? Has anyone come across this before or could shed some light for us?

thanks,

~r