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#

[图片] 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 change t…

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…

Don’t worry, maybe my instructions are just not that good :slight_smile: I will say I’m confused when you say you just installed Rails and can’t access your DB. Maybe it’s all different because it’s an older version, but I think I’m out of my depth now too. Anyway, once you’re in rails, the prompt…

备份还原失败

支持安装

Michael_Furtenbach (Michael Furtenbach) 2026 年6 月 16 日 19:25 22

非常感谢！一切都进展得非常顺利，如果没有你的帮助，我肯定毫无希望，而且不久后就不得不痛苦地从头开始重建论坛了！再次感谢！

也要感谢 @chapoi 提供的出色支持！

话题		回复	浏览量
Restore fails: could not create unique index Self-hosting	10	1284	2022 年2 月 13 日
Restore fails - could not create unique index Self-hosting	21	4047	2020 年7 月 4 日
Error restoring backup "key is duplicated" Self-hosting	7	1874	2017 年8 月 30 日
Error on restore: could not create unique index Self-hosting	1	1804	2022 年3 月 12 日
Error importing backup: "could not create unique index" Self-hosting	6	1069	2021 年11 月 1 日

备份还原失败

相关话题