Anusri
(Anusri)
November 25, 2020, 10:40am
1
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 ^
simon
November 25, 2020, 6:45pm
2
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.
2 Likes
Anusri
(Anusri)
November 26, 2020, 11:18am
3
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
1 Like
Falco
(Falco)
November 26, 2020, 4:27pm
4
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.
3 Likes
stujo
(Stu)
May 14, 2021, 12:31am
5
Could this be a postgres version issue? Looks like we need postgres >= 9.6 ?
What version is recommended?
Falco
(Falco)
May 14, 2021, 1:00am
6
PostgreSQL 13 is the recommended.
3 Likes
stujo
(Stu)
May 14, 2021, 4:20am
7
Upgrading to postgres:10 allows the installation to proceed
2 Likes