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#

[image] 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 chang…

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…

Échec de la restauration de la sauvegarde

Soutien Installation

chapoi Juin 16, 2026, 10:45 8

Ah, vous n’êtes pas encore dans la base de données.

Exécutez d’abord psql -U discourse discourse (je crois)

Et ensuite, l’invite de commande devrait passer à discourse=#

Sujet		Réponses	Vues
Restore fails: could not create unique index Self-hosting	10	1284	Février 13, 2022
Restore fails - could not create unique index Self-hosting	21	4046	Juillet 4, 2020
Error on restore: could not create unique index Self-hosting	1	1804	Mars 12, 2022
Error restoring backup "key is duplicated" Self-hosting	7	1872	Août 30, 2017
Error importing backup: "could not create unique index" Self-hosting	6	1068	Novembre 1, 2021

Échec de la restauration de la sauvegarde

Sujets connexes