CiviCRM Community Forums (archive)

When you use advanced search, and select say all individuals. It says there are 1600 records, but it doesn't output all of them. It goes to about the S names (approx 1570 records displaying) and you have to click on the letter tabs to view the names after S. It obviously has something to do with counting but not displaying duplicates, but I can't find where the issue is.

If you sort on zip or any other field, it displays all records fine.

We have both household accounts and individual accounts using the same address.

All addresses (and phones, emails, etc) have a location_id of 1 (home) are set to primary.

What else could be causing this issue?

Thanks for any help you can give on this.

Thanks! That put me on the right track. I did a search of my database using:

SELECT DISTINCT contact_id FROM civicrm_phone GROUP BY contact_id HAVING count( contact_id ) >1

and found my duplicate records that had the same contact_id and were set as the same location_id and is_primary=1.

I did the same search on the civicrm_address adn civicrm_phone (we don't use civicrm_im or civicrm_openid, but if you do, you need to check those as well).

Is it 'missing' them, or is it returning a result that claims a larger number than there really is?