# Error: Users can't make new accounts

**URL:** https://meta.discourse.org/t/error-users-cant-make-new-accounts/252981
**Category:** Bug
**Created:** [January 26, 2023, 2:40pm UTC](https://meta.discourse.org/t/error-users-cant-make-new-accounts/252981 "2023-01-26T14:40:14Z")
**Posts on this page:** 14
**Page:** 1

<div class="post-metadata">

### Author: ![minami](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/minami/32/290724_2.png) [@minami](https://meta.discourse.org/u/minami)
#### Post date: [January 26, 2023, 2:40pm UTC](https://meta.discourse.org/t/error-users-cant-make-new-accounts/252981/1 "2023-01-26T14:40:14Z")

</div>

Hi! We have recently experienced an error that have us stumped. Maybe somebody has an idea what is causing it. We’d appreciate any help.

Thanks!

**Priority/Severity** : Sever

**Platform** : Discourse 3.1.0.beta2 (latest)

**Description** : Users cannot create new accounts.

The recent event that we have done is to upgrade the Lightsail instance (Ubuntu 20.4) to another with higher specs (make snapshot, create instance from snapshot).

Everything went well, although the signup error may have starter before that, we were just unaware of it (it’s a 2-month-old BBS).

We have tried it in [safe mode](https://meta.discourse.org/t/53504?silent=true), same thing happens. Used different email accounts, from different IP addresses, and different devices, same result.

**Reproducible steps** : Visit site, try to register new account.

> **[Timog BBS](https://timog.net)**

**Relevant screenshots** :

 ![image](https://global.discourse-cdn.com/meta/original/4X/8/f/8/8f849dff55437e13b713b0977cf713a1ab1a60fe.png)

---

<div class="post-metadata">

### Author: ![minami](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/minami/32/290724_2.png) [@minami](https://meta.discourse.org/u/minami)
#### Post date: [January 26, 2023, 2:40pm UTC](https://meta.discourse.org/t/error-users-cant-make-new-accounts/252981/2 "2023-01-26T14:40:54Z")

</div>

I could only embed one image, so here’s another:

 ![image](https://global.discourse-cdn.com/meta/original/4X/a/6/5/a65e969580c68501edde528088fb2a64e54d373f.png)

Besides plugins, we have DiscoTOC and Discourse Docs Card Filter components installed.

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [January 26, 2023, 2:48pm UTC](https://meta.discourse.org/t/error-users-cant-make-new-accounts/252981/3 "2023-01-26T14:48:09Z")

</div>

I saw a similar error with Discourse Encrypt some time ago that didn’t give any visible errors in the console, but it doesn’t look like you have that plugin. Are there any errors in your `/logs`?

For the similar previous case, registering with an invite proved to be more revealing if you can give that a shot?

> [@Account creation not working with discourse\_encrypt](https://meta.discourse.org/t/account-creation-not-working-with-discourse-encrypt/246520/4):
>
> I tried to register with invite and it dropped me finally an Internal Server Error slightly_smiling_face With the following error in /logs [Screenshot 2022-11-23 at 11.05.09] play_button Infoplay_button Backtrace Which is probably related with [Discourse Encrypt (for Private Messages)](https://meta.discourse.org/t/discourse-encrypt-for-private-messages/107918) plugin it was an update 12 days ago so when I first updated the site yesterday this is also updated. This plugin is installed on my site but is disabled. I try to comment out in app.yml and see how it works. …

---

<div class="post-metadata">

### Author: ![minami](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/minami/32/290724_2.png) [@minami](https://meta.discourse.org/u/minami)
#### Post date: [January 26, 2023, 2:59pm UTC](https://meta.discourse.org/t/error-users-cant-make-new-accounts/252981/4 "2023-01-26T14:59:27Z")

</div>

Thanks for checking it out! Yes, I read that other topic but it looked very different from mine.

I tried with invite code, same result.

 ![image](https://global.discourse-cdn.com/meta/original/4X/7/6/5/7658df3f03712e9299db6bd73ed1338a8448c479.png)

---

<div class="post-metadata">

### Author: ![minami](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/minami/32/290724_2.png) [@minami](https://meta.discourse.org/u/minami)
#### Post date: [January 26, 2023, 3:00pm UTC](https://meta.discourse.org/t/error-users-cant-make-new-accounts/252981/5 "2023-01-26T15:00:59Z")

</div>

Here are my error logs.

 ![image](https://global.discourse-cdn.com/meta/original/4X/b/5/2/b528caaed55ac0dae1d4365bff15abe128687670.png)

---

<div class="post-metadata">

### Author: ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [January 26, 2023, 3:34pm UTC](https://meta.discourse.org/t/error-users-cant-make-new-accounts/252981/6 "2023-01-26T15:34:26Z")

</div>

you can

```
 tail -f /var/discourse/shared/standalone/log/rails/production.log

```

and see what you see when you try to create an account.

---

<div class="post-metadata">

### Author: ![Don](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/don/32/228726_2.png) [@Don](https://meta.discourse.org/u/Don)
#### Post date: [January 26, 2023, 3:40pm UTC](https://meta.discourse.org/t/error-users-cant-make-new-accounts/252981/7 "2023-01-26T15:40:15Z")

</div>

Hello @minami,

> [@Account creation not working with discourse\_encrypt](https://meta.discourse.org/t/account-creation-not-working-with-discourse-encrypt/246520/4):
>
> I tried to register with invite

Here, the invite means create an invite link on `yoursite/my/invited/pending` page and try to register with that link on the invites page. So not on the modal. Sorry I wasn’t too clear with it. Hopefully this way you get some relevant errors on `/logs`.  
.

---

<div class="post-metadata">

### Author: ![minami](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/minami/32/290724_2.png) [@minami](https://meta.discourse.org/u/minami)
#### Post date: [January 26, 2023, 3:56pm UTC](https://meta.discourse.org/t/error-users-cant-make-new-accounts/252981/8 "2023-01-26T15:56:11Z")

</div>

Okay I tried the invite link and got an internal server error.

![image](https://global.discourse-cdn.com/meta/original/4X/e/d/f/edf4cf8fb41c71d7627c423b9979df0b11529fc2.png)

> **Info**
>
> ```plaintext
> Failed to handle exception in exception app middleware : ActiveRecord::RecordNotUnique : PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "idx_category_users_user_id_categor
> 
> 12:44 am
> 
> rack-mini-profiler (3.0.0) lib/patches/db/pg.rb:69:in `exec_params'
> 
> rack-mini-profiler (3.0.0) lib/patches/db/pg.rb:69:in `exec_params'
> 
> activerecord (7.0.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:768:in `block (2 levels) in exec_no_cache'
> 
> activesupport (7.0.4.1) lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
> 
> activesupport (7.0.4.1) lib/active_support/dependencies/interlock.rb:41:in `permit_concurrent_loads'
> 
> activerecord (7.0.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:767:in `block in exec_no_cache'
> 
> activesupport (7.0.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
> 
> activesupport (7.0.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
> 
> activesupport (7.0.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
> 
> activesupport (7.0.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
> 
> activerecord (7.0.4.1) lib/active_record/connection_adapters/abstract_adapter.rb:765:in `block in log'
> 
> activesupport (7.0.4.1) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
> 
> activerecord (7.0.4.1) lib/active_record/connection_adapters/abstract_adapter.rb:756:in `log'
> 
> activerecord (7.0.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:766:in `exec_no_cache'
> 
> activerecord (7.0.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:745:in `execute_and_clear'
> 
> activerecord (7.0.4.1) lib/active_record/connection_adapters/postgresql/database_statements.rb:54:in `exec_query'
> 
> activerecord (7.0.4.1) lib/active_record/connection_adapters/abstract/database_statements.rb:150:in `exec_insert_all'
> 
> activerecord (7.0.4.1) lib/active_record/connection_adapters/abstract/query_cache.rb:22:in `exec_insert_all'
> 
> activerecord (7.0.4.1) lib/active_record/insert_all.rb:41:in `execute'
> 
> activerecord (7.0.4.1) lib/active_record/persistence.rb:213:in `insert_all!'
> 
> app/models/user.rb:1961:in `set_default_categories_preferences'
> 
> activesupport (7.0.4.1) lib/active_support/callbacks.rb:400:in `block in make_lambda'
> 
> activesupport (7.0.4.1) lib/active_support/callbacks.rb:236:in `block in halting_and_conditional'
> 
> activesupport (7.0.4.1) lib/active_support/callbacks.rb:599:in `block in invoke_after'
> 
> activesupport (7.0.4.1) lib/active_support/callbacks.rb:599:in `each'
> 
> activesupport (7.0.4.1) lib/active_support/callbacks.rb:599:in `invoke_after'
> 
> activesupport (7.0.4.1) lib/active_support/callbacks.rb:108:in `run_callbacks'
> 
> activesupport (7.0.4.1) lib/active_support/callbacks.rb:929:in `_run_create_callbacks'
> 
> activerecord (7.0.4.1) lib/active_record/callbacks.rb:461:in `_create_record'
> 
> activerecord (7.0.4.1) lib/active_record/timestamp.rb:108:in `_create_record'
> 
> activerecord (7.0.4.1) lib/active_record/persistence.rb:1067:in `create_or_update'
> 
> activerecord (7.0.4.1) lib/active_record/callbacks.rb:457:in `block in create_or_update'
> 
> activesupport (7.0.4.1) lib/active_support/callbacks.rb:118:in `block in run_callbacks'
> 
> activerecord (7.0.4.1) lib/active_record/autosave_association.rb:370:in `around_save_collection_association'
> 
> activesupport (7.0.4.1) lib/active_support/callbacks.rb:127:in `block in run_callbacks'
> 
> activesupport (7.0.4.1) lib/active_support/callbacks.rb:138:in `run_callbacks'
> 
> activesupport (7.0.4.1) lib/active_support/callbacks.rb:929:in `_run_save_callbacks'
> 
> activerecord (7.0.4.1) lib/active_record/callbacks.rb:457:in `create_or_update'
> 
> activerecord (7.0.4.1) lib/active_record/timestamp.rb:126:in `create_or_update'
> 
> activerecord (7.0.4.1) lib/active_record/persistence.rb:648:in `save!'
> 
> activerecord (7.0.4.1) lib/active_record/validations.rb:53:in `save!'
> 
> activerecord (7.0.4.1) lib/active_record/transactions.rb:302:in `block in save!'
> 
> activerecord (7.0.4.1) lib/active_record/transactions.rb:354:in `block in with_transaction_returning_status'
> 
> activerecord (7.0.4.1) lib/active_record/connection_adapters/abstract/database_statements.rb:314:in `transaction'
> 
> activerecord (7.0.4.1) lib/active_record/transactions.rb:350:in `with_transaction_returning_status'
> 
> activerecord (7.0.4.1) lib/active_record/transactions.rb:302:in `save!'
> 
> activerecord (7.0.4.1) lib/active_record/suppressor.rb:54:in `save!'
> 
> app/models/invite_redeemer.rb:155:in `create_user_from_invite'
> 
> app/models/invite_redeemer.rb:219:in `invited_user'
> 
> app/models/invite_redeemer.rb:273:in `add_user_to_groups'
> 
> app/models/invite_redeemer.rb:237:in `process_invitation'
> 
> app/models/invite_redeemer.rb:56:in `block in redeem'
> 
> activerecord (7.0.4.1) lib/active_record/connection_adapters/abstract/transaction.rb:319:in `block in within_new_transaction'
> 
> activesupport (7.0.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
> 
> activesupport (7.0.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
> 
> activesupport (7.0.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
> 
> activesupport (7.0.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
> 
> activerecord (7.0.4.1) lib/active_record/connection_adapters/abstract/transaction.rb:317:in `within_new_transaction'
> 
> activerecord (7.0.4.1) lib/active_record/connection_adapters/abstract/database_statements.rb:316:in `transaction'
> 
> activerecord (7.0.4.1) lib/active_record/transactions.rb:209:in `transaction'
> 
> app/models/invite_redeemer.rb:54:in `redeem'
> 
> app/models/invite.rb:226:in `redeem'
> 
> app/controllers/invites_controller.rb:284:in `perform_accept_invitation'
> 
> actionpack (7.0.4.1) lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'
> 
> actionpack (7.0.4.1) lib/abstract_controller/base.rb:215:in `process_action'
> 
> actionpack (7.0.4.1) lib/action_controller/metal/rendering.rb:53:in `process_action'
> 
> actionpack (7.0.4.1) lib/abstract_controller/callbacks.rb:234:in `block in process_action'
> 
> activesupport (7.0.4.1) lib/active_support/callbacks.rb:118:in `block in run_callbacks'
> 
> app/controllers/application_controller.rb:414:in `block in with_resolved_locale'
> 
> i18n (1.12.0) lib/i18n.rb:322:in `with_locale'
> 
> app/controllers/application_controller.rb:414:in `with_resolved_locale'
> 
> activesupport (7.0.4.1) lib/active_support/callbacks.rb:127:in `block in run_callbacks'
> 
> activesupport (7.0.4.1) lib/active_support/callbacks.rb:138:in `run_callbacks'
> 
> actionpack (7.0.4.1) lib/abstract_controller/callbacks.rb:233:in `process_action'
> 
> actionpack (7.0.4.1) lib/action_controller/metal/rescue.rb:22:in `process_action'
> 
> actionpack (7.0.4.1) lib/action_controller/metal/instrumentation.rb:67:in `block in process_action'
> 
> activesupport (7.0.4.1) lib/active_support/notifications.rb:206:in `block in instrument'
> 
> activesupport (7.0.4.1) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
> 
> activesupport (7.0.4.1) lib/active_support/notifications.rb:206:in `instrument'
> 
> actionpack (7.0.4.1) lib/action_controller/metal/instrumentation.rb:66:in `process_action'
> 
> actionpack (7.0.4.1) lib/action_controller/metal/params_wrapper.rb:259:in `process_action'
> 
> activerecord (7.0.4.1) lib/active_record/railties/controller_runtime.rb:27:in `process_action'
> 
> actionpack (7.0.4.1) lib/abstract_controller/base.rb:151:in `process'
> 
> actionview (7.0.4.1) lib/action_view/rendering.rb:39:in `process'
> 
> rack-mini-profiler (3.0.0) lib/mini_profiler/profiling_methods.rb:85:in `block in profile_method'
> 
> actionpack (7.0.4.1) lib/action_controller/metal.rb:188:in `dispatch'
> 
> actionpack (7.0.4.1) lib/action_controller/metal.rb:251:in `dispatch'
> 
> actionpack (7.0.4.1) lib/action_dispatch/routing/route_set.rb:49:in `dispatch'
> 
> actionpack (7.0.4.1) lib/action_dispatch/routing/route_set.rb:32:in `serve'
> 
> actionpack (7.0.4.1) lib/action_dispatch/journey/router.rb:50:in `block in serve'
> 
> actionpack (7.0.4.1) lib/action_dispatch/journey/router.rb:32:in `each'
> 
> actionpack (7.0.4.1) lib/action_dispatch/journey/router.rb:32:in `serve'
> 
> actionpack (7.0.4.1) lib/action_dispatch/routing/route_set.rb:852:in `call'
> 
> lib/middleware/omniauth_bypass_middleware.rb:74:in `call'
> 
> rack (2.2.6.2) lib/rack/tempfile_reaper.rb:15:in `call'
> 
> rack (2.2.6.2) lib/rack/conditional_get.rb:40:in `call'
> 
> rack (2.2.6.2) lib/rack/head.rb:12:in `call'
> 
> actionpack (7.0.4.1) lib/action_dispatch/http/permissions_policy.rb:38:in `call'
> 
> lib/content_security_policy/middleware.rb:12:in `call'
> 
> lib/middleware/anonymous_cache.rb:369:in `call'
> 
> rack (2.2
> 
> ```

> **Backtrace**
>
> ```plaintext
> rack-mini-profiler-3.0.0/lib/patches/db/pg.rb:69:in `exec_params'
> 
> rack-mini-profiler-3.0.0/lib/patches/db/pg.rb:69:in `exec_params'
> 
> activerecord-7.0.4.1/lib/active_record/connection_adapters/postgresql_adapter.rb:768:in `block (2 levels) in exec_no_cache'
> 
> activesupport-7.0.4.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
> 
> activesupport-7.0.4.1/lib/active_support/dependencies/interlock.rb:41:in `permit_concurrent_loads'
> 
> activerecord-7.0.4.1/lib/active_record/connection_adapters/postgresql_adapter.rb:767:in `block in exec_no_cache'
> 
> activesupport-7.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
> 
> activesupport-7.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
> 
> activesupport-7.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
> 
> activesupport-7.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
> 
> activerecord-7.0.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:765:in `block in log'
> 
> activesupport-7.0.4.1/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
> 
> activerecord-7.0.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:756:in `log'
> 
> activerecord-7.0.4.1/lib/active_record/connection_adapters/postgresql_adapter.rb:766:in `exec_no_cache'
> 
> activerecord-7.0.4.1/lib/active_record/connection_adapters/postgresql_adapter.rb:745:in `execute_and_clear'
> 
> activerecord-7.0.4.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:54:in `exec_query'
> 
> activerecord-7.0.4.1/lib/active_record/connection_adapters/abstract/database_statements.rb:150:in `exec_insert_all'
> 
> activerecord-7.0.4.1/lib/active_record/connection_adapters/abstract/query_cache.rb:22:in `exec_insert_all'
> 
> activerecord-7.0.4.1/lib/active_record/insert_all.rb:41:in `execute'
> 
> activerecord-7.0.4.1/lib/active_record/persistence.rb:213:in `insert_all!'
> 
> /var/www/discourse/app/models/user.rb:1961:in `set_default_categories_preferences'
> 
> activesupport-7.0.4.1/lib/active_support/callbacks.rb:400:in `block in make_lambda'
> 
> activesupport-7.0.4.1/lib/active_support/callbacks.rb:236:in `block in halting_and_conditional'
> 
> activesupport-7.0.4.1/lib/active_support/callbacks.rb:599:in `block in invoke_after'
> 
> activesupport-7.0.4.1/lib/active_support/callbacks.rb:599:in `each'
> 
> activesupport-7.0.4.1/lib/active_support/callbacks.rb:599:in `invoke_after'
> 
> activesupport-7.0.4.1/lib/active_support/callbacks.rb:108:in `run_callbacks'
> 
> activesupport-7.0.4.1/lib/active_support/callbacks.rb:929:in `_run_create_callbacks'
> 
> activerecord-7.0.4.1/lib/active_record/callbacks.rb:461:in `_create_record'
> 
> activerecord-7.0.4.1/lib/active_record/timestamp.rb:108:in `_create_record'
> 
> activerecord-7.0.4.1/lib/active_record/persistence.rb:1067:in `create_or_update'
> 
> activerecord-7.0.4.1/lib/active_record/callbacks.rb:457:in `block in create_or_update'
> 
> activesupport-7.0.4.1/lib/active_support/callbacks.rb:118:in `block in run_callbacks'
> 
> activerecord-7.0.4.1/lib/active_record/autosave_association.rb:370:in `around_save_collection_association'
> 
> activesupport-7.0.4.1/lib/active_support/callbacks.rb:127:in `block in run_callbacks'
> 
> activesupport-7.0.4.1/lib/active_support/callbacks.rb:138:in `run_callbacks'
> 
> activesupport-7.0.4.1/lib/active_support/callbacks.rb:929:in `_run_save_callbacks'
> 
> activerecord-7.0.4.1/lib/active_record/callbacks.rb:457:in `create_or_update'
> 
> activerecord-7.0.4.1/lib/active_record/timestamp.rb:126:in `create_or_update'
> 
> activerecord-7.0.4.1/lib/active_record/persistence.rb:648:in `save!'
> 
> activerecord-7.0.4.1/lib/active_record/validations.rb:53:in `save!'
> 
> activerecord-7.0.4.1/lib/active_record/transactions.rb:302:in `block in save!'
> 
> activerecord-7.0.4.1/lib/active_record/transactions.rb:354:in `block in with_transaction_returning_status'
> 
> activerecord-7.0.4.1/lib/active_record/connection_adapters/abstract/database_statements.rb:314:in `transaction'
> 
> activerecord-7.0.4.1/lib/active_record/transactions.rb:350:in `with_transaction_returning_status'
> 
> activerecord-7.0.4.1/lib/active_record/transactions.rb:302:in `save!'
> 
> activerecord-7.0.4.1/lib/active_record/suppressor.rb:54:in `save!'
> 
> /var/www/discourse/app/models/invite_redeemer.rb:155:in `create_user_from_invite'
> 
> /var/www/discourse/app/models/invite_redeemer.rb:219:in `invited_user'
> 
> /var/www/discourse/app/models/invite_redeemer.rb:273:in `add_user_to_groups'
> 
> /var/www/discourse/app/models/invite_redeemer.rb:237:in `process_invitation'
> 
> /var/www/discourse/app/models/invite_redeemer.rb:56:in `block in redeem'
> 
> activerecord-7.0.4.1/lib/active_record/connection_adapters/abstract/transaction.rb:319:in `block in within_new_transaction'
> 
> activesupport-7.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
> 
> activesupport-7.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
> 
> activesupport-7.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
> 
> activesupport-7.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
> 
> activerecord-7.0.4.1/lib/active_record/connection_adapters/abstract/transaction.rb:317:in `within_new_transaction'
> 
> activerecord-7.0.4.1/lib/active_record/connection_adapters/abstract/database_statements.rb:316:in `transaction'
> 
> activerecord-7.0.4.1/lib/active_record/transactions.rb:209:in `transaction'
> 
> /var/www/discourse/app/models/invite_redeemer.rb:54:in `redeem'
> 
> /var/www/discourse/app/models/invite.rb:226:in `redeem'
> 
> /var/www/discourse/app/controllers/invites_controller.rb:284:in `perform_accept_invitation'
> 
> actionpack-7.0.4.1/lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'
> 
> actionpack-7.0.4.1/lib/abstract_controller/base.rb:215:in `process_action'
> 
> actionpack-7.0.4.1/lib/action_controller/metal/rendering.rb:53:in `process_action'
> 
> actionpack-7.0.4.1/lib/abstract_controller/callbacks.rb:234:in `block in process_action'
> 
> activesupport-7.0.4.1/lib/active_support/callbacks.rb:118:in `block in run_callbacks'
> 
> /var/www/discourse/app/controllers/application_controller.rb:414:in `block in with_resolved_locale'
> 
> i18n-1.12.0/lib/i18n.rb:322:in `with_locale'
> 
> /var/www/discourse/app/controllers/application_controller.rb:414:in `with_resolved_locale'
> 
> activesupport-7.0.4.1/lib/active_support/callbacks.rb:127:in `block in run_callbacks'
> 
> activesupport-7.0.4.1/lib/active_support/callbacks.rb:138:in `run_callbacks'
> 
> actionpack-7.0.4.1/lib/abstract_controller/callbacks.rb:233:in `process_action'
> 
> actionpack-7.0.4.1/lib/action_controller/metal/rescue.rb:22:in `process_action'
> 
> actionpack-7.0.4.1/lib/action_controller/metal/instrumentation.rb:67:in `block in process_action'
> 
> activesupport-7.0.4.1/lib/active_support/notifications.rb:206:in `block in instrument'
> 
> activesupport-7.0.4.1/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
> 
> activesupport-7.0.4.1/lib/active_support/notifications.rb:206:in `instrument'
> 
> actionpack-7.0.4.1/lib/action_controller/metal/instrumentation.rb:66:in `process_action'
> 
> actionpack-7.0.4.1/lib/action_controller/metal/params_wrapper.rb:259:in `process_action'
> 
> activerecord-7.0.4.1/lib/active_record/railties/controller_runtime.rb:27:in `process_action'
> 
> actionpack-7.0.4.1/lib/abstract_controller/base.rb:151:in `process'
> 
> actionview-7.0.4.1/lib/action_view/rendering.rb:39:in `process'
> 
> rack-mini-profiler-3.0.0/lib/mini_profiler/profiling_methods.rb:85:in `block in profile_method'
> 
> actionpack-7.0.4.1/lib/action_controller/metal.rb:188:in `dispatch'
> 
> actionpack-7.0.4.1/lib/action_controller/metal.rb:251:in `dispatch'
> 
> actionpack-7.0.4.1/lib/action_dispatch/routing/route_set.rb:49:in `dispatch'
> 
> actionpack-7.0.4.1/lib/action_dispatch/routing/route_set.rb:32:in `serve'
> 
> actionpack-7.0.4.1/lib/action_dispatch/journey/router.rb:50:in `block in serve'
> 
> actionpack-7.0.4.1/lib/action_dispatch/journey/router.rb:32:in `each'
> 
> actionpack-7.0.4.1/lib/action_dispatch/journey/router.rb:32:in `serve'
> 
> actionpack-7.0.4.1/lib/action_dispatch/routing/route_set.rb:852:in `call'
> 
> /var/www/discourse/lib/middleware/omniauth_bypass_middleware.rb:74:in `call'
> 
> rack-2.2.6.2/lib/rack/tempfile_reaper.rb:15:in `call'
> 
> rack-2.2.6.2/lib/rack/conditional_get.rb:40:in `call'
> 
> rack-2.2.6.2/lib/rack/head.rb:12:in `call'
> 
> actionpack-7.0.4.1/lib/action_dispatch/http/permissions_policy.rb:38:in `call'
> 
> /var/www/discourse/lib/content_security_policy/middleware.rb:12:in `call'
> 
> /var/www/discourse/lib/middleware/anonymous_cache.rb:369:in `call'
> 
> rack-2.2.6.2/lib/rack/session/abstract/id.rb:266:in `context'
> 
> rack-2.2.6.2/lib/rack/session/abstract/id.rb:260:in `call'
> 
> actionpack-7.0.4.1/lib/action_dispatch/middleware/cookies.rb:704:in `call'
> 
> actionpack-7.0.4.1/lib/action_dispatch/middleware/callbacks.rb:27:in `block in call'
> 
> activesupport-7.0.4.1/lib/active_support/callbacks.rb:99:in `run_callbacks'
> 
> actionpack-7.0.4.1/lib/action_dispatch/middleware/callbacks.rb:26:in `call'
> 
> actionpack-7.0.4.1/lib/action_dispatch/middleware/debug_exceptions.rb:28:in `call'
> 
> actionpack-7.0.4.1/lib/action_dispatch/middleware/show_exceptions.rb:26:in `call'
> 
> logster-2.11.3/lib/logster/middleware/reporter.rb:43:in `call'
> 
> railties-7.0.4.1/lib/rails/rack/logger.rb:40:in `call_app'
> 
> railties-7.0.4.1/lib/rails/rack/logger.rb:27:in `call'
> 
> /var/www/discourse/config/initializers/100-quiet_logger.rb:20:in `call'
> 
> /var/www/discourse/config/initializers/100-si
> 
> ```

---

<div class="post-metadata">

### Author: ![minami](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/minami/32/290724_2.png) [@minami](https://meta.discourse.org/u/minami)
#### Post date: [January 26, 2023, 3:57pm UTC](https://meta.discourse.org/t/error-users-cant-make-new-accounts/252981/9 "2023-01-26T15:57:14Z")

</div>

Imma try that next 😄

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [January 26, 2023, 4:01pm UTC](https://meta.discourse.org/t/error-users-cant-make-new-accounts/252981/10 "2023-01-26T16:01:15Z")

</div>

I see something about `set_default_categories_preferences` in there. Could you try resetting those and see if that helps?

I see a similar issue here:

> [@Signup error: PG::UniqueViolation (ERROR: duplicate key value violates unique constraint](https://meta.discourse.org/t/signup-error-pg-uniqueviolation-error-duplicate-key-value-violates-unique-constraint/172572/3):
>
> 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.

---

<div class="post-metadata">

### Author: ![minami](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/minami/32/290724_2.png) [@minami](https://meta.discourse.org/u/minami)
#### Post date: [January 26, 2023, 4:20pm UTC](https://meta.discourse.org/t/error-users-cant-make-new-accounts/252981/11 "2023-01-26T16:20:37Z")

</div>

I reset the default muted categories and the error was fixed! But why would that affect user signups?! But maybe that’s for another day.

Thanks very much for the help @JammyDodger! I need some sleep 😪

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [January 26, 2023, 4:24pm UTC](https://meta.discourse.org/t/error-users-cant-make-new-accounts/252981/12 "2023-01-26T16:24:18Z")

</div>

No worries. Glad we could help. 🙂

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [July 6, 2023, 11:52am UTC](https://meta.discourse.org/t/error-users-cant-make-new-accounts/252981/14 "2023-07-06T11:52:11Z")

</div>

I believe this situation has now been mitigated by:

[https://github.com/discourse/discourse/pull/20823](https://github.com/discourse/discourse/pull/20823)

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [July 6, 2023, 11:52am UTC](https://meta.discourse.org/t/error-users-cant-make-new-accounts/252981/15 "2023-07-06T11:52:28Z")

</div>


