I’m having the following problem. I’ve been running a Discourse forum for over 10 years, and since I haven’t been able to install updates for some time now, I wanted to set up a new server: Old server is running: 3.4.0.beta4-dev New server: Latest version The backup is already 673.2 MB in size as…

Hello and wow, welcome back after 9 years! Pretty cool to see such a long running forum. I think this is the same index problem as talked about here: Can't restore due to corrupt indexes (with some clues on how to deal with corrupt indexes) It’s something like this: The incoming_referers table t…

Thank you very much for the quick response; I’ll give that a try!

Sorry to bother you, but I seem to be doing something wrong—after running the command “discourse=# select * from incoming_referers where path LIKE ‘%/search/’ ORDER BY incoming_domain_id;”, I’m getting a syntax error.

Did you type “discourse=#”? If so, try again without that

Then I get the error message “bash: syntax error near unexpected token `from’” For reference, I’m currently at: root@community-app:/var/www/discourse#

[afbeelding] Michael_Furtenbach: Then I get the error message “bash: syntax error near unexpected token `from’” For reference, I’m currently at: root@community-app:/var/www/discourse# Ah , you’re not in the DB yet. First run psql -U discourse discourse (I think) And then the prompt should …

Okay, I’ve now also installed “apt install postgresql-client-common.” However, I’m still getting the error “Error: You must install at least one postgresql-client- package.”

Okay that I don’t know. Maybe try directly via the rails console then: rails c with ActiveRecord::Base.connection.execute(<<~SQL) SELECT id, path, incoming_domain_id FROM incoming_referers WHERE path = '//' AND incoming_domain_id = 5 SQL That may give you the same without going throug…

I’m really, really sorry for acting so stupid. I’ve now installed Rails, and it seems to have worked. I also ran it with “rails c”. That seems to work too, but when I enter the command, it looks like this: “root@community:/var/discourse# ActiveRecord::Base.connection.execute(<<~SQL) -bash: syntax…

Backup restoration fails

Ondersteuning Installatie

chapoi 16 juni 2026 om 10:45 8

Ah , you’re not in the DB yet.

First run psql -U discourse discourse (I think)

And then the prompt should change to discourse=#

Topic		Antwoorden	Weergaven
Restore fails: could not create unique index Self-hosting	10	1284	13 februari 2022
Restore fails - could not create unique index Self-hosting	21	4045	4 juli 2020
Error on restore: could not create unique index Self-hosting	1	1804	12 maart 2022
Error restoring backup "key is duplicated" Self-hosting	7	1872	30 augustus 2017
Error importing backup: "could not create unique index" Self-hosting	6	1068	1 november 2021

Backup restoration fails

Gerelateerde topics