# vBulletin import script is incompatible with vBulletin5

**URL:** https://meta.discourse.org/t/vbulletin-import-script-is-incompatible-with-vbulletin5/24061
**Category:** Feature
**Created:** [1월 15, 2015, 11:14오후 UTC](https://meta.discourse.org/t/vbulletin-import-script-is-incompatible-with-vbulletin5/24061 "2015-01-15T23:14:27Z")
**Posts on this page:** 13
**Page:** 1

<div class="post-metadata">

### Author: ![tooom](https://avatars.discourse-cdn.com/v4/letter/t/9de0a6/32.png) [@tooom](https://meta.discourse.org/u/tooom)
#### Post date: [1월 15, 2015, 11:14오후 UTC](https://meta.discourse.org/t/vbulletin-import-script-is-incompatible-with-vbulletin5/24061/1 "2015-01-15T23:14:27Z")

</div>

Hi there,

I was trying to use the vbulletin.rb script to import a vBulletin5 database, and I noticed that the table names referenced in the import script are not the same as the ones in the vB5 database.

For instance, the script queries a table called “posts”. There is no such table in the vBulletin5 database.

Also, the vB5 database has a tooon of tables in it. So I doubt it would be all that easy to slightly modify the import script to account for the different names or anything like that.

Is the import script for older versions of vBulletin only? It seems that vB5 is known to be quite different from previous versions, and I’m guessing the new table names are a part of that.

Actually, it doesn’t look like migrating vB5 to anything else is a very common practice at all. Google couldn’t find me many people who have done it successfully, apart from a few sketchy things claiming to offer paid migration services.

Can anyone who has successfully migrated a vBulletin forum to Discourse comment on this?

---

<div class="post-metadata">

### Author: ![zogstrip](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/zogstrip/32/512781_2.png) [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [1월 15, 2015, 11:40오후 UTC](https://meta.discourse.org/t/vbulletin-import-script-is-incompatible-with-vbulletin5/24061/2 "2015-01-15T23:40:38Z")

</div>

> [@tooom](#):
>
> Is the import script for older versions of vBulletin only?

Just checked and the vBulletin import script was done for vBulletin **3.8.7**.

---

<div class="post-metadata">

### Author: ![tooom](https://avatars.discourse-cdn.com/v4/letter/t/9de0a6/32.png) [@tooom](https://meta.discourse.org/u/tooom)
#### Post date: [1월 15, 2015, 11:49오후 UTC](https://meta.discourse.org/t/vbulletin-import-script-is-incompatible-with-vbulletin5/24061/3 "2015-01-15T23:49:49Z")

</div>

Interesting, that must be it, then. Thanks! I wonder if downgrading vBulletin5 is possible.

From what I’ve read, one method is to import vB5 into a third intermediary piece of forum software that understands it, and then import **that** into Discourse. Not sure if it’s worth the effort at this point, but I might give it a whirl.

---

<div class="post-metadata">

### Author: ![zogstrip](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/zogstrip/32/512781_2.png) [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [1월 15, 2015, 11:50오후 UTC](https://meta.discourse.org/t/vbulletin-import-script-is-incompatible-with-vbulletin5/24061/4 "2015-01-15T23:50:52Z")

</div>

Or build your own importer. It takes time but really isn’t that hard 😉

---

<div class="post-metadata">

### Author: ![thump](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/thump/32/38336_2.png) [@thump](https://meta.discourse.org/u/thump)
#### Post date: [1월 16, 2015, 7:25오전 UTC](https://meta.discourse.org/t/vbulletin-import-script-is-incompatible-with-vbulletin5/24061/5 "2015-01-16T07:25:00Z")

</div>

A bad suggestion but you may be able to use an importer script for another forum that there is an importer for to make it work. Just saw the end of your last post - I need to learn to read.

---

<div class="post-metadata">

### Author: ![tooom](https://avatars.discourse-cdn.com/v4/letter/t/9de0a6/32.png) [@tooom](https://meta.discourse.org/u/tooom)
#### Post date: [1월 22, 2015, 10:33오후 UTC](https://meta.discourse.org/t/vbulletin-import-script-is-incompatible-with-vbulletin5/24061/7 "2015-01-22T22:33:28Z")

</div>

Yeah, I’m just a little intimidated by the seemingly high complexity of the vb5 schema. But if I ever have time for it as a side project, could be interesting!

---

<div class="post-metadata">

### Author: ![jamesmarkcook](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jamesmarkcook/32/168563_2.png) [@jamesmarkcook](https://meta.discourse.org/u/jamesmarkcook)
#### Post date: [3월 15, 2015, 10:44오후 UTC](https://meta.discourse.org/t/vbulletin-import-script-is-incompatible-with-vbulletin5/24061/8 "2015-03-15T22:44:40Z")

</div>

I was wondering if anybody knows what this [table](https://github.com/discourse/discourse/blob/master/script/import_scripts/vbulletin.rb#L277) is responsible for?

It does not exist in my installation of vBulletin 4 and I was wondering if it was a vBulletin 3 specific table or if I’m reading the code wrong and it’s not a table at all?

It currently breaks my script after importing pretty much my entire forum so need to figure out if I need it or not. Thanks

---

<div class="post-metadata">

### Author: ![riking](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/riking/32/170938_2.png) [@riking](https://meta.discourse.org/u/riking)
#### Post date: [3월 15, 2015, 11:10오후 UTC](https://meta.discourse.org/t/vbulletin-import-script-is-incompatible-with-vbulletin5/24061/9 "2015-03-15T23:10:29Z")

</div>

That’s a Discourse-side table… What’s the error?

---

<div class="post-metadata">

### Author: ![jamesmarkcook](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jamesmarkcook/32/168563_2.png) [@jamesmarkcook](https://meta.discourse.org/u/jamesmarkcook)
#### Post date: [3월 16, 2015, 6:44오전 UTC](https://meta.discourse.org/t/vbulletin-import-script-is-incompatible-with-vbulletin5/24061/10 "2015-03-16T06:44:41Z")

</div>

Ahh that would be why. I have a prefix on all my tables in vbulletin, so I had to add some code to the script to take this into account.

I added the prefix to this table thinking it was selecting something from vbulletin.

I’ll fix that and give it another go tonight. Thanks

---

<div class="post-metadata">

### Author: ![Mark\_Seifert](https://avatars.discourse-cdn.com/v4/letter/m/ecae2f/32.png) [@Mark\_Seifert](https://meta.discourse.org/u/Mark_Seifert)
#### Post date: [6월 20, 2015, 3:09오전 UTC](https://meta.discourse.org/t/vbulletin-import-script-is-incompatible-with-vbulletin5/24061/11 "2015-06-20T03:09:34Z")

</div>

Has anybody gotten anywhere on the VB5 import issue?

Are there any worthwhile VB5 → some other format → Discourse paths?

Thanks for any input.

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [5월 30, 2016, 6:20오후 UTC](https://meta.discourse.org/t/vbulletin-import-script-is-incompatible-with-vbulletin5/24061/12 "2016-05-30T18:20:55Z")

</div>

I don’t think we have had a business or above hosted customer approach us with this particular conversion scenario quite yet, (it is usually older vBulletin versions) but if they do, we will certainly write the importer and open source it.

---

<div class="post-metadata">

### Author: ![michaeld](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/michaeld/32/1594_2.png) [@michaeld](https://meta.discourse.org/u/michaeld)
#### Post date: [6월 16, 2016, 6:06오전 UTC](https://meta.discourse.org/t/vbulletin-import-script-is-incompatible-with-vbulletin5/24061/13 "2016-06-16T06:06:27Z")

</div>

We had two customers for VB5 in the last month, so we’ve written the importer and open sourced it (pull request is waiting for you 🙂 )

[https://github.com/discourse/discourse/pull/4271](https://github.com/discourse/discourse/pull/4271)

---

<div class="post-metadata">

### Author: ![erlend\_sh](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/erlend_sh/32/119475_2.png) [@erlend\_sh](https://meta.discourse.org/u/erlend_sh)
#### Post date: [8월 5, 2016, 11:49오전 UTC](https://meta.discourse.org/t/vbulletin-import-script-is-incompatible-with-vbulletin5/24061/14 "2016-08-05T11:49:48Z")

</div>


