CiviCRM Community Forums (archive)

I have created a profile based on a smart group.  The profile lists a single contact more that once, usually two or three times, sometimes only once.

The smart group searches correctly, listing a contact only once.  So it must be something in the profile.  is there a setting on a field that would make it list an individual more than one time if certain data was present?

Thanks,
Maria

Updated most of the profile info, waiting on the php version, but it is pretty new.

I ran a test in the demo site, works just fine.  I am familiar with Views in Drupal which can output the same record more than once if the record has more than one tag that the view is calling.  But I don't know why that would be a problem with Civi. 

Can I give you anymore information?  Most of the searchable fields are standard (non-custom) fields. 

Thanks,
Maria

can u check your db and ensure that there is only one is_primary / contact_id. you can try running a query similar to:

SELECT count(id) as cnt FROM civicrm_phone WHERE is_primary = 1  GROUP BY contact_id HAVING cnt > 1ORDER BY cnt SELECT count(id) as cnt FROM civicrm_phone WHERE is_primary = 1  GROUP BY contact_id ORDER BY cnt;

u should not get any contact_id with 2 is_primary. If so, you might want to fix them manually in the DB

lobo

argh, i messed up the cut-n-paste. here's another try:

  SELECT count(id) as cnt FROM civicrm_phone WHERE is_primary = 1 GROUP BY contact_id ORDER BY cnt;

lobo

so basically it means you have contact ids  with multiple primary phone numbers (and potentially email / address)

my sql knowledge is not good enough to give u a query to fix this, hopefully someone else will step in and help out


lobo