After updaing D7.50 to D7.54, I got below error message when creating or updating a new user.

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '19917' for key 'vid': UPDATE {users} SET name=:db_update_placeholder_0, pass=:db_update_placeholder_1, mail=:db_update_placeholder_2, theme=:db_update_placeholder_3, signature=:db_update_placeholder_4, signature_format=:db_update_placeholder_5, created=:db_update_placeholder_6, access=:db_update_placeholder_7, login=:db_update_placeholder_8, status=:db_update_placeholder_9, timezone=:db_update_placeholder_10, language=:db_update_placeholder_11, picture=:db_update_placeholder_12, init=:db_update_placeholder_13, data=:db_update_placeholder_14, vid=:db_update_placeholder_15, ip=:db_update_placeholder_16 WHERE (uid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => Testharish [:db_update_placeholder_1] => $S$DGsgEmOCpcBJFFWFhCyLk5/oxu2w1HeetpdLo2jYd9Q0WC46qnZy [:db_update_placeholder_2] => testitnow91@gmail.com [:db_update_placeholder_3] => [:db_update_placeholder_4] => [:db_update_placeholder_5] => 2 [:db_update_placeholder_6] => 1482147041 [:db_update_placeholder_7] => 1490614650 [:db_update_placeholder_8] => 1490613206 [:db_update_placeholder_9] => 1 [:db_update_placeholder_10] => America/New_York [:db_update_placeholder_11] => en [:db_update_placeholder_12] => 0 [:db_update_placeholder_13] => testitnow91@gmail.com [:db_update_placeholder_14] => a:6:{s:7:"contact";i:1;s:16:"ckeditor_default";s:1:"t";s:20:"ckeditor_show_toggle";s:1:"t";s:14:"ckeditor_width";s:4:"100%";s:13:"ckeditor_lang";s:2:"en";s:18:"ckeditor_auto_lang";s:1:"t";} [:db_update_placeholder_15] => 19917 [:db_update_placeholder_16] => 127.0.0.1 [:db_condition_placeholder_0] => 19703 ) in drupal_write_record() (line 7383 of /var/www/html/adi4/includes/common.inc).

Comments

pvsureshmca created an issue. See original summary.

pvsureshmca’s picture

Title: [D7]- PDOException Integrity constraint violation issue when create new user » [D7]-PDOException Integrity constraint violation issue when create new user
Issue summary: View changes

Version: 7.54 » 7.x-dev

Core issues are now filed against the dev versions where changes will be made. Document the specific release you are using in your issue comment. More information about choosing a version.