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. [image] 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…

[image] 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

[image] 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'

Nouveaux utilisateurs incapables de s'inscrire

Assistance produit

debryc (Deborah Chang) Octobre 5, 2021, 11:44 4

Notre administrateur de site a retrouvé la solution grâce à ce forum ! Merci à tous.

Sujet		Réponses	Vues
Error: Users can't make new accounts Bug	12	2246	Juillet 6, 2023
User cannot signup due to duplicate values in category notification states Self-hosting	2	788	Septembre 4, 2019
Discourse DB Error When Creating New Users via SSO Login Bug	6	1537	Octobre 6, 2021
New signups via Steam login are broken Bug	5	869	Juillet 10, 2020
Creating new User error after upgrade PG::UniqueViolation Duplicate Key SSO rest-api	1	901	Janvier 24, 2023

Nouveaux utilisateurs incapables de s'inscrire

Sujets connexes