# Database schema issues when migration InvisionBoard v4.3 to Discourse v2.1

**URL:** <https://meta.discourse.org/t/database-schema-issues-when-migration-invisionboard-v4-3-to-discourse-v2-1/95019>\
**Category:** Self-hosting\
**Created:** [17.Август.2018 18:16:21 UTC](https://meta.discourse.org/t/database-schema-issues-when-migration-invisionboard-v4-3-to-discourse-v2-1/95019 "2018-08-17T18:16:21Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)\
**Post date:** [17.Август.2018 18:25:19 UTC](https://meta.discourse.org/t/database-schema-issues-when-migration-invisionboard-v4-3-to-discourse-v2-1/95019/2 "2018-08-17T18:25:19Z")

</div>

> [@oncletom](#):
>
> What version of IPBoard `OLD_FORMAT` is meant for? I don’t have an `ipb_forums_posts` (old format) and I don’t have an `ipb_attachment` either (with v4.3)

Sorry, but I don’t really know. I had one import that had wildly different data than another one that I did.

> [@oncletom](#):
>
> - What is `USERDIR` for?

It gets used to create permalinks for links to user profiles.

> [@oncletom](#):
>
> Does `AVATARS_DIR` implies avatars to be stored locally somewhere, and they are being copied to Discourse from the filesystem, not via HTTP?

I got an archive of the avatar files. The script imports them into Discourse.

> [@oncletom](#):
>
> What are the implications of having `ID_FIRST` being set to `true` ?

Something about the format of URLs on IPB to create permalinks in Discourse. Only `false` does anything.

> [@oncletom](#):
>
> If an install fails, can I re-run it without duplicating previously imported data?

Yes. When data are imported, a `user_custom_field` (or `post_custom_field`) entry is created that keeps it from getting imported again. You can also use `IMPORT_AFTER` to skip data if you know how far a previous run got.

I hope this helps. If you’ve got a budget, feel free to contact me at the email address in my profile. I’d be happy to get this cleaned up a bit more.

---

_[View the full topic](https://meta.discourse.org/t/database-schema-issues-when-migration-invisionboard-v4-3-to-discourse-v2-1/95019)._
