YaBB to vbulletin Conversion Instructions: Alas the Holy Grail....

Hi all,

I know I'm new to you guys, but I just bought a vbulletin copy with an eye towards converting my YaBB SP1 system over to something more robust.

I'm a freelance LAN/WAN designer in Chicago, so although I do not consider myself a programmer, I'm fairly savvy when it comes to computers.

There is no new code involved in this process, and everything is done manually with the exception of a few scripts which you can download. I'm not sure all the scripts are GPL, so I'm not sure they can be distributed here...

Here we go:

Software List:

• phpbb version 2.0 RC1 (http://phpbb.sourceforge.com)
• phpbb Version 2.0 Release http://phpbb.sourceforge.com
• vbulletin Version 2.2.6 (Legit Version)
• Webmin (Linux Web Administration Package- or an admin program for mysql http://www.webmin.com)
• YaBB to phpbb Converter Version 1.2.1 (NOT the one they have available for download on www.phpbb.com. Go to the forums, and get the old release off the web page)

Additional Items needed:

• Strong Coffee
• High tolerance for frustration
• Realization that you are crazy, but will do it anyway....
• Excellent Computer Skills

If you do not have, these items- give up, and start your forum over.

Process:

In summary, this is a manual hack. The final product is *pretty* clean. Your user accounts/passwords will all be in place, posts in place, categories in place.

Be prepared.... your permissions are toast. You are going to have to re-group and re permission everything.

Here we go.....

First thing, backup your YaBB Gold/SP1 install, in fact make two backups.

Create a mysql database called "test".

Copy the files for phpbb RC1 to a directory on your web server called: phpbbrc1

Follow the instructions for installing phpbb RC1, and create an admin account (done in installer).

Upload the files and folders from the phpbb>>YaBBsp1 converter into a subfolder of the phpbb folder called "convert" and run the converter (via browser), fill in the requested information, and let her rip. If you have a large board this process will take quite some time. Start drinking the coffee....

The conversion is done... You are wired from coffee.... Now onto more interesting things....

Backup the database called "test"....

Now, create a folder on your web server called "phpbb", copy the files from the phpbb 2.0 RELEASE into that folder. There is a file that goes up with the install called "update_to_FINAL.php". Follow the intructions for UPGRADE which are provided in the release.

(You may see errors in the first stage of the convert- the docs say this can be normal for an upgrade. Make sure there are no errors in the SECOND stage... you'll know it when you see it)

Backup the database, name it "GoldUnaltered.sql"

Now the fun begins....

Go into the admin center of http://yoursite/phpbb (admin center found at the bottom of the phpbb main page after you logon.

Find the page that allows you to "resync" each of the forums/sections. resync everything. Then move all the sections and forums into the order you want them to be in when you convert to vbulletin (This also has the desired effect of re-creating "order numbers" for the forums and sections that were lost in the transition)

Rename your forums and sections (names are set to the cryptic internal names used by YaBB)

Backup your database.

Get some more coffee. Take a break.

Whew- ok now you are back. And now we get to the really hairy part of the whole thing (errr well it could get worse).

You need to have access to either commandline mysql or Web interface for mysql. If you own your server, I like Webmin- since it does everything including apache configuration...

Get into your admin interface and come back to these instructions....

YaBB formats it's data very differently that either phpbb or vbulletin So- read this carefully so you know what the mysql commands are doing.

First off, the conversion to phpbb left a lot of legacy YaBB data in the post fields. This is a problem. This data consists of smileys that no longer exist, formatting tags that are obsolete, "<br>" tags that YaBB ENCODES into the data for line breaks.

For example... go into you phpbb board and find a message long enough to contain line breaks, and edit it. The text that is presented to you has "<br>" tag in it... these have to go or the posts will be really screwed up and crash the vbulletin converter during conversion.

BACKUP YOUR DATABASE: name is GoldenAltered.sql

The command I used for this from webmin (also from command line) to remove the "<br>" tags is:

UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, '<br>', '\n');

Next we have to get rid of the "size" statements which crash the vbulletine converter

Here's the code I used:

PHP Code:

UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, '/size', 'b ');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, '[size=]', 'b '); 


I am using "b" as an arbitrary replacement character... I want the content of my YaBB board... a few stray letters is no problem.

Now we have to force a reformat of the "quote" statements which are sill in the phpbb data

The code I used:

PHP Code:

UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, '[quote ', '[quote] ');
[/quote] 


The previous code allows me to make the YaBB quote statments usable in vbulletin. The original YaBB code looks like this:

PHP Code:

[quote author=Maleficus=ASWP= date=04/09/02 at 13:36:21]I was playing some?? 


PHP Code:

 


The final code looks like this:

PHP Code:

[quote] author=Maleficus=ASWP= date=04/09/02 at 13:36:21]I was playing some??[/quote] 


Ok got that done? Go get some coffee, make a pass at the girlfriend, and go irritate a cop... Lemme know when you get back.

Ok back?

Well now you are ready to do a vbulletin install, and convert the data with the "official" phpbb converter.

First: Buy vbulletin....

Then follow vbulletings instructions for installing! I'm not here for that.

Once you have gone through the install process, and made an admin account on vbulletin, you are read to do the conversion....

Do the conversion.....

Note any errors that occur, and which threads they occur in during the conversion. When the conversion process crashes, it give cryptic, but useful information.... if the conversion does halt on you, note the data- and read on....

Smileys:

YaBB smiley suck... only because they mess up vbulletin. The posts I had problems with during the conversion process were ones where users put 5,000,000 smiles next to one another in all shapes and sizes. There was no rhyme or reason to the failure, and no ongoing pattern to the data. Therefor, using phpbb as my "data editor" I deleted any thread that crashed the conversion.

Did the post conversion work? Good! Read on.....

Bigger problems loom on the horizon....

Once the conversion goes through you are given some information which involves using the maintenance features of vbulletin. USE THEM! They rebuild a lot of lost data/post counts that are missing from the data at that point.

Did you board make it through all those rebuilds?

Well then I *think* you are done. Welcome to the 21st century!

NOTE: I'll be revising this tomorrow morning against my dev notes to see if I'm being accurate. This is the "beta" guide to a decidedly "beta" and totally hacky process.

Also this information is "Thank You Ware". If you use this information and get a system up- I want to hear THANK YOU loud and clear. This took four full days of my life to work out... I expect THANK YOU- I deserve THANK YOU- and I WILL get THANK YOU.

My old board is at http://forums.aswp.net/cgi-bin/YaBB.pl

My new board, when I open it to my org, will be at http://forums.aswp.net

You may take a looksie some time tonight....

UPDATE (July 1st 2003):

PLEASE NOTE:

It appears that in this conversion process that Instant Messages get imported into the wrong mailboxes....

BE AWARE!

I have not found a fix for this, and this could compromise security if you have sensitive information in your IMs....

WARNING WILL ROBINSON..... clear the IM's before importing!!

[Chris M]

Sounds good...

I know someone who is buying a vB, and converting from yaBB, so this could be useful

Satan

[ULTIMATESSJ]

could be helpful for me, as a YaBB forum i have been running for some friends has eben brought down as it isn't really a good forum to use, and i might treat them with a vBulletin, if i have the money to buy another licence, damn mobile phone bills -_-

[beheader]

Note:

Some users have reported getting other people's "legacy" private messages....

New sent PM's are flawless....

No other problems to report...

[beheader]

No other problems thus far.... system up for about 3 days and can be viewed at:

http://forums.aswp.net

Additionally, the data from our old system can be viewed at:

http://forums.aswp.net/beta

[memobug]

I just began this process and appreciate the insights!

1) Is the "phpbb Version 2.0 release" Version 2.0.1?
2) Could you be more specific about where and which convertor to use? The only version of YaBB to phpbb converter I could find was at
http://www.phpbb.com/downloads.php#converters, and the link to the download http://phpbb.sourceforge.net/convert...BB2-v1.2.1.zip was broken. I browsed the convertor directory and found only YaBB2phpBB2.zip (41K-17-Jun-2002). The file comments say
version 1.3.1/MCH (based on original version 1.2.1)

This probably isn't the right one because the readme says

"This version currently assumes you have birthday, gender, and cellphone in your old YaBB board and made at least the Gender, Birthday & Zodiac MODs in phpBB2. The YaBB user's quote will be put into phpBB2's "interest" profile field."

I couldn't find any forum convertor attachments and searched for quite awhile. I'll go back and look some more, but there are 590 matches on "YaBB Convert" and would be helpful if you could give me a more direct link.

update: maybe http://skripmania.hypermart.net/xyz/...BB2-v1.2.1.zip

??

Thanks,

Matt

[beheader]

<a href="http://skripmania.hypermart.net/xyz...pBB2-v1.2.1.zip" target="_blank">http://skripmania.hypermart.net/xyz...pBB2-v1.2.1.zip</a>

Should be the correct one....

[beheader]

UPDATE:

Still functioning- no problems to report...

[memobug]

I'm up and running 100% now and it's great. I sincerely appreciate your hard work on this Beheader, I would not have attempted it if I didn't know it could be done.

Many thanks. Following your instructions for YaBB SE, I was able to import my YaBB Gold board with the following minor limitations, which I think are minor and much more than I'd hoped for.

1) Passwords (unencoded in YaBB Gold) made it into phpBBRC & Final, but were lost on the conversion to vBulletin. Users need to use the system's lost password link to get a new one.

2) I am pretty sure that personal emails were lost I will go back and verify.

3) tags were messed up. See my earlier post. The vBulletin convertor has some commented-out attempts at trying to correct this, but it looks like they ran into problems with the regular expressions "[" characters need to be escaped for example.

4) After reordering and correcting the boards in phpBB as suggested, upon import to vBull, everyboard was messed up and had to be renamed. Threads were okay, posts were okay.

5) I never understood what the point of the import into phpFinal was supposed to do. personally I got the same results when I skipped that step.

That's about it.

I have found a way to "include" YaBB attachments that were uploaded. It's a kluge but if anyone needs some pointers on doing that, I have a method available. I was able to bring 1000 attachment images in with my YaBB board so they can be viewed.

Contact me for details.

Regards,

Matt

[beheader]

Originally posted by memobug
I'm up and running 100% now and it's great. I sincerely appreciate your hard work on this Beheader, I would not have attempted it if I didn't know it could be done.

Many thanks. Following your instructions for YaBB SE, I was able to import my YaBB Gold board with the following minor limitations, which I think are minor and much more than I'd hoped for.

1) Passwords (unencoded in YaBB Gold) made it into phpBBRC & Final, but were lost on the conversion to vBulletin. Users need to use the system's lost password link to get a new one.

5) I never understood what the point of the import into phpFinal was supposed to do. personally I got the same results when I skipped that step.

Matt

Ummm.... hope you do not run into problems... skipping the upgrade to phpbb 2.0 final changed the nature of the conversion.

The converter from YaBB to phpbb is openly stated to only work with phpbb RC4 (authors note). The converter from phpbb to vbulletin only works with 2.0 RELEASE or better.

If you had done the upgrade from phpbb RC4 to phpbb 2.0 FINAL I would surmise that your passwords would be in place.

Mine were.... and worked fine.

There were some database changes between RC4 and the final...

Just FYI... good luck...