已恢复的网站 - 需要纠正URL，大家有办法吗？

[agemo]

我仍然遇到的错误似乎与此处需要修复的停止错误重复或非常相似：

Upgrade fails on duplicate key error ("index post hotlinked media on post id and url md5")

Had an automatic rebuild fail, looks like variations on this issue: 2022-05-03 15:30:54.370 UTC [1262] discourse@discourse LOG: duration: 1707.909 ms statement: INSERT INTO post_hotlinked_media (post_id, url, status, upload_id, created_at, updated_at) SELECT post_id, obj.key AS url, 'downloaded', obj.value::bigint AS upload_id, pcf.created_at, pcf.updated_at FROM post_custom_fields pcf JOIN json_each_text(pcf.…

Error: ERROR:  duplicate key value violates unique constraint \"index_post_hotlinked_media_on_post_id_and_url_md5\"
DETAIL:  Key (post_id, md5(url::text))=...

在尝试重新映射时：

RAILS_ENV=production discourse remap //sub.domain.com //domain.com

也许 @david 会有见解？