3

I've got a bit of a baffling issue and I'm not sure where to begin looking for fixes.

I have begun to notice several instances where I have several contacts that share a single Drupal user account. These are contacts who are clearly not the same person and have no business sharing a single Drupal account.

Edited to add:

  • I'm using CiviCRM 4.6.8 and Drupal 7
  • None of the contacts share the same email address
  • Contacts are not synced via rules
  • We have recently opened registrations for 2 very large events. The merge rule we're using is supposed to sync contacts on name and email address
  • There is a profile used for site registrations. We collect name, email address, phone number, address, etc.

Any idea what might cause this to happen?

Improve this question
7
  • are you saying that eg cid 12 and cid 15 are both linked to uid 5?
    – petednz - fuzion ♦
    Commented Sep 15, 2015 at 19:34
  • Yes, that exactly. There are several instances of of several CIDs sharing a single UID.
    – Squishus Tyrannicus
    Commented Sep 15, 2015 at 19:43
  • Can you share a little more about your Drupal setup? Do you have any modules enabled that sync users to contacts (via a rule or otherwise)? Do you have a profile enabled that is used for Drupal registration? Do you use the Webform integration module at all for sign ups of any kind?
    – Allen Hutchison
    Commented Sep 15, 2015 at 20:02
  • Also, what version of Civi are you using?
    – Allen Hutchison
    Commented Sep 15, 2015 at 20:03
  • Another thought too, have you recently used Synchronize Users to Contacts (under Administer > Users and Permissions)?
    – Allen Hutchison
    Commented Sep 15, 2015 at 20:10

1 Answer 1

Reset to default
3

I'm not sure what is causing the contacts to share Drupal accounts, but to detach contacts from Drupal user accounts, you will need access to the civicrm_uf_match table in your CiviCRM database.

See the question How to disconnect civi contact record from Drupal user? and the answer I posted there on how to detach contacts.

Improve this answer
4
  • 1
    Just wanna say that I'm extremely grateful for the API explorer right now.
    – Squishus Tyrannicus
    Commented Sep 16, 2015 at 13:32
  • Curiosity here, how are you using the API explorer to fix it?
    – Allen Hutchison
    Commented Sep 16, 2015 at 15:59
  • 2
    I'm using the API explorer using entity "UFMatch" and action "Get" to find an afflicted contact by ID. Make note of the UFMatchID, then use a "Delete" action to delete that row by corresponding ID. Seems to work.
    – Squishus Tyrannicus
    Commented Sep 16, 2015 at 16:43
  • Brilliant! Great solution.
    – Allen Hutchison
    Commented Sep 16, 2015 at 18:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.