Integrity constraint violation: 1048 Column 'name' cannot be null: INSERT INTO "users_field_data"

Drupal\Core\Entity\EntityStorageException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'name' cannot be null: INSERT INTO "users_field_data" ("uid", "langcode", "preferred_langcode", "preferred_admin_langcode", "name", "pass", "mail", "timezone", "status", "created", "changed", "access", "login", "init", "default_langcode") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14); Array ( [:db_insert_placeholder_0] => 2 [:db_insert_placeholder_1] => en [:db_insert_placeholder_2] => en [:db_insert_placeholder_3] => en [:db_insert_placeholder_4] => [:db_insert_placeholder_5] => $S$EFIAnKtKRkloPXpNEsIJHHseTq9sbrexp5teMVwa0C8dUp6YUJoD [:db_insert_placeholder_6] => [:db_insert_placeholder_7] => UTC [:db_insert_placeholder_8] => 1 [:db_insert_placeholder_9] => 1668076587 [:db_insert_placeholder_10] => 1668076729 [:db_insert_placeholder_11] => 0 [:db_insert_placeholder_12] => 0 [:db_insert_placeholder_13] => [:db_insert_placeholder_14] => 1 ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (line 811 of /drupal/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).

/** * {@inheritdoc} */ public function submitForm(array &$form, FormStateInterface $form_state) { $user = $form_state->getFormObject()->getEntity(); $user->setPassword($form_state->getValue('pass')); $user->save(); $this->messenger()->addStatus($this->t('Your password has been changed.')); }

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Comment about 1 year ago →
🇮🇳India sarguna raj M
++

I'm also facing the same issue. Is there any update?

Thanks.
Comment about 1 year ago →
🇮🇳India sarguna raj M
Status changed to Needs review about 1 year ago5:05am 6 June 2023
Comment about 1 year ago →
🇮🇳India rajneeshb New Delhi
Created patch to fix the issue.
Comment about 1 year ago →
🇮🇳India Deepesh151086
Hi above patch is solving the issue
Comment 10 months ago →
🇮🇳India narendra.rajwar27 India
narendra.rajwar27 → made their first commit to this issue’s fork.
Comment 10 months ago →
🇮🇳India ashishsahu3847
Still not working.
Comment 10 months ago →
🇨🇳China zterry95
#10 patch not works in my case.
Here is new patch, it's a temporary solution. but it works.
Comment 10 months ago →
🇨🇳China zterry95
Comment 9 months ago →
🇨🇳China zterry95
Comment 4 months ago →
🇶🇦Qatar harivenuv Qatar
First of all i'm not using this module, but i faced the same issue. This issue due to the user object not loaded correctly on the form, possibly due to a missing of user ID from the route used in your form. This problem often arises in Ajax callbacks button, where the route name and user parameter should be passed through the Ajax's URL property.

'#ajax' => [ 'callback' => 'custom_user__back_to_step_2', 'url' => Url::fromRoute('custom_user.user_edit', ['user' => $user->id()]), 'options' => [ 'query' => [ FormBuilderInterface::AJAX_FORM_REQUEST => TRUE, ], ], ],
Comment 11 days ago →
🇺🇸United States fskreuz
#15 solves a related issue regarding Password Policy's password_username constraint.

Because change_pwd_page separates the password form from the user edit form, the name field is not present. Password Policy treats the missing name field as a blank string, causing it to fail the password_username constraint. Adding the name field as a hidden field works.

Integrity constraint violation: 1048 Column 'name' cannot be null: INSERT INTO "users_field_data"

Problem/Motivation

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

Comments & Activities