:joy::joy: I… version is v1.9.0.beta7 +341 [2017-08-29 15:27:03] ERROR: could not create unique index "index_topic_users_on_topic_id_and_user_id" [2017-08-29 15:27:03] DETAIL: Key (topic_id, user_id)=(59700, 11226) is duplicated. [2017-08-29 15:27:03] ERROR: current transaction is aborted, comm…

now, I just have backup tar.gz, my old server has been resintall OS/ Plz help me .:disappointed_relieved:

I’ve seen a few similar reports like Error (could not create unique index "badges_pkey") attempting to restore backup . I suspect that there is a bug somewhere, but no one has shown a way to replicate it. I think your solution is to do this: Advanced, manual method of manually creating and restoring…

:disappointed_relieved::disappointed_relieved: but the server has reinstll OS, so I lost my forum 50,000 user. :persevere::persevere:

That looks a lot like this one: [תמונה] Update failed due to primary key sequence error installation I’ve tried to update from Version v1.9.0.beta4 +300 to 1.9.0.beta5 by pulling the latest changes (git pull) and try to rebuild the app (./launcher rebuild app), but the mi…

I have fix this. vi .sql file, delete all include 59700 and 11226 :joy::joy::joy: everything is fine.

Error restoring backup "key is duplicated"

תמיכה התקנה

codinghorror (Jeff Atwood) 30 באוגוסט,‏ 2017,‏ 12:16am 5

That looks a lot like this one:

נושא		תגובות	צפיות
Cannot restore database: sql key is duplicated Self-hosting	2	585	30 באוגוסט,‏ 2022
Restore fails - could not create unique index Self-hosting	22	3979	6 ביולי,‏ 2020
"EXCEPTION: psql failed: DETAIL: Key (post_id)=(36946) is duplicated." Self-hosting	8	1243	20 ביוני,‏ 2022
Error on restore: could not create unique index Self-hosting	1	1786	12 במרץ,‏ 2022
Getting this error during restore: `could not create unique index` Self-hosting	3	6908	20 בנובמבר,‏ 2023

Error restoring backup "key is duplicated"

נושאים קשורים