I just moved a forum from name.com to forum.name.com but it failed: Error: ERROR: duplicate key value violates unique constraint “unique_post_links” DETAIL: Key (topic_id, post_id, url)=(246, 813, http://forum.name.com ) already exists. The remap has only been partially applied due to the error…

[image] AstonJ: Does discourse remap name.com forum.name.com only apply to post content? No, it applies to the entire database. Posts, site settings, themes, uploads, everything.

Ah yeah looking at the full error again now it seems to have gone through these: backup_metadata=1 categories=6 email_logs=306 email_tokens=1 groups=1 incoming_domains=3 incoming_emails=3 javascript_caches=4 post_custom_fields=275 post_revisions=134 posts=441 post_search_data=50 search_logs=8 site_…

[image] AstonJ: can you see anything that should have been done that wasn’t? Not from the output, no. We only output tables with changes. No way to know if a table not in the list because it of the error, or simply because there were no instances of name.com in the (not listed) table. [im…

Thanks Joshua. Any ideas what the numbers signify? Number of changes? What is the recommended way forward now? Fix the unique constraint error then reverse (go from forum.name.com back to name.com, then back again) or do something else? Edit: done I entered the app and Rails console then deleted…

`discourse remap` failed

Support Self-hosting

jomaxro (Joshua Rosenfeld) March 19, 2020, 3:27am 2

No, it applies to the entire database. Posts, site settings, themes, uploads, everything.

Topic		Replies	Views
Remap failure when changing discourse domain Self-hosting	1	318	May 2, 2024
Error running remap after changing site url Self-hosting sql-query , domains , postgres	12	442	July 3, 2026
Rebake fails when changing the subdomain name only Self-hosting	4	1163	September 10, 2019
Restored Site - URLS need to be corrected, any ideas? Support	11	401	April 11, 2025
Error on attempting to remap links Bug	6	920	November 18, 2023

`discourse remap` failed

Related topics