CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Drupal / CiviCRM users going out of sync - can they be manually resynced?
Pages: [1]

Author Topic: Drupal / CiviCRM users going out of sync - can they be manually resynced?  (Read 10889 times)

GingerFeet

  • I post occasionally
  • **
  • Posts: 78
  • Karma: 4
  • CiviCRM version: 3.4.6 / 3.4.7
  • CMS version: Drupal 6.22
  • MySQL version: 5.1
  • PHP version: 5.3.6
Drupal / CiviCRM users going out of sync - can they be manually resynced?
March 08, 2011, 06:36:11 pm
Hello All,

We are having a problem.

A few Drupal users have gone out of sync with their corresponding CiviCRM contact.

Drupal user John has a correct CiviCRM contact John.
Drupal user John is associated with CiviCRM contact Betty (not the John contact).

When you update John's contact info name in Drupal, it changes Betty's name to John in CiviCRM.
When you update Betty's name in CiviCRM, it changes John's contact info name to Betty in Drupal.

The only way I could 'fix' it was to remove both the Drupal user John and the CiviCRM contact John, and then recreate the John contact and the John Drupal user.

This is not an attractive option when the CiviCRM John contact has a large amount of related data.

Can the relationship be manually corrected in a table?
Which table?

Thanks,

Jake

Rajan Mayekar

  • I post frequently
  • ***
  • Posts: 177
  • Karma: 20
    • Rajan's Blogs
Re: Drupal / CiviCRM users going out of sync - can they be manually resynced?
March 08, 2011, 07:59:16 pm
Hi GingerFeet,
 
Even http://wiki.civicrm.org/confluence/display/CRMDOC40/Synchronize+Users-to-Contacts will not work here, since matching contact is already present.

But may be you can use reverse way ie by deleting drupal users and recreating with  http://wiki.civicrm.org/confluence/display/CRMDOC33/Creating+a+Drupal+user+for+every+CiviCRM+contact.

Mapping between drupal users and civicrm contact stored in table 'civicrm_uf_match', field 'uf_id' specify the drupal user id and  'contact_id' specify civicrm contact id.
So another way is to manually update this table Or custom script will work here.

Rajan

GingerFeet

  • I post occasionally
  • **
  • Posts: 78
  • Karma: 4
  • CiviCRM version: 3.4.6 / 3.4.7
  • CMS version: Drupal 6.22
  • MySQL version: 5.1
  • PHP version: 5.3.6
Re: Drupal / CiviCRM users going out of sync - can they be manually resynced?
March 11, 2011, 11:22:35 am
Rajan,

Thank you for your clear and accurate answer.

Jake

gastrit

  • I post occasionally
  • **
  • Posts: 60
  • Karma: 2
  • CiviCRM version: 4.2.2
  • CMS version: 7.8
  • MySQL version: 5.1.41
  • PHP version: 5.3.2
Re: Drupal / CiviCRM users going out of sync - can they be manually resynced?
April 03, 2012, 03:00:44 am
I updated the contact_id in civicrm_uf_match and everything looks fine while looking at the contact. There is a link to the correct drupal user. But when I try to login as the drupal user I get a error message from civicrm:
"On of parameters (value: ) is not of the type Integer

If I change civicrm_uf_match.contact_id back to it's original value I can log in again (but it's connected with the wrong civicrm contact). Does anyone have a clue?

Steve@ASU

  • I’m new here
  • *
  • Posts: 21
  • Karma: 0
  • CiviCRM version: 4.0
  • CMS version: Drupal 7
  • MySQL version: 5.0.51a-community-log
  • PHP version: 5.2.17
Re: Drupal / CiviCRM users going out of sync - can they be manually resynced?
August 19, 2013, 03:07:05 pm
Did anyone come up with a solution to this?

Is there any way to reset the table? Can you delete it and redo it?
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Drupal / CiviCRM users going out of sync - can they be manually resynced?

This forum was archived on 2017-11-26.