Advertisement:

Author Topic: Converting a decent decent sized vb 3.8.5 forum  (Read 5954 times)

Offline Bluedreams

  • Newbie
  • *
  • Posts: 7
Converting a decent decent sized vb 3.8.5 forum
« on: January 03, 2015, 08:27:40 PM »
I have a forum with 1.5 million posts, 1 GB database, has anyone successfully done a migration to SMF with something this large? I see posts with people saying they have databases < 100 megs!

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: Converting a decent decent sized vb 3.8.5 forum
« Reply #1 on: January 03, 2015, 08:55:16 PM »
In all honesty, there aren't that many persons with 1+ Million posts ;) Most forums out there our small to medium.

That being said, I successfully converted some vB forums through the years. Conversion is a heavy process on the server but, as long as it takes the "beating", you should have no bigger problems than you would have with a small forum. It just takes a heck lot more time :P
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Antes

  • Evil Black Cat
  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,646
  • Gender: Male
  • Black cat rulz!
    • Antes on GitHub
    • merta on LinkedIn
    • @antesistan on Twitter
    • Lunarfall
Re: Converting a decent decent sized vb 3.8.5 forum
« Reply #2 on: January 03, 2015, 08:58:59 PM »
afaik vb 3.8 converter one of the most stable around. I did conversation years ago went so smooth.
Active Project(s): [ SimpleDesk ] # [ Lunarfall ] # [ CoreStore ]

Past Project(s): [ ezPortal ]

Offline Black Tiger

  • Full Member
  • ***
  • Posts: 519
  • Gender: Male
    • Satellite Fun
Re: Converting a decent decent sized vb 3.8.5 forum
« Reply #3 on: January 04, 2015, 10:12:18 AM »
I agree with the above statements that it's the most stable convertor for converting vBulletin to a free forum software like SMF. Others (like phpbb and mybb) do mess things up and/or give various errors. SMF goes smooth.

However, it shold be mentioned that a lot of things are not converted which I found out the hard way. Some of them are present because of upgrades from older versions of vBulletin to newer versions (I had vBulletin for 14 years).

On my forums also (at least a lot of) birthday dates were not converted.
Internal links are also not converted this should be mentioned.

But you can do that manually after conversion via phpmyadmin or doing a search/replace on the database. These are some examples you should convert manually after doing the main conversion VB to SMF. They will fix the internal links.

Convert (depending on which versions of vbulletin you had, or just do them all, can't do any harm). If you change directory like from /forum/ (VB) to /board/ (SMF) you have to use these directory's in the below examples like this.
Threads:
Code: [Select]
/forum/showthread.php?t=
/forum/showthread.php?threadid=
/forum/showthread.php?s=&threadid=
to
/board/index.php?topic=

Do the same with the examples below.

Boards:
Code: [Select]
forumdisplay.php?s=&forumid=
forumdisplay.php?f=
to
index.php?board=

Memberinfo:
Code: [Select]
member.php?s=&action=getinfo&userid=
to
index.php?action=profile;u=

Private messages:
Code: [Select]
private.php?s=
to
index.php?action=pm

What is still not converted?
1.) Showpost, internal links to specific posts in a thread. Example: showpost.php?p=188162&postcount=7.
You can only fix links to a main post.
Code: [Select]
showpost.php?p=
to
index.php?topic=

I hope you main find this helpfull. I converted 2 vBulletin 3.8.7 pl3 forums to SMF this year.
Greetings, Black Tiger

Offline Bluedreams

  • Newbie
  • *
  • Posts: 7
Re: Converting a decent decent sized vb 3.8.5 forum
« Reply #4 on: June 13, 2016, 09:18:23 AM »
So I ended up finally getting the conversion done after trimming the board down to 700K posts. Other than the feature losses, it went fine, for the most part!

It was not so obvious at first about setting the character set to match vB, and it kept failing on the poll conversion until I found a fix in a thread here.

When I'm more motivated I'll run some of the find and replace stuff in the previous post.