CiviCRM Community Forums (archive)

On the Find Contacts page, if you put into the Name box one particular individual contact's name (last, first), CiviCRM reports "Found 1 contact", but the person's info shows up twice in the listing at the bottom -- there are two identical lines.  We only have this problem with one specific contact.  If I go into myPhpAdmin, go to the civicrm_contact table, and either do a Search from the menu or type the query to find the contact manually, there is exactly one row.  Here is the manual query:

SELECT * FROM `civicrm_contact` WHERE sort_name = '{last, first}' or display_name = '{last, first}'

The query returns one row, which is the correct row for this contact.

The Find Contacts page works correctly for all others, as far as I know.

We are on version 1.n (not on 2 yet).

Does anyone have an idea on what could cause this?

Thanks,

> There were some issues w/ duplicate rows showing in 1.x when a contact had multiple phone numbers and possibly a few other cases of multiple instances of location-related data. Might be the problem ??

Now that you mention it, the person has two listed mobile phone numbers, which happen to be exactly the same.  I would assume that is it.

Thanks,