I am following the guide here: [תמונה] Install Discourse on Windows for development Developer Guides information_source This tutorial has been tested on Windows 10 and 11. To set up a development environment for Discourse on Windows, you can do it using Windows Subsystem for Linux feature. This setup requires the WSL 2 installation. It is only available in Windows 10 builds 18917 or higher. We’ll assume that you already installed Windows Subsystem for Linux 2 (Ubuntu) on your Windows 10 system. WARNING: Install Ubuntu 18.04, and not 20.04 since some installations will fail on 20.04. For m… When I run bundle exec rake db:create it just errors out and says: [Warning] Discourse recommends developing using Ruby v3.1.3 or above. You are using v2.7.6. PG::UndefinedTable: ERROR: relation "pg_range" does not exist LINE 3: LEFT JOIN pg_range as r ON oid = rngtypid ^ Couldn't create 'discourse_development' database. Please check your configuration. rake aborted! ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation "pg_range" does not exist LINE 3: LEFT JOIN pg_range as r ON oid = rngtypid ^ /home/joecooldoo/.rbenv/versions/2.7.6/bin/bundle:25:in `load' /home/joecooldoo/.rbenv/versions/2.7.6/bin/bundle:25:in ` ' Caused by: PG::UndefinedTable: ERROR: relation "pg_range" does not exist LINE 3: LEFT JOIN pg_range as r ON oid = rngtypid ^ /home/joecooldoo/.rbenv/versions/2.7.6/bin/bundle:25:in `load' /home/joecooldoo/.rbenv/versions/2.7.6/bin/bundle:25:in ` ' Tasks: TOP => db:create (See full trace by running task with --trace) What do I do? I am using WSL 2 and Ubuntu 18.04.5, and PostgreSQL version 9.2

[תמונה] joecooldoo: PostgreSQL version 9.2 That’s very old. You should be running 13.x nowadays.

Not sure it’s the source of your problem, but it will definitely be more compatible :slight_smile:

Now I have this error: [Warning] Discourse recommends developing using Ruby v3.1.3 or above. You are using v2.7.6. PG::UndefinedTable: ERROR: relation "pg_range" does not exist LINE 3: LEFT JOIN pg_range as r ON oid = rngtypid ^ Couldn't create 'discourse_development' database. Please check your configuration. rake aborted! ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation "pg_range" does not exist LINE 3: LEFT JOIN pg_range as r ON oid = rngtypid ^ /home/joecooldoo/.rbenv/versions/2.7.6/bin/bundle:25:in `load' /home/joecooldoo/.rbenv/versions/2.7.6/bin/bundle:25:in ` ' Caused by: PG::UndefinedTable: ERROR: relation "pg_range" does not exist LINE 3: LEFT JOIN pg_range as r ON oid = rngtypid ^ /home/joecooldoo/.rbenv/versions/2.7.6/bin/bundle:25:in `load' /home/joecooldoo/.rbenv/versions/2.7.6/bin/bundle:25:in ` ' Tasks: TOP => db:create (See full trace by running task with --trace)

Rails ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation "pg_range" does not exist LINE 3: LEFT JOIN pg_range as r ON oid = rngtypid ruby-on-rails, ruby, postgresql, activerecord answered by Laurenz Albe on 06:00AM - 03 Sep 19 UTC According to that SO link you either have an old or corrupt database.

Well, now I’m getting a different error: [Warning] Discourse recommends developing using Ruby v3.1.3 or above. You are using v2.7.6. We could not find your database: postgres. Which can be found in the database configuration file located at config/database.yml. To resolve this issue: - Did you create the database for this app, or delete it? You may need to create your database. - Has the database name changed? Check your database.yml config has the correct database name. To create your database, run: bin/rails db:create Couldn't create 'discourse_development' database. Please check your configuration. rake aborted! ActiveRecord::NoDatabaseError: We could not find your database: postgres. Which can be found in the database configuration file located at config/database.yml. To resolve this issue: - Did you create the database for this app, or delete it? You may need to create your database. - Has the database name changed? Check your database.yml config has the correct database name. To create your database, run: bin/rails db:create /home/joecooldoo/.rbenv/versions/2.7.6/bin/bundle:25:in `load' /home/joecooldoo/.rbenv/versions/2.7.6/bin/bundle:25:in ` ' Caused by: PG::ConnectionBad: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory Is the server running locally and accepting connections on that socket? /home/joecooldoo/.rbenv/versions/2.7.6/bin/bundle:25:in `load' /home/joecooldoo/.rbenv/versions/2.7.6/bin/bundle:25:in ` ' Tasks: TOP => db:create (See full trace by running task with --trace)

So I descided to follow this guide: [תמונה] Install Discourse for development using Docker Developer Guides Developing using Docker Since Discourse runs in Docker, you should be able to run Discourse directly from your source directory using a Discourse development container. white_check_mark Pros: No need to install any system dependencies, no configuration needed at all for setting up a development environment quickly. x Cons: Will be slightly slower than the native dev environment on Ubuntu, and much slower than a native install on MacOS. See also Developing Discourse using a Dev Container … I get this error after the “migrating database” message: Migrating database... rake aborted! Discourse::Utils::CommandError: /src/lib/discourse.rb:134:in `exec': mkdir: cannot create directory ‘/src/public/plugins/’: Permission denied /src/lib/discourse.rb:168:in `execute_command' /src/lib/discourse.rb:134:in `exec' /src/lib/discourse.rb:30:in `execute_command' /src/lib/plugin/instance.rb:727:in `activate!' /src/lib/discourse.rb:337:in `block in activate_plugins!' /src/lib/discourse.rb:334:in `each' /src/lib/discourse.rb:334:in `activate_plugins!' /src/config/application.rb:216:in `block in ' /src/lib/plugin.rb:6:in `initialization_guard' /src/config/application.rb:216:in ` ' /src/config/application.rb:75:in ` ' /src/config/application.rb:74:in ` ' /home/discourse/.bundle/gems/ruby/3.1.0/gems/bootsnap-1.15.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require' /home/discourse/.bundle/gems/ruby/3.1.0/gems/bootsnap-1.15.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require' /src/Rakefile:7:in ` ' (See full trace by running task with --trace)

I’m still having problems with this, any solutions?

PG::UndefinedTable: שגיאה: היחס "pg_range" אינו קיים

מפתח

joecooldoo 11 בינואר,‏ 2023,‏ 7:07pm 7

How do I create a new one, then? I have never used PostgreSQL before.

נושא		תגובות	צפיות
Relation "selected" does not exist with external Postgres Self-hosting	5	1192	24 ביולי,‏ 2019
PG::UndefinedTable: ERROR: relation "translation_overrides" does not exist Development	4	4146	20 במאי,‏ 2026
How to troubleshoot database errors in an outdated plugin? Development	5	514	29 בפברואר,‏ 2024
Failed to handle exception in exception app middleware : PG::UndefinedTable: ERROR: relation "themes" does not exist Product Support	2	927	7 בפברואר,‏ 2019
Rake db:migrate error Product Support	3	738	13 במאי,‏ 2019

PG::UndefinedTable: שגיאה: היחס "pg_range" אינו קיים

נושאים קשורים