# Flarum to Discourse Migration Script **URL:** \ **Category:** Migration\ **Tags:** flarum\ **Created:** [May 24, 2021, 8:52pm UTC](https://meta.discourse.org/t/flarum-to-discourse-migration-script/191510 "2021-05-24T20:52:09Z")\ **Posts on this page:** 1\ **Showing post:** 10
**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:** [November 22, 2022, 6:19am UTC](https://meta.discourse.org/t/flarum-to-discourse-migration-script/191510/10 "2022-11-22T06:19:06Z")
I got this error ```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) ``` --- _[View the full topic](https://meta.discourse.org/t/flarum-to-discourse-migration-script/191510)._