User cannot signup due to duplicate values in category notification states

[GI-Joe]

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.

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

[codinghorror (Jeff Atwood)]

There is another report of this at

Discourse DB Error When Creating New Users via SSO Login

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, and reconfigured Discourse to use a UNIX socket, which the external Apache can proxy/reverse proxy to. Prior to t…

Anything we can do to assist @sam?

[GI-Joe]

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