# User cannot signup due to duplicate values in category notification states

**URL:** https://meta.discourse.org/t/user-cannot-signup-due-to-duplicate-values-in-category-notification-states/127444
**Category:** Self-hosting
**Created:** [9월 2, 2019, 10:22오후 UTC](https://meta.discourse.org/t/user-cannot-signup-due-to-duplicate-values-in-category-notification-states/127444 "2019-09-02T22:22:16Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![GI-Joe](https://avatars.discourse-cdn.com/v4/letter/g/3ab097/32.png) [@GI-Joe](https://meta.discourse.org/u/GI-Joe)
#### Post date: [9월 2, 2019, 10:22오후 UTC](https://meta.discourse.org/t/user-cannot-signup-due-to-duplicate-values-in-category-notification-states/127444/1 "2019-09-02T22:22:16Z")

</div>

Hello

Members can’t sign up to the site.

This has started 11 days ago and no new users have been able to join the site ever since this was reported.

Here is the logs I’ve found for this.

 ![discourse%20error%201](https://global.discourse-cdn.com/meta/original/3X/6/0/60dd5900568004ac3745c3665b696c1d4067d880.jpeg)

A little note:  
We have migrated Vbulletin 4 database like 2 months ago to discourse. We never encountered this problem before.

Any help will be highly appreciated.

Thanks

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [9월 2, 2019, 10:24오후 UTC](https://meta.discourse.org/t/user-cannot-signup-due-to-duplicate-values-in-category-notification-states/127444/2 "2019-09-02T22:24:30Z")

</div>

There is another report of this at

> [@Discourse DB Error When Creating New Users via SSO Login](https://meta.discourse.org/t/discourse-db-error-when-creating-new-users-via-sso-login/127442):
>
> Summary Discourse DB constraint error because of duplicate key values generated when users without an account attempt to log in via SSO. Causes internal server error (500) to be seen via external proxy. Discussion On August 28th or 29th, I updated Discourse to the latest beta (v2.4.0.beta2) along with all the installed Discourse plug-ins. Around the same time, I also updated [SeAT](https://github.com/eveseat/seat), and reconfigured Discourse to use a UNIX socket, which the external Apache can proxy/reverse proxy to. Prior to tha…

Anything we can do to assist @sam?

---

<div class="post-metadata">

### Author: ![GI-Joe](https://avatars.discourse-cdn.com/v4/letter/g/3ab097/32.png) [@GI-Joe](https://meta.discourse.org/u/GI-Joe)
#### Post date: [9월 4, 2019, 3:18오전 UTC](https://meta.discourse.org/t/user-cannot-signup-due-to-duplicate-values-in-category-notification-states/127444/3 "2019-09-04T03:18:07Z")

</div>

Reporting back:  
Removing entries in the Watch Category, and Watch first reply category (which both had the same 2 categories) solved the problem.

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [9월 4, 2019, 4:54오전 UTC](https://meta.discourse.org/t/user-cannot-signup-due-to-duplicate-values-in-category-notification-states/127444/4 "2019-09-04T04:54:10Z")

</div>


