3

Wordpress 4.7.5 & CiviCRM 4.7.19

My contact is replicating in our system, to the point there were 700+ records with just my email and name. I am not sure what is happening but I have some ideas. Every time I do something on CiviCRM it creates a new contact. Not sure if this is true, but it does not seem to make new contacts while I am away.

Lastly, when I login with my other admin account, none of these issues exist and my user does not replicate anymore. When I login to my user account, it replicates again.

Should I not have users that are also members, donors, etc act as administrators?

  • 1
    It will help folks to help you if you explain what version of CiviCRM you are using with what CMS. And also expand a little more on what you are trying to achieve. I understand your frustration, but I have no clear picture of what goes wrong when. As far as the 'should I not have users that are also members etc.' goes: that depends, do you want all your members to be able to log in to CiviCRM? Remember not each CiviCRM contact will have to be a user in your CMS? – ErikH - CiviCooP May 31 '17 at 5:39
  • 1
    The dedupe error you're seeing is a known bug. See issues.civicrm.org/jira/browse/CRM-20556. – BobS May 31 '17 at 6:34
  • I suggest you study the bogus contact records, specifically the contact source on the Summary tab and the info in the Change Log tab, for clues about what is causing the duplication. Look also to see if those contacts have events, contributions, activities, etc. The more info you provide, the more likely someone will be able to offer a solution. – BobS May 31 '17 at 6:42
  • @BobS - Thanks, I have removed reference to it as it is unrelated. I also just turned on logging in CiviCRM. Updating log above. Thank you for tip. – themak May 31 '17 at 14:26
  • I doubt that the error in your log is related to the multiple contacts issue. That looks like someone clicked on a malformed link where the event ID was incorrect, e.g. "&id=33." instead of "&id=33". What info can you glean from the bogus contact records? – BobS May 31 '17 at 14:42
4

You can change the email account associated with a WordPress (or other CMS) account by editing the "UFMatch". If you're SQL-savvy, the correct table is civicrm_uf_match. If you want to do it through the web browser, and you acknowledge that this is a tricksy maneuver, you can do this:

  • Go to Support menu > Developer > API Explorer. "Support" menu might be called "Help" menu, it switched somewhere in 4.6.
  • Set "Entity" to "UFMatch", "Action" to "Get". In "Parameters", Set "CiviCRM Contact ID" to your admin account's name.
  • Press "Execute".
  • In the "Results" area below the "Execute" button, note the value of "id". There are two "id" values - you want the one INSIDE the "values" stanza. See screenshot below.
  • Copy/paste the entire results somewhere safe in case something gets messed up! Better yet, do this on a test copy of the database.

Now that you have the ID of the UFMatch record you want to change, go ahead and enter the new details:

  • Keep "Entity" as "UFMatch", change "Action" to "Create". For "UFMatch ID", put in the ID you just found.
  • Press "Add Parameter" twice.
  • Set the "CMS ID" to the WordPress user ID of the account you want to link to. Set the "CMS Unique Identifier" to the email address of the same WordPress account.
  • Press "Execute".

enter image description here

  • This is super helpful. I ended up just changing the email of the record and create a new record for the other user. Its all good now. Glad to know if this happens again, we can use the API Explorer. – themak Jun 1 '17 at 17:18
2

The problem is clear.

Example of issue: Wordpress admin account is Admin, somehow connected to xyz@otheremail.com contact on CiviCRM. xyz@otheremail.com wordpress account is also an admin, whenever xyz@otheremail.com logs in as an admin on wordpress and tries to do something, it creates a new xyz@otheremail.com contact. The Wordpress admin account should be connected to abc@email.com record in civicrm but instead is connected to xyz@otheremail.com record in civicrm and is causing issues.

A solution could be to assign the admin wordpress account to another civicrm record, such as abc@email.com but I do not see a way of doing so.

Other stackexchange questions seem to share this same issue.

CiviCRM not creating Wordpress user accounts on member registration

New contact created every time I login!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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