Maniphest T209666

Civi: does an underscore in an email address mess with dedupe script?
Open, MediumPublic
Actions

Assigned To

None

Authored By

	MBeat33
	Nov 16 2018, 12:46 AM

Description

@krobinson noticed that if you search Civi by the email address associated with CID 3383806, the result includes CID 13798711, which has a different email address by a few characters.

CID 3383806's email address has an underscore in it:

is that related to this search result?

and if so, is there any risk that deduping either via script or rules used by agents may be inaccurate because of this?

Event Timeline

MBeat33 created this task.Nov 16 2018, 12:46 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 16 2018, 12:46 AM

MBeat33 triaged this task as Medium priority.Nov 16 2018, 12:46 AM

MBeat33 added a project: FR-donorservices.Oct 6 2021, 5:32 PM

MBeat33 added a subscriber: SHust.

Great catch, @MBeat33! Adding Katers in case this could affect any of the recent donor scans. @KHaggard FYI.

I think mysql treats '_' as a wildcard - the automated script should see those differing emails as a conflict though

Civi: does an underscore in an email address mess with dedupe script?Open, MediumPublicActions

Description

Event Timeline

Civi: does an underscore in an email address mess with dedupe script?
Open, MediumPublic
Actions