CiviCRM Community Forums (archive)

Hi there,

I have a smart group criteria that has gone wrong

SELECT
   contact_a.id as id
FROM civicrm_contact contact_a
LEFT JOIN civicrm_activity_target ON civicrm_activity_target.target_contact_id = contact_a.id
LEFT JOIN civicrm_activity ON ( civicrm_activity.id = civicrm_activity_target.activity_id AND civicrm_activity.is_deleted = 0 AND civicrm_activity.is_current_revision = 1 )

WHERE
   (
      civicrm_activity.activity_type_id IN (24)
      AND contact_b.is_deleted = 0
      AND contact_b.sort_name LIKE '%%'
      AND civicrm_activity.status_id IN (2)
   ) AND ( 1 )
   AND contact_a.id NOT IN (
      SELECT contact_id
      FROM civicrm_group_contact
      WHERE civicrm_group_contact.status = 'Removed' AND civicrm_group_contact.group_id = 7
   )

UNION
 
SELECT
   contact_id as id
FROM civicrm_group_contact
WHERE
   civicrm_group_contact.status = 'Added'
   AND civicrm_group_contact.group_id = 7

In case it isn't obvious (!) the error is "Unknown column 'contact_b.is_deleted' in 'where clause'"

Not sure why this went wrong (maybe something to do with an upgrade) and am happy to not know why it went wrong unless someone wants to tell me.

My question is how can I safely delete this smart group (with id 7)?

delete from civicrm_group where id = 7;
delete from civicrm_group_contact where group_id = 7;

There's nothing about groups that gets logged, AKAIK.  Anywhere else I should be deleting / things I should be scared of?

Thanks,
Michael

U'll also need to delete the right records from civicrm_saved_search

lobo

Thanks guys -> Eileen - you are pretty genius these days