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?

[image] stujo: What version is recommended? PostgreSQL 13 is the recommended.

Discourse Local setup

Development

stujo (Stu) May 14, 2021, 4:20am 7

Upgrading to postgres:10 allows the installation to proceed

Topic		Replies	Views
Error with update stable 2.4.1 to stable 2.5.1 Self-hosting	1	646	September 3, 2020
Error while doing discourse setup Self-hosting	11	3339	October 6, 2017
Can't run my Discourse locally Development	17	5450	May 7, 2017
Getting error while creating postgress create user Self-hosting	5	813	April 17, 2019
Update problem : Broken Forum Self-hosting server-resources	26	2881	May 12, 2022

Discourse Local setup

Related topics