# Erreur d'inscription : PG::UniqueViolation (ERREUR : la valeur de clé en double viole la contrainte d'unicité

**URL:** <https://meta.discourse.org/t/signup-error-pg-uniqueviolation-error-duplicate-key-value-violates-unique-constraint/172572>\
**Category:** Product Support\
**Created:** [Décembre 7, 2020, 11:34 UTC](https://meta.discourse.org/t/signup-error-pg-uniqueviolation-error-duplicate-key-value-violates-unique-constraint/172572 "2020-12-07T23:34:51Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![vinothkannans](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/vinothkannans/32/86465_2.png) [@vinothkannans](https://meta.discourse.org/u/vinothkannans)\
**Post date:** [Mars 30, 2023, 3:27 UTC](https://meta.discourse.org/t/signup-error-pg-uniqueviolation-error-duplicate-key-value-violates-unique-constraint/172572/7 "2023-03-30T15:27:48Z")

</div>

Le problème est maintenant résolu par les commits ci-dessous

> <https://github.com/discourse/discourse/commit/ed6f7b1e6d9ead915530a7bd193566286889d1c6>
>
> When we renamed the \`default\_categories\_regular\` to \`default\_categories\_normal\` …we missed a site setting validation method. It allowed the duplicate category ids in \`default\_categories\_normal\` site setting and caused the problem in user registration process.
> 
> https://github.com/discourse/discourse/commit/5176c689e953f3c91abf97ec45cd528ef36cdee1

> <https://github.com/discourse/discourse/commit/08ff6eebad83d921ad0d175aa02332fb04333ff7>
>
> \`default\_categories\_\*\` site settings will update the category preferences on use…r creation. But it shouldn't update the user's category preference if a group's setting already updated it for that user.

---

_[View the full topic](https://meta.discourse.org/t/signup-error-pg-uniqueviolation-error-duplicate-key-value-violates-unique-constraint/172572)._
