FALSE ALARM - Bug with regards to changing email address in 4.1.2

[NASACT]

I have tried with 3 different browsers and changing the email address in an existing contact record results in the following error.

Error
Error messagePDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '' for key 'name': INSERT INTO {users} (uid, mail, created) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => 73 [:db_insert_placeholder_1] => firstname.lastname@someplace.gov [:db_insert_placeholder_2] => 1339012572 ) in drupal_write_record() (line 7013 of /home/government/www/services/includes/common.inc).

Reloading the page submits the update correctly.  I flushed site cache and browser cache to be sure it wasn't old form data or temp files.  Anyone else have the same issue?  I haven't tried in the sandbox but I can if need be.

Thanks.

[xavier]

Hi,

This is most probably because you have two accounts with the same email (and drupal doesn't like it).

Please edit your post and replace the email by myname@example.org if it's a real one (spammers don't need help

[NASACT]

I double verified that I do not have duplicate emails. This happens with every contact not specific ones.

[NASACT]

I could not reproduce this error in the demo site.  Going back to investigate further.

[NASACT]

No possible duplicates were found using IndividualStrict rule.
No possible duplicates were found using IndividualComplete rule.
No possible duplicates were found using IndividualFuzzy rule.

Cache has been cleared and menu has been rebuilt successfully.

Still having same issue.

What's strange is that pushing the browser back button and hitting cancel on the record sends you to summary page but shows the email address change that I get the error from.

Checking some other things just in case it is from another module.

[xavier]

The problem & error message that you have is with the CMS (the user table), not on civicrm side.

I don't know why it's an insert & not an update, it looks like your user table (on drupal) is out of sync with your contact table.

I'm afraid can't help you more than that. You will have to dig into the code if no one else got an idea.

[NASACT]

Okay, I will look into that. Running the latest for both so not sure how that happened.

[NASACT]

I only have one drupal user account and so I checked it. Do you think this error is the result of not having a user account for each contact?  I wouldn't think that was the case but it would explain why drupal is trying to insert instead of update.

[NASACT]

Code that is executing when error is returning 

// Build the SQL.
  if (empty($primary_keys)) {
    // We are doing an insert.
    $options = array('return' => Database::RETURN_INSERT_ID);
    if (isset($serial) && isset($fields[$serial])) {
      // If the serial column has been explicitly set with an ID, then we don't
      // require the database to return the last insert id.
      if ($fields[$serial]) {
        $options['return'] = Database::RETURN_AFFECTED;
      }
      // If a serial column does exist with no value (i.e. 0) then remove it as
      // the database will insert the correct value for us.
      else {
        unset($fields[$serial]);
      }
    }
    $query = db_insert($table, $options)->fields($fields);
    $return = SAVED_NEW;
  }
  else {
    $query = db_update($table)->fields($fields);
    foreach ($primary_keys as $key) {
      $query->condition($key, $object->$key);
    }
    $return = SAVED_UPDATED;
  }

[NASACT]

Wait I might know the root cause.  If we dumped all user accounts from previous drupal install but brought CiviCRM over and had already performed the user to contact sync would this create values that ultimately need to be deleted from a table so that this flushes the connections until user accounts are recreated?

[xavier]

Ah!

Yes, you have incorrect items in the table that links drupal users & civicrm contacts. THat's civicrm_uf_join from the top of my head. You need to delete the entries where the drupal user doesn't exist

[NASACT]

I checked that table but I don't see any related information.  I can easily fix this by creating user accounts and running sync right?

[NASACT]

I think I found the table "civicrm_uf_match"?

[NASACT]

Yep that was the table. all errors are gone. Stupid me and the migration .