# 500 server error on a specific user profile

**URL:** https://meta.discourse.org/t/500-server-error-on-a-specific-user-profile/119618
**Category:** Self-hosting
**Created:** [June 6, 2019, 12:51am UTC](https://meta.discourse.org/t/500-server-error-on-a-specific-user-profile/119618 "2019-06-06T00:51:33Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![danekhollas](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/danekhollas/32/79637_2.png) [@danekhollas](https://meta.discourse.org/u/danekhollas)
#### Post date: [June 6, 2019, 12:51am UTC](https://meta.discourse.org/t/500-server-error-on-a-specific-user-profile/119618/1 "2019-06-06T00:51:33Z")

</div>

When I or some other user try to access my personal Profile page, I get 500 Internal Server ERROR

 ![image](https://global.discourse-cdn.com/meta/original/3X/7/9/7961062e35419a89a576afabbc6bdc1cd81132fa.png)

**Profiles of other users (mods or regular) are fine.**  
The error persist in [safe mode](https://meta.discourse.org/t/53504?silent=true) and I am running the latest test-passed. Interestingly, if you try to access it as an anonymous user, it is fine.  
[https://forum.khanovaskola.cz/u/danekhollas/activity](https://forum.khanovaskola.cz/u/danekhollas/activity)

There are two errors in logs:

```plaintext
`PG::InvalidParameterValue (ERROR: invalid value for parameter "default_text_search_config": "pg_catalog.czech"
CONTEXT: parallel worker
)
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-1.0.2/lib/patches/db/pg.rb:113:in `async_exec'

```

> **Backtrace**
>
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-1.0.2/lib/patches/db/pg.rb:113:in `async_exec' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-1.0.2/lib/patches/db/pg.rb:113:in `async\_exec’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/mini\_sql-0.2.2/lib/mini\_sql/postgres/connection.rb:118:in `run' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/mini_sql-0.2.2/lib/mini_sql/postgres/connection.rb:82:in `query’  
> (eval):6:in `query' /var/www/discourse/app/models/user_action.rb:240:in `stream’  
> /var/www/discourse/app/controllers/user\_actions\_controller.rb:27:in `index' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action_controller/metal/basic_implicit_render.rb:6:in `send\_action’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/abstract\_controller/base.rb:194:in `process_action' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action_controller/metal/rendering.rb:30:in `process\_action’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/abstract\_controller/callbacks.rb:42:in `block in process_action' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:132:in `run\_callbacks’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/abstract\_controller/callbacks.rb:41:in `process_action' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action_controller/metal/rescue.rb:22:in `process\_action’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action\_controller/metal/instrumentation.rb:34:in `block in process_action' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.3/lib/active_support/notifications.rb:168:in `block in instrument’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.3/lib/active\_support/notifications/instrumenter.rb:23:in `instrument' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.3/lib/active_support/notifications.rb:168:in `instrument’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action\_controller/metal/instrumentation.rb:32:in `process_action' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action_controller/metal/params_wrapper.rb:256:in `process\_action’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active\_record/railties/controller\_runtime.rb:24:in `process_action' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/abstract_controller/base.rb:134:in `process’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionview-5.2.3/lib/action\_view/rendering.rb:32:in `process' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-1.0.2/lib/mini_profiler/profiling_methods.rb:104:in `block in profile\_method’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action\_controller/metal.rb:191:in `dispatch' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action_controller/metal.rb:252:in `dispatch’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action\_dispatch/routing/route\_set.rb:52:in `dispatch' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action_dispatch/routing/route_set.rb:34:in `serve’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action\_dispatch/journey/router.rb:52:in `block in serve' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action_dispatch/journey/router.rb:35:in `each’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action\_dispatch/journey/router.rb:35:in `serve' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action_dispatch/routing/route_set.rb:840:in `call’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-protection-2.0.5/lib/rack/protection/frame\_options.rb:31:in `call' /var/www/discourse/lib/middleware/omniauth_bypass_middleware.rb:32:in `call’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.7/lib/rack/tempfile\_reaper.rb:15:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.7/lib/rack/conditional_get.rb:25:in `call’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.7/lib/rack/head.rb:12:in `call' /var/www/discourse/lib/content_security_policy/middleware.rb:12:in `call’  
> /var/www/discourse/lib/middleware/anonymous\_cache.rb:220:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.7/lib/rack/session/abstract/id.rb:232:in `context’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.7/lib/rack/session/abstract/id.rb:226:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action_dispatch/middleware/cookies.rb:670:in `call’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action\_dispatch/middleware/callbacks.rb:28:in `block in call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:98:in `run\_callbacks’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action\_dispatch/middleware/callbacks.rb:26:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action_dispatch/middleware/debug_exceptions.rb:61:in `call’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action\_dispatch/middleware/show\_exceptions.rb:33:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/logster-2.3.0/lib/logster/middleware/reporter.rb:30:in `call’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-5.2.3/lib/rails/rack/logger.rb:38:in `call_app' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-5.2.3/lib/rails/rack/logger.rb:28:in `call’  
> /var/www/discourse/config/initializers/100-quiet\_logger.rb:18:in `call' /var/www/discourse/config/initializers/100-silence_logger.rb:31:in `call’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action\_dispatch/middleware/remote\_ip.rb:81:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action_dispatch/middleware/request_id.rb:27:in `call’  
> /var/www/discourse/lib/middleware/enforce\_hostname.rb:17:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.7/lib/rack/method_override.rb:22:in `call’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-5.2.3/lib/action\_dispatch/middleware/executor.rb:14:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.7/lib/rack/sendfile.rb:111:in `call’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-1.0.2/lib/mini\_profiler/profiler.rb:281:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/message_bus-2.2.0/lib/message_bus/rack/middleware.rb:57:in `call’  
> /var/www/discourse/lib/middleware/request\_tracker.rb:163:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-5.2.3/lib/rails/engine.rb:524:in `call’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-5.2.3/lib/rails/railtie.rb:190:in `public_send' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-5.2.3/lib/rails/railtie.rb:190:in `method\_missing’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.7/lib/rack/urlmap.rb:68:in `block in call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.7/lib/rack/urlmap.rb:53:in `each’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.7/lib/rack/urlmap.rb:53:in `call' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.5.1/lib/unicorn/http_server.rb:605:in `process\_client’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.5.1/lib/unicorn/http\_server.rb:700:in `worker_loop' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.5.1/lib/unicorn/http_server.rb:548:in `spawn\_missing\_workers’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.5.1/lib/unicorn/http\_server.rb:144:in `start' /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.5.1/bin/unicorn:128:in `\<top (required)\>’  
> /var/www/discourse/vendor/bundle/ruby/2.6.0/bin/unicorn:23:in `load' /var/www/discourse/vendor/bundle/ruby/2.6.0/bin/unicorn:23:in `’

and

```plaintext
Uncaught Error: Internal Server Error
Url: https://forum.khanovaskola.cz/assets/ember_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js
Line: 9
Column: 6919
Window Location: https://forum.khanovaskola.cz/u/danekhollas/activity

```

> **Backtrace**
>
> Error: Internal Server Error  
> at s ([https://forum.khanovaskola.cz/assets/ember\_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:9:7120](https://forum.khanovaskola.cz/assets/ember_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:9:7120))  
> at a ([https://forum.khanovaskola.cz/assets/ember\_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:9:6977](https://forum.khanovaskola.cz/assets/ember_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:9:6977))  
> at o ([https://forum.khanovaskola.cz/assets/ember\_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:9:6868](https://forum.khanovaskola.cz/assets/ember_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:9:6868))  
> at Object.trigger ([https://forum.khanovaskola.cz/assets/ember\_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:18:3648](https://forum.khanovaskola.cz/assets/ember_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:18:3648))  
> at [https://forum.khanovaskola.cz/assets/ember\_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:18:5637](https://forum.khanovaskola.cz/assets/ember_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:18:5637)  
> at t.invoke ([https://forum.khanovaskola.cz/assets/ember\_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:16:6927](https://forum.khanovaskola.cz/assets/ember_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:16:6927))  
> at e.t.flush ([https://forum.khanovaskola.cz/assets/ember\_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:16:5930](https://forum.khanovaskola.cz/assets/ember_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:16:5930))  
> at e.t.flush ([https://forum.khanovaskola.cz/assets/ember\_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:16:7980](https://forum.khanovaskola.cz/assets/ember_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:16:7980))  
> at e.r.\_end ([https://forum.khanovaskola.cz/assets/ember\_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:16:12654](https://forum.khanovaskola.cz/assets/ember_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:16:12654))  
> at e.r.end ([https://forum.khanovaskola.cz/assets/ember\_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:16:9317](https://forum.khanovaskola.cz/assets/ember_jquery-0ae86c6a7527a99c2b9b8a11521273bd9cb4f7d41bc546df081b7ee94f26d9c3.js:16:9317))

Would much appreciate any help, thanks!!

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [June 6, 2019, 7:20am UTC](https://meta.discourse.org/t/500-server-error-on-a-specific-user-profile/119618/2 "2019-06-06T07:20:51Z")

</div>

> [@danekhollas](#):
>
> pg\_catalog.czech

Something is up with this:

> [@danekhollas](#):
>
> invalid value for parameter “default\_text\_search\_config”: “pg\_catalog.czech”

Maybe login to the container and run pg and /dF

> <https://dba.stackexchange.com/questions/206002/how-to-use-full-text-search-in-persian-using-postgresql>

```plaintext
var/discourse# ./launcher enter samsaffron
var/www/discourse# sudo -u postgres psql
psql (10.7 (Ubuntu 10.7-1.pgdg16.04+1))
Type "help" for help.

postgres=# \dF
               List of text search configurations
   Schema | Name | Description              
------------+------------+---------------------------------------
 pg_catalog | danish | configuration for danish language
 pg_catalog | dutch | configuration for dutch language
 pg_catalog | english | configuration for english language
 pg_catalog | finnish | configuration for finnish language
 pg_catalog | french | configuration for french language
 pg_catalog | german | configuration for german language
 pg_catalog | hungarian | configuration for hungarian language
 pg_catalog | italian | configuration for italian language
 pg_catalog | norwegian | configuration for norwegian language
 pg_catalog | portuguese | configuration for portuguese language
 pg_catalog | romanian | configuration for romanian language
 pg_catalog | russian | configuration for russian language
 pg_catalog | simple | simple configuration
 pg_catalog | spanish | configuration for spanish language
 pg_catalog | swedish | configuration for swedish language
 pg_catalog | turkish | configuration for turkish language

```

Our install comes with no pg\_catalog czech, so your db needs to be configured with a support locale or you need to figure out how to install another catalog.

---

<div class="post-metadata">

### Author: ![danekhollas](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/danekhollas/32/79637_2.png) [@danekhollas](https://meta.discourse.org/u/danekhollas)
#### Post date: [June 6, 2019, 8:43am UTC](https://meta.discourse.org/t/500-server-error-on-a-specific-user-profile/119618/3 "2019-06-06T08:43:54Z")

</div>

Thanks @sam!

> [@sam](#):
>
> pg\_catalog.czech

Indeed, we have this line in our `container/app.yml`

```
         db_default_text_search_config: "pg_catalog.czech"

```

But it has been there for ages so it is a bit weird it is making problems only in this specific case now.

I found this Docker image with preconfigured PSQL witch Czech FTS, but I have no idea whether it is feasible or advisable to somehow include in the Discourse Docker install.

db\_default\_text\_search\_config: “pg\_catalog.czech”

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [November 6, 2022, 4:34am UTC](https://meta.discourse.org/t/500-server-error-on-a-specific-user-profile/119618/4 "2022-11-06T04:34:12Z")

</div>


