# \[ipboard.rb\] ERROR: duplicate key value violates unique constraint "import\_ids\_pkey" (PG::UniqueViolation)

**URL:** <https://meta.discourse.org/t/ipboard-rb-error-duplicate-key-value-violates-unique-constraint-import-ids-pkey-pg-uniqueviolation/208492>\
**Category:** Migration\
**Created:** [7 בנובמבר,‏ 2021,‏ 6:54pm UTC](https://meta.discourse.org/t/ipboard-rb-error-duplicate-key-value-violates-unique-constraint-import-ids-pkey-pg-uniqueviolation/208492 "2021-11-07T18:54:29Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![t-e-d-d-y](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/t-e-d-d-y/32/238945_2.png) [@t-e-d-d-y](https://meta.discourse.org/u/t-e-d-d-y)\
**Post date:** [7 בנובמבר,‏ 2021,‏ 6:54pm UTC](https://meta.discourse.org/t/ipboard-rb-error-duplicate-key-value-violates-unique-constraint-import-ids-pkey-pg-uniqueviolation/208492/1 "2021-11-07T18:54:29Z")

</div>

Hello, i’m trying to import an IPB 3.4 forum using _ipboard.rb_, i got this error with topic import :

```plaintext
.rbenv/versions/2.7.1/lib/ruby/gems/2.7.0/gems/rack-mini-profiler-2.3.3/lib/patches/db/pg.rb:56:in `exec': ERROR: duplicate key value violates unique constraint "import_ids_pkey" (PG::UniqueViolation)
DETAIL: Key (val)=(discussion#2264) already exists.

```

I deleted the 2264 topic from sql database and launch the script again, now its ok… but i lost the topic 😭 and 5 or 6 other important topics with the same error. What’s wrong ? How can i import these topics ?

Thanks.

---

_[View the full topic](https://meta.discourse.org/t/ipboard-rb-error-duplicate-key-value-violates-unique-constraint-import-ids-pkey-pg-uniqueviolation/208492)._
