# Flarum에서 Discourse로 마이그레이션 스크립트 **URL:** https://meta.discourse.org/t/flarum-to-discourse-migration-script/191510 **Category:** Migration **Tags:** flarum **Created:** [5월 24, 2021, 8:52오후 UTC](https://meta.discourse.org/t/flarum-to-discourse-migration-script/191510 "2021-05-24T20:52:09Z") **Posts on this page:** 11 **Page:** 1
### Author: ![Lecter](https://avatars.discourse-cdn.com/v4/letter/l/ecccb3/32.png) [@Lecter](https://meta.discourse.org/u/Lecter) #### Post date: [5월 24, 2021, 8:52오후 UTC](https://meta.discourse.org/t/flarum-to-discourse-migration-script/191510/1 "2021-05-24T20:52:09Z")
안녕하세요, Flarum에서 Discourse로 25,000명 이상의 회원과 250,000개 이상의 게시물이 있는 포럼을 마이그레이션한 과정을 간단히 공유해 보려고 합니다. 이 글을 읽고 계신 분이라면 아실겠지만, Flarum → Discourse를 위한 공식 가져오기(import) 스크립트는 없습니다. 다만 @koen360 님이 호의적으로 FluxBB 가져오기 도구를 수정하여 사용자를 가져오는 방법을 공유해 주셨습니다. 그러나 우리 포럼의 성공은 게시글 내에서 매우 구체적인 용어를 검색하는 사용자들에게 크게 의존하고 있으므로, 게시물도 가져와야 했습니다. 그래서 그렇게 했죠… 실패한 마이그레이션 여러 시간, 두통, 그리고 몇 번의 고생 끝에 말이죠. 저는 마이그레이션 스크립트 작성 전문가라고 할 수는 없지만, 이 스크립트는 작성 시점의 Flarum 현재 버전(V0.1.0-beta.16)에서는 충분히 잘 작동합니다. 이 스크립트(아래 첨부)는 MySQL/MariaDB 데이터베이스에 접근할 수 있어야 하며, 문제가 발생했을 때 프로덕션 사이트를 망치지 않도록 데이터베이스의 복사본을 사용하는 것이 좋습니다. MySQL 연결 부분의 더미 값을 실제 값으로 교체하면 준비 완료입니다. **이 과정을 시작하기 전에 Flarum 데이터베이스 전체를 백업해 두십시오. 문제가 발생하면 되돌릴 수 없을 가능성이 높습니다.** Flarum → Discourse 마이그레이션에 도움이 필요하시면 이 스레드에 답글을 남겨 주세요. 저는 전문가가 아니지만, 가능한 한 도움을 드리겠습니다. > [@Migrate from another forum to Discourse](https://meta.discourse.org/t/migrating-to-discourse-from-another-forum-software/16616): > > mega This guide serves as a high level overview of the migration process. For specifics on the wide range of forum softwares to import, including Vanilla, phpBB3, SMF2, bbPress, and vBulletin, review our [dedicated tutorials](https://meta.discourse.org/tags/c/documentation/10/migrations). Not all scripts have tutorials, but an exhaustive list of available imports is available under the [script/import\_scripts](https://github.com/discourse/discourse/tree/main/script/import_scripts) folder on GitHub. For larger migrations, there is also a faster [script/bulk\_import](https://github.com/discourse/discourse/tree/main/script/bulk_import) system that writes directly to the database. So you want to mi… [가져오기 도구는 여기서 받을 수 있습니다. 처음 작성하는 게시물이라 파일을 업로드할 수 없는 것 같습니다](https://i.lecter.me/flarum_import.zip) ---
### Author: ![justin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/justin/32/157614_2.png) [@justin](https://meta.discourse.org/u/justin) #### Post date: [5월 25, 2021, 12:29오후 UTC](https://meta.discourse.org/t/flarum-to-discourse-migration-script/191510/2 "2021-05-25T12:29:42Z")
@Lecter 님, 스크립트를 만들어 주셔서 감사합니다! `discourse/discourse`에 PR로 제출해 주실 수 있을까요? 아직 Flarum 스크립트가 없어서, 이걸 기반으로 사용하면 도움이 될 것 같습니다. ---
### Author: ![Lecter](https://avatars.discourse-cdn.com/v4/letter/l/ecccb3/32.png) [@Lecter](https://meta.discourse.org/u/Lecter) #### Post date: [5월 25, 2021, 1:40오후 UTC](https://meta.discourse.org/t/flarum-to-discourse-migration-script/191510/3 "2021-05-25T13:40:43Z")
물론입니다! PR이 곧 들어옵니다… ---
### Author: ![oshyan](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/oshyan/32/212644_2.png) [@oshyan](https://meta.discourse.org/u/oshyan) #### Post date: [8월 13, 2021, 8:50오후 UTC](https://meta.discourse.org/t/flarum-to-discourse-migration-script/191510/4 "2021-08-13T20:50:18Z")
정말 좋습니다! 이 가져오기를 한 단계 더 발전시켜 주셔서 감사합니다! 💖 시간이 지나면 태그, 아니 첨부파일이라도 포함할 수 있도록 확장되길 바랍니다. 태그 지원을 추가하는 데 얼마나 많은 작업이 필요할까요? vBulletin 5와 몇 가지 다른 시스템에서 작동 방식에 대한 참고 모델이 있을 것 같긴 하지만, Flarum에 맞게 얼마나 조정해야 할지는 전혀 감이 잡히지 않습니다. 어떤 통찰을 나눠 주셔도 감사하겠습니다. 그리고 실제로 해 봐야만 알 수 있는 부분이어서 답변이 어려우셔도 괜찮습니다. 😄 ---
### Author: ![kovalr](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/kovalr/32/263527_2.png) [@kovalr](https://meta.discourse.org/u/kovalr) #### Post date: [6월 13, 2022, 8:19오후 UTC](https://meta.discourse.org/t/flarum-to-discourse-migration-script/191510/5 "2022-06-13T20:19:21Z")
안녕하세요 @Lecter ! 혹시 스크립트가 아직 유효합니까? 다시 공유해 주실 수 있을까요? 링크가 죽었거든요. ☹ 요청을 검토해 주셔서 감사합니다. ---
### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco) #### Post date: [6월 13, 2022, 8:46오후 UTC](https://meta.discourse.org/t/flarum-to-discourse-migration-script/191510/6 "2022-06-13T20:46:41Z")
@Lecter가 작성한 스크립트는 이제 다음 위치에 있습니다. > ---
### Author: ![kovalr](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/kovalr/32/263527_2.png) [@kovalr](https://meta.discourse.org/u/kovalr) #### Post date: [6월 14, 2022, 3:42오후 UTC](https://meta.discourse.org/t/flarum-to-discourse-migration-script/191510/7 "2022-06-14T15:42:41Z")
마이그레이션에 대해 도움을 주실 분 계신가요? 현재 게시글이 비어 있고 기본 카테고리 3개만 있는 Discourse를 사용하고 있습니다. Flarum에서 Discourse로 SQL을 가져오려고 시도했을 때 아래 오류가 발생했습니다. ```plaintext su discourse -c 'bundle exec ruby script/import_scripts/flarum_import.rb' Loading existing groups... Loading existing users... Loading existing categories... Loading existing posts... Loading existing topics... creating users 13 / 13 (100.0%) [281 items/min] n] importing top level categories... 39 / 39 (100.0%) [420 items/min] n] importing children categories... 39 / 39 (100.0%) [290 items/min] creating topics and posts Traceback (most recent call last): 19: from script/import_scripts/flarum_import.rb:162:in `
' 18: from /var/www/discourse/script/import_scripts/base.rb:47:in `perform' 17: from script/import_scripts/flarum_import.rb:32:in `execute' 16: from script/import_scripts/flarum_import.rb:101:in `import_posts' 15: from /var/www/discourse/script/import_scripts/base.rb:916:in `batches' 14: from /var/www/discourse/script/import_scripts/base.rb:916:in `loop' 13: from /var/www/discourse/script/import_scripts/base.rb:917:in `block in batches' 12: from script/import_scripts/flarum_import.rb:122:in `block in import_posts' 11: from /var/www/discourse/script/import_scripts/base.rb:224:in `all_records_exist?' 10: from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activerecord-7.0.3/lib/active_record/transactions.rb:209:in `transaction' 9: from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activerecord-7.0.3/lib/active_record/connection_adapters/abstract/database_statements.rb:316:in `transaction' 8: from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activerecord-7.0.3/lib/active_record/connection_adapters/abstract/transaction.rb:317:in `within_new_transaction' 7: from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activesupport-7.0.3/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize' 6: from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activesupport-7.0.3/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt' 5: from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activesupport-7.0.3/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize' 4: from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activesupport-7.0.3/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt' 3: from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activerecord-7.0.3/lib/active_record/connection_adapters/abstract/transaction.rb:319:in `block in within_new_transaction' 2: from /var/www/discourse/script/import_scripts/base.rb:231:in `block in all_records_exist?' 1: from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/rack-mini-profiler-3.0.0/lib/patches/db/pg.rb:56:in `exec' /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/rack-mini-profiler-3.0.0/lib/patches/db/pg.rb:56:in `exec': ERROR: duplicate key value violates unique constraint "import_ids_pkey" (PG::UniqueViolation) DETAIL: Key (val)=(7) already exists. 20: from script/import_scripts/flarum_import.rb:162:in `
' 19: from /var/www/discourse/script/import_scripts/base.rb:47:in `perform' 18: from script/import_scripts/flarum_import.rb:32:in `execute' 17: from script/import_scripts/flarum_import.rb:101:in `import_posts' 16: from /var/www/discourse/script/import_scripts/base.rb:916:in `batches' 15: from /var/www/discourse/script/import_scripts/base.rb:916:in `loop' 14: from /var/www/discourse/script/import_scripts/base.rb:917:in `block in batches' 13: from script/import_scripts/flarum_import.rb:122:in `block in import_posts' 12: from /var/www/discourse/script/import_scripts/base.rb:224:in `all_records_exist?' 11: from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activerecord-7.0.3/lib/active_record/transactions.rb:209:in `transaction' 10: from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activerecord-7.0.3/lib/active_record/connection_adapters/abstract/database_statements.rb:316:in `transaction' 9: from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activerecord-7.0.3/lib/active_record/connection_adapters/abstract/transaction.rb:317:in `within_new_transaction' 8: from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activesupport-7.0.3/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize' 7: from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activesupport-7.0.3/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt' 6: from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activesupport-7.0.3/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize' 5: from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activesupport-7.0.3/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt' 4: from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activerecord-7.0.3/lib/active_record/connection_adapters/abstract/transaction.rb:319:in `block in within_new_transaction' 3: from /var/www/discourse/script/import_scripts/base.rb:243:in `block in all_records_exist?' 2: from /var/www/discourse/script/import_scripts/base.rb:243:in `ensure in block in all_records_exist?' 1: from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/rack-mini-profiler-3.0.0/lib/patches/db/pg.rb:56:in `exec' /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/rack-mini-profiler-3.0.0/lib/patches/db/pg.rb:56:in `exec': ERROR: current transaction is aborted, commands ignored until end of transaction block (PG::InFailedSqlTransaction) ``` 문제는 **Key (val)=(7) already exists.** 부분입니다. ```plaintext `exec': ERROR: duplicate key value violates unique constraint "import_ids_pkey" (PG::UniqueViolation) DETAIL: Key (val)=(7) already exists. ``` ```plaintext root@raspberrypi-app:/var/www/discourse# rake db:validate_indexes Starting postgres on port: 11000 Waiting for PG server to start... PG server is ready and DB is loaded Running migrations on blank database! Testing indexes on the default database No missing indexes No extra indexes ``` 이 문제를 어떻게 해결할 수 있을까요? ---
### Author: ![kovalr](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/kovalr/32/263527_2.png) [@kovalr](https://meta.discourse.org/u/kovalr) #### Post date: [6월 14, 2022, 10:18오후 UTC](https://meta.discourse.org/t/flarum-to-discourse-migration-script/191510/8 "2022-06-14T22:18:45Z")
이 SQL 코드가 스크립트를 깨뜨립니다 ```plaintext SELECT p.id id, d.id topic_id, d.title title, d.first_post_id first_post_id, p.user_id user_id, p.content raw, p.created_at created_at, t.tag_id category_id FROM posts p, discussions d, discussion_tag t WHERE p.discussion_id = d.id AND t.discussion_id = d.id ORDER BY p.created_at ``` ![2022-06-15_00h14_06](https://global.discourse-cdn.com/meta/original/4X/1/8/a/18ad71b78f7d0756e41451c63d2ac9105890b1bb.png) ---
### Author: ![kovalr](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/kovalr/32/263527_2.png) [@kovalr](https://meta.discourse.org/u/kovalr) #### Post date: [6월 15, 2022, 4:56오후 UTC](https://meta.discourse.org/t/flarum-to-discourse-migration-script/191510/9 "2022-06-15T16:56:47Z")
문제를 찾았습니다. 제 경우 하나의 게시글에 여러 태그가 지정되어 있었습니다. 그런 게시글을 삭제한 후, 가져오기 스크립트가 오류 없이 처리되었습니다. ---
### Author: ![Bishwas\_Bhandari](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/bishwas_bhandari/32/224559_2.png) [@Bishwas\_Bhandari](https://meta.discourse.org/u/Bishwas_Bhandari) #### Post date: [11월 22, 2022, 6:19오전 UTC](https://meta.discourse.org/t/flarum-to-discourse-migration-script/191510/10 "2022-11-22T06:19:06Z")
다음과 같은 오류가 발생했습니다 ```plaintext ubuntu@ip-172-26-1-78:~/discourse$ bundle exec ruby script/import_scripts/flarum_import.rb Loading existing groups... Loading existing users... Loading existing categories... Loading existing posts... Loading existing topics... creating users Skipping 1000 already imported users Skipping 826 already imported users importing top level categories... 34 / 34 (100.0%) [5728165 items/min] importing children categories... 34 / 34 (100.0%) [3194 items/min] creating topics and posts Traceback (most recent call last): 19: from script/import_scripts/flarum_import.rb:162:in `
' 18: from /home/ubuntu/discourse/script/import_scripts/base.rb:47:in `perform' 17: from script/import_scripts/flarum_import.rb:32:in `execute' 16: from script/import_scripts/flarum_import.rb:101:in `import_posts' 15: from /home/ubuntu/discourse/script/import_scripts/base.rb:916:in `batches' 14: from /home/ubuntu/discourse/script/import_scripts/base.rb:916:in `loop' 13: from /home/ubuntu/discourse/script/import_scripts/base.rb:917:in `block in batches' 12: from script/import_scripts/flarum_import.rb:122:in `block in import_posts' 11: from /home/ubuntu/discourse/script/import_scripts/base.rb:224:in `all_records_exist?' 10: from /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/activerecord-7.0.3.1/lib/active_record/transactions.rb:209:in `transaction' 9: from /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/activerecord-7.0.3.1/lib/active_record/connection_adapters/abstract/database_statements.rb:316:in `transaction' 8: from /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/activerecord-7.0.3.1/lib/active_record/connection_adapters/abstract/transaction.rb:317:in `within_new_transaction' 7: from /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/activesupport-7.0.3.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize' 6: from /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/activesupport-7.0.3.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt' 5: from /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/activesupport-7.0.3.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize' 4: from /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/activesupport-7.0.3.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt' 3: from /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/activerecord-7.0.3.1/lib/active_record/connection_adapters/abstract/transaction.rb:319:in `block in within_new_transaction' 2: from /home/ubuntu/discourse/script/import_scripts/base.rb:231:in `block in all_records_exist?' 1: from /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/rack-mini-profiler-3.0.0/lib/patches/db/pg.rb:56:in `exec' /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/rack-mini-profiler-3.0.0/lib/patches/db/pg.rb:56:in `exec': ERROR: duplicate key value violates unique constraint "import_ids_pkey" (PG::UniqueViolation) DETAIL: Key (val)=(53) already exists. 20: from script/import_scripts/flarum_import.rb:162:in `
' 19: from /home/ubuntu/discourse/script/import_scripts/base.rb:47:in `perform' 18: from script/import_scripts/flarum_import.rb:32:in `execute' 17: from script/import_scripts/flarum_import.rb:101:in `import_posts' 16: from /home/ubuntu/discourse/script/import_scripts/base.rb:916:in `batches' 15: from /home/ubuntu/discourse/script/import_scripts/base.rb:916:in `loop' 14: from /home/ubuntu/discourse/script/import_scripts/base.rb:917:in `block in batches' 13: from script/import_scripts/flarum_import.rb:122:in `block in import_posts' 12: from /home/ubuntu/discourse/script/import_scripts/base.rb:224:in `all_records_exist?' 11: from /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/activerecord-7.0.3.1/lib/active_record/transactions.rb:209:in `transaction' 10: from /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/activerecord-7.0.3.1/lib/active_record/connection_adapters/abstract/database_statements.rb:316:in `transaction' 9: from /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/activerecord-7.0.3.1/lib/active_record/connection_adapters/abstract/transaction.rb:317:in `within_new_transaction' 8: from /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/activesupport-7.0.3.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize' 7: from /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/activesupport-7.0.3.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt' 6: from /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/activesupport-7.0.3.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize' 5: from /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/activesupport-7.0.3.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt' 4: from /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/activerecord-7.0.3.1/lib/active_record/connection_adapters/abstract/transaction.rb:319:in `block in within_new_transaction' 3: from /home/ubuntu/discourse/script/import_scripts/base.rb:243:in `block in all_records_exist?' 2: from /home/ubuntu/discourse/script/import_scripts/base.rb:243:in `ensure in block in all_records_exist?' 1: from /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/rack-mini-profiler-3.0.0/lib/patches/db/pg.rb:56:in `exec' /home/ubuntu/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/rack-mini-profiler-3.0.0/lib/patches/db/pg.rb:56:in `exec': ERROR: current transaction is aborted, commands ignored until end of transaction block (PG::InFailedSqlTransaction) ``` ---
### Author: ![mambonr5](https://avatars.discourse-cdn.com/v4/letter/m/5fc32e/32.png) [@mambonr5](https://meta.discourse.org/u/mambonr5) #### Post date: [2월 21, 2024, 11:37오후 UTC](https://meta.discourse.org/t/flarum-to-discourse-migration-script/191510/11 "2024-02-21T23:37:35Z")
안녕하세요, 어떻게 해결하셨는지 설명해 주실 수 있을까요? 저도 같은 오류를 겪고 있는데, (val)=(7) 대신 다음과 같은 오류가 발생합니다: `exec’: ERROR: duplicate key value violates unique constraint “import\_ids\_pkey” (PG::UniqueViolation) DETAIL: Key (val)=(1) already exists.