Hello! No changes were made on the site. New users started reporting about this error: PG::UniqueViolation (ERROR: duplicate key value violates unique constraint "idx_category_users_category_id_user_id" DETAIL: Key (category_id, user_id)=(55, 1691) already exists. ) app/models/user.rb In details: …

[图片] Ed_Bobkov: set_default_categories_preferences Looks like your automatic watching groups have a duplicate in them. Not sure how this is possible, but can you try resetting the site setting for auto watching ?

Dear Sam, you are great! I caused this problem myself. I set a default watch category for users with Trust_level_0. This created a problem and signups failed. So I deleted the watched category for this group and now signups are working.

[图片] Ed_Bobkov: I set a default watch category for users with Trust_level_0 I did the same and facing the same problem. New registrations are not possible. But are we not using the feature as intended? I want new users instantly watch a certain category. How can I realize that?

Nope, I didn’t come out how to do it. Maybe it’s possible with groups? Add new users to a specific group automatically by default and set this group to watch some tag or category. That’s strange to me that we can’t do it with Trust levels. Let me know if you could do it with a group.

The issue is now fixed by the commits below FIX: use correct validation method name for `default_categories_normal`. (#20801) committed 06:10AM - 24 Mar 23 UTC (UTC) [图片] vinothkannans …

注册错误：PG::UniqueViolation (错误：重复键值违反唯一约束

支持

sam (Sam Saffron) 2020 年12 月 7 日 23:51 2

看起来您的自动关注组中存在重复项。不确定这是如何发生的，但您可以尝试重置自动关注的站点设置吗？

How to check what prevents rake migrate?

Unable to sync with Discourse and WordPress

话题		回复	浏览量
Double entry in default watch list @ user preferences -> registration impossible Bug	8	1225	2015 年12 月 28 日
Discourse DB Error When Creating New Users via SSO Login Bug	6	1445	2021 年10 月 6 日
Error: Users can't make new accounts Bug	13	1880	2023 年7 月 6 日
User cannot signup due to duplicate values in category notification states Self-hosting	3	714	2019 年9 月 4 日
Error moving posts (solved) Support	10	1799	2015 年6 月 8 日

注册错误：PG::UniqueViolation (错误：重复键值违反唯一约束

相关话题