# 복원된 사이트 - URL 수정이 필요합니다. 아이디어가 있으신가요?

**URL:** https://meta.discourse.org/t/restored-site-urls-need-to-be-corrected-any-ideas/350925
**Category:** Support
**Created:** [2월 6, 2025, 6:03오후 UTC](https://meta.discourse.org/t/restored-site-urls-need-to-be-corrected-any-ideas/350925 "2025-02-06T18:03:55Z")
**Posts on this page:** 1
**Showing post:** 8

<div class="post-metadata">

### Author: ![agemo](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@agemo](https://meta.discourse.org/u/agemo)
#### Post date: [4월 8, 2025, 10:45오전 UTC](https://meta.discourse.org/t/restored-site-urls-need-to-be-corrected-any-ideas/350925/8 "2025-04-08T10:45:35Z")

</div>

아직 발생하고 있는 에러는 여기에서 수정이 필요했던 stop 에러와 동일하거나 매우 유사해 보입니다:

> [@중복 키 오류("index post hotlinked media on post id and url md5")로 업그레이드 실패](https://meta.discourse.org/t/upgrade-fails-on-duplicate-key-error-index-post-hotlinked-media-on-post-id-and-url-md5/226002):
>
> 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.…

```plaintext
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 님이 이 문제에 대해 통찰을 주실 수 있을까요?

---

_[View the full topic](https://meta.discourse.org/t/restored-site-urls-need-to-be-corrected-any-ideas/350925)._
