I’m having an issue on my Discourse site: hub.youthpowercoalition.org Some people are unable to sign-up. I’ve done only limited testing so far, but this may be true only for emails that have numbers in them? Error message: “Something went wrong, perhaps the username or email is already registered. Try the forget password link.” We’re definitely using an email that has not been registered, though. How do we troubleshoot this?

Our site administrator tracked down the solution via this forum! Thank you all. [صورة] Discourse DB Error When Creating New Users via SSO Login Bug 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…

[صورة] debryc: this may be true only for emails that have numbers in them I tried forcing some numbers into my email and signup failed with and without them. Try seeing if there’s any issues according to accounts or the database in the logs area (only you can access this): https://hub.youthpowercoalition.org/logs

[صورة] Simsnet: Try seeing if there’s any issues according to accounts or the database in the logs area (only you can access this): https://hub.youthpowercoalition.org/logs I didn’t know about this area, thank you! Here’s a screenshot of the most recent logs. [Screenshot of Google Chrome (10-5-21, 9-24-09 AM)] Here are details of the logs just from Monday Message ActionDispatch::Http::MimeNegotiation::InvalidType ("%{#context['com.opensymphony.xwork2.dispatcher.httpservletresponse'].addheader('s2qz25z5'" is not a valid MIME type) 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 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 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' 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'

مستخدمون جدد غير قادرين على التسجيل

دعم المنتج

debryc (Deborah Chang) 5 أكتوبر 2021، 11:44م 4

وجد مدير موقعنا الحل عبر هذا المنتدى! شكرًا لكم جميعًا.

الموضوع		الردود	مرات العرض
Error: Users can't make new accounts Bug	12	2246	6 يوليو 2023
User cannot signup due to duplicate values in category notification states Self-hosting	2	788	4 سبتمبر 2019
Discourse DB Error When Creating New Users via SSO Login Bug	6	1537	6 أكتوبر 2021
New signups via Steam login are broken Bug	5	869	10 يوليو 2020
Creating new User error after upgrade PG::UniqueViolation Duplicate Key SSO rest-api	1	901	24 يناير 2023

مستخدمون جدد غير قادرين على التسجيل

الموضوعات ذات الصلة