CiviCRM Community Forums (archive)

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.

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

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.

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

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;
  }

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

I think I found the table "civicrm_uf_match"?