When I try to login I get: Started POST "/session" for <IP> at 2023-04-07 20:57:15 +0000 Processing by SessionController#create as */* Parameters: {"login"=>"<user>", "password"=>"[FILTERED]", "second_factor_method"=>"1", "timezone"=>"<TIME_ZONE>"} start done Completed 500 Internal Server Error i…

Maybe your Satan’s didn’t get migrated? You can try rake db:migrate You don’t have skip post migrations set, do you? Is this a standard install ?

It was docker setup and Discourse was running fine, I just exported the Docker container and imported it on another server along with the /var/discourse and started it, that’s all. I also executed rake db:migrate but didn’t help.

I don’t think the database files are inside the container, so postgresql is likely to be missing the discourse database if not the entire set of database files. A restore should fix it, as standard postgresql restore should create the discourse database. (But if that fails, try creating the databa…

[image] Islam Bahnasy: just exported the Docker container and imported it on another server along with the /var/discourse and started it, that’s all. That isn’t the correct way to Move your Discourse Instance to a Different Server and will never work.

Unknown Primary Key

Support Self-hosting

pfaffman (Jay Pfaffman) April 9, 2023, 1:57am 4

Did you restore the backup?

Have you tried a rebuild?

Topic		Replies	Views
Error restoring backup "key is duplicated" Self-hosting	7	1959	August 30, 2017
Upgrade failed with "duplicate key value violates unique constraint" error Self-hosting	17	2689	February 29, 2020
"EXCEPTION: psql failed: DETAIL: Key (post_id)=(36946) is duplicated." Self-hosting	7	1331	June 20, 2022
Cannot restore database: sql key is duplicated Self-hosting	2	648	August 30, 2022
Error while importing topics from Flarum (users, groups import OK) Migration flarum	3	1165	September 3, 2021

Unknown Primary Key

Related topics