Hallo,
when I create a new user WSOD appear and in error log I've:
USER:
Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY': INSERT INTO "ab_users_revision" ("uid", "revision_id", "langcode", "revision_default", "revision_user", "revision_created", "revision_log_message") 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); Array ( [:db_insert_placeholder_0] => 14381 [:db_insert_placeholder_1] => 1 [:db_insert_placeholder_2] => it [:db_insert_placeholder_3] => 1 [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => 1729262398 [:db_insert_placeholder_6] => ) in Drupal\mysql\Driver\Database\mysql\ExceptionHandler->handleExecutionException() (line 45 of/core/modules/mysql/src/Driver/Database/mysql/ExceptionHandler.php).
ENTITY:
Drupal\Core\Entity\EntityStorageException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY': INSERT INTO "ab_users_revision" ("uid", "revision_id", "langcode", "revision_default", "revision_user", "revision_created", "revision_log_message") 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); Array ( [:db_insert_placeholder_0] => 14381 [:db_insert_placeholder_1] => 1 [:db_insert_placeholder_2] => it [:db_insert_placeholder_3] => 1 [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => 1729262398 [:db_insert_placeholder_6] => ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (line 817 of /core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
As you can see revision_id is set to 1 instead of 14381. Could be relate to
https://www.drupal.org/project/user_revision/issues/3455541
🐛
Revert/Delete user revision actions cause errors
Needs review
?
Drupal 10.3.2
PHP 8.3.11
Active
2.0
Code
Here I'm, again.
This issue is due a conflict with Legal module. Tested in
Drupal 10.3.2
PHP 8.3.11
User_revision 2.0.0-alpha1
Legal (
https://www.drupal.org/project/legal →
) release 3.0.3 before and then 4.0.0-alpha1
in all test got error, uninstalling Legal error disappear.
In my case, the install did not complete and it just created many problems as you cannot uninstall it once it is installed