# 新用户无法注册
**URL:** https://meta.discourse.org/t/new-users-unable-to-sign-up/205210
**Category:** Support
**Created:** [2021年十月5日 00:15 UTC](https://meta.discourse.org/t/new-users-unable-to-sign-up/205210 "2021-10-05T00:15:50Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@debryc](https://meta.discourse.org/u/debryc)
#### Post date: [2021年十月5日 00:15 UTC](https://meta.discourse.org/t/new-users-unable-to-sign-up/205210/1 "2021-10-05T00:15:50Z")
我在我的 Discourse 站点上遇到了问题：[hub.youthpowercoalition.org](http://hub.youthpowercoalition.org)
有些人无法注册。我目前只进行了有限的测试，但这_可能_仅适用于包含数字的电子邮件？
错误消息：“出错了，也许用户名或电子邮件已注册。尝试使用忘记密码链接。”
我们_肯定_使用的是尚未注册的电子邮件。
我们该如何排查此问题？
---
### Author:  [@Simsnet](https://meta.discourse.org/u/Simsnet)
#### Post date: [2021年十月5日 03:20 UTC](https://meta.discourse.org/t/new-users-unable-to-sign-up/205210/2 "2021-10-05T03:20:17Z")
> [@debryc](#):
>
> 这可能仅适用于包含数字的电子邮件地址。
我尝试在电子邮件中强制加入一些数字，但无论是否包含数字，注册均失败。
请检查账户或数据库日志区域是否有任何问题（仅您可访问）：[https://hub.youthpowercoalition.org/logs](https://hub.youthpowercoalition.org/logs)
---
### Author:  [@debryc](https://meta.discourse.org/u/debryc)
#### Post date: [2021年十月5日 13:29 UTC](https://meta.discourse.org/t/new-users-unable-to-sign-up/205210/3 "2021-10-05T13:29:55Z")
> [@Simsnet](#):
>
> 尝试查看日志区域中是否有与账户或数据库相关的问题（仅您有权访问）：[https://hub.youthpowercoalition.org/logs](https://hub.youthpowercoalition.org/logs)
我之前不知道有这个区域，谢谢！
以下是最近日志的截图。
以下是仅来自周一的日志详情
```plaintext
Message
ActionDispatch::Http::MimeNegotiation::InvalidType ("%{#context['com.opensymphony.xwork2.dispatcher.httpservletresponse'].addheader('s2qz25z5'" 不是有效的 MIME 类型)
lib/middleware/omniauth_bypass_middleware.rb:71:in `call'
lib/content_security_policy/middleware.rb:12:in `call'
lib/middleware/anonymous_cache.rb:353:in `call'
config/initializers/100-quiet_logger.rb:23:in `call'
config/initializers/100-silence_logger.rb:31:in `call'
lib/middleware/enforce_hostname.rb:23:in `call'
lib/middleware/request_tracker.rb:187:in `call'
Backtrace
actionpack (6.1.4.1) lib/action_dispatch/http/mime_negotiation.rb:31:in `rescue in block in content_mime_type'
actionpack (6.1.4.1) lib/action_dispatch/http/mime_negotiation.rb:24:in `block in content_mime_type'
rack (2.2.3) lib/rack/request.rb:69:in `fetch'
rack (2.2.3) lib/rack/request.rb:69:in `fetch_header'
actionpack (6.1.4.1) lib/action_dispatch/http/mime_negotiation.rb:23:in `content_mime_type'
actionpack (6.1.4.1) lib/action_dispatch/http/request.rb:269:in `media_type'
actionpack (6.1.4.1) lib/action_dispatch/http/request.rb:355:in `form_data?'
rack (2.2.3) lib/rack/request.rb:445:in `POST'
actionpack (6.1.4.1) lib/action_dispatch/http/request.rb:400:in `block (2 levels) in POST'
actionpack (6.1.4.1) lib/action_dispatch/http/parameters.rb:88:in `parse_formatted_parameters'
Env
HTTP HOSTS: hub.youthpowercoalition.org
```
```plaintext
Message (3 copies reported)
ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "idx_category_users_user_id_category_id"
DETAIL: Key (user_id, category_id)=(150, 43) already exists.
)
app/models/user.rb:1589:in `set_default_categories_preferences'
app/models/invite_redeemer.rb:73:in `create_user_from_invite'
app/models/invite_redeemer.rb:123:in `get_invited_user'
app/models/invite_redeemer.rb:87:in `invited_user'
app/models/invite_redeemer.rb:167:in `approve_account_if_needed'
app/models/invite_redeemer.rb:91:in `process_invitation'
app/models/invite_redeemer.rb:8:in `block in redeem'
app/models/invite_redeemer.rb:6:in `redeem'
app/models/invite.rb:193:in `redeem'
app/controllers/invites_controller.rb:274:in `perform_accept_invitation'
app/controllers/application_controller.rb:397:in `block in with_resolved_locale'
app/controllers/application_controller.rb:397:in `with_resolved_locale'
lib/middleware/omniauth_bypass_middleware.rb:71:in `call'
lib/content_security_policy/middleware.rb:12:in `call'
lib/middleware/anonymous_cache.rb:355:in `call'
config/initializers/100-quiet_logger.rb:23:in `call'
config/initializers/100-silence_logger.rb:31:in `call'
lib/middleware/enforce_hostname.rb:23:in `call'
lib/middleware/request_tracker.rb:187:in `call'
Backtrace
rack-mini-profiler (2.3.3) lib/patches/db/pg.rb:69:in `exec_params'
rack-mini-profiler (2.3.3) lib/patches/db/pg.rb:69:in `exec_params'
activerecord (6.1.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:672:in `block (2 levels) in exec_no_cache'
activesupport (6.1.4.1) lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
activesupport (6.1.4.1) lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
activesupport (6.1.4.1) lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
activerecord (6.1.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:671:in `block in exec_no_cache'
activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract_adapter.rb:696:in `block (2 levels) in log'
activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
Env
HTTP HOSTS: hub.youthpowercoalition.org
```
```plaintext
Message (3 copies reported)
Failed to handle exception in exception app middleware : PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "idx_category_users_user_id_category_id"
DETAIL: Key (user_id, category_id)=(150, 43) already exists.
Backtrace
rack-mini-profiler-2.3.3/lib/patches/db/pg.rb:69:in `exec_params'
rack-mini-profiler-2.3.3/lib/patches/db/pg.rb:69:in `exec_params'
activerecord-6.1.4.1/lib/active_record/connection_adapters/postgresql_adapter.rb:672:in `block (2 levels) in exec_no_cache'
activesupport-6.1.4.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
activesupport-6.1.4.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
activesupport-6.1.4.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
activerecord-6.1.4.1/lib/active_record/connection_adapters/postgresql_adapter.rb:671:in `block in exec_no_cache'
activerecord-6.1.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:696:in `block (2 levels) in log'
activesupport-6.1.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
activesupport-6.1.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
```
```plaintext
Message
Job exception: One of the users you are sending this message to could not be found.
Backtrace
/var/www/discourse/lib/post_creator.rb:257:in `create!'
/var/www/discourse/lib/post_creator.rb:290:in `create!'
/var/www/discourse/plugins/discourse-narrative-bot/autoload/jobs/send_default_welcome_message.rb:14:in `execute'
/var/www/discourse/app/jobs/base.rb:232:in `block (2 levels) in perform'
/var/www/discourse/vendor/bundle/ruby/2.7.0/gems/rails_multisite-3.1.0/lib/rails_multisite/connection_management.rb:80:in `with_connection'
/var/www/discourse/app/jobs/base.rb:221:in `block in perform'
/var/www/discourse/app/jobs/base.rb:217:in `each'
/var/www/discourse/app/jobs/base.rb:217:in `perform'
/var/www/discourse/vendor/bundle/ruby/2.7.0/gems/sidekiq-6.2.2/lib/sidekiq/processor.rb:196:in `execute_job'
/var/www/discourse/vendor/bundle/ruby/2.7.0/gems/sidekiq-6.2.2/lib/sidekiq/processor.rb:164:in `block (2 levels) in process'
```
---
### Author:  [@debryc](https://meta.discourse.org/u/debryc)
#### Post date: [2021年十月5日 23:44 UTC](https://meta.discourse.org/t/new-users-unable-to-sign-up/205210/4 "2021-10-05T23:44:24Z")
我们的网站管理员通过这个论坛找到了解决方案！谢谢大家。
> [@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/2?u=debryc):
>
> This relates to this code: What happened here is that we amended the index on category user like so: Do you have a group that is both default watched and default tracked in site settings. Look at: default categories watching default categories tracking default categories muted and default categories watching first post, This fixes it: diff --git a/app/models/user.rb b/app/models/user.rb index c1a94949a6..85b2ca9244 100644 --- a/app/models/user.rb +++ b/app/models/user.rb @@ -1390,10 +13…
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [2021年十一月4日 23:44 UTC](https://meta.discourse.org/t/new-users-unable-to-sign-up/205210/5 "2021-11-04T23:44:30Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.