hi, I have installed discourse in my local using ubuntu software. i cannot run my url its showing below error, plz can any one help me? Error: An error has occurred, all later migrations canceled: PG::SyntaxError: ERROR: syntax error at or near “NOT” LINE 2: ADD COLUMN IF NOT EXISTS image_upload_id bigint ^

I’m probably not the right person to help with this issue, but can you confirm that you installed Discourse on your local server by following this guide: Beginners Guide to Install Discourse on Ubuntu for Development? I’m assuming that you are creating a local development site and not a production site.

Yes, i am following that guide only and creating my local development. i am not able to fix that issue. PG::SyntaxError: ERROR: syntax error at or near “NOT” LINE 2: ADD COLUMN IF NOT EXISTS image_upload_id bigint

What distro are you running? That setup will work on latest Ubuntu and latest LTS Ubuntu. If you are running an older version you will need to add a PostgreSQL PPA in order to get a more recent version.

Could this be a postgres version issue? Looks like we need postgres >= 9.6 ? What version is recommended?

[תמונה] stujo: What version is recommended? PostgreSQL 13 is the recommended.

Upgrading to postgres:10 allows the installation to proceed

הגדרת Discourse מקומית

מפתח

Falco (Falco) 14 במאי,‏ 2021,‏ 1:00am 6

PostgreSQL 13 is the recommended.

נושא		תגובות	צפיות
Error with update stable 2.4.1 to stable 2.5.1 Self-hosting	1	654	3 בספטמבר,‏ 2020
Error while doing discourse setup Self-hosting	11	3362	6 באוקטובר,‏ 2017
Can't run my Discourse locally Development	17	5464	7 במאי,‏ 2017
Getting error while creating postgress create user Self-hosting	5	819	17 באפריל,‏ 2019
Update problem : Broken Forum Self-hosting server-resources	26	2892	12 במאי,‏ 2022

הגדרת Discourse מקומית

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