CiviCRM Community Forums (archive)

When an anonymous user registers for an event and provides their first name, last name and email address as part of registering online, an existing contact record gets updated when the existing contact has the same email address.    Yet I have the "individual unsupervised" dedupe rule and the "individual supervised" dedup rule both configured as follows:
 
First Name  10
 Last Name  10
 email           10
 Threshold: 30

Since the first name of the participant does NOT match the first name of the existing contact, I would assume the system should create a new contact record for the participant.   Yet this is not what is happening.   (In this scenario the  first last, last name and email (ie all 3) do NOT match any existing contact.      Only the last name and email match an existing contact, but its not the same person.

For example: George Jetson (jetsonfamily@yahoo.com) is already in the database.    His wife Jane is NOT in the database.   Jane goes online (as an anonymous user) and registers for an event, filling out the form as "Jane Jetson" (jetsonfamily@yahoo.com)    Her contact data overwrites George's record!

The existing contact that got incorrectly overwritten only had one email address. As a precaution, I changed the email weight to "2" and the rule threshold to "22". But that did not solve my issue.

Something weird: This only happens when the participant is not yet in the database.  If there are 2 contacts already in the database ( ie George and Jane) then Jane registers for the event as an anonymous user the correct record gets updated.  Seems odd that the issue only occurs when Jane did not have a contact record  beforehand.

Could the dedupe rule "name" have any impact?

The URL to the event is:
http://mygroup.org/civicrm/event/register?id=127&reset=1

BTW:
Found something off in the file "CRM/Dedupe/BAO/QueryBuilder/IndividualUnsupervised.php" in function "record".  This function seems hard-coded to only check on email address alone. (it ignores the rule configuration in the database.)

The SQL from that function is:
SELECT contact.id as id1, {$rg->threshold} as weight
                FROM civicrm_contact as contact
                  JOIN civicrm_email as email ON email.contact_id=contact.id
                WHERE contact_type = 'Individual'
                  AND email = %1

I think this is a different bug as it happens whether the checkbox "Allow multiple registrations from the same email address?"  is checked or not checked.  I changed that one SQL statement to check for first name, last name and email and that solved the bug for me.   My solution is written up in the JIRA at: https://issues.civicrm.org/jira/browse/CRM-15312