phpBB2 Importer

Heya everyone. This is a beta release of my importer that converts phpBB2 (RC4 or greater) into vBulletin. It should convert into vBulletin 2.2.0 or greater.

To install the script:[list=1][*]Download bbimport_phpbb2.php from this post (You can only download it if you have entered your username in the vBulletin Members Area, DO NOT PRIVATE MESSAGE ME ASKING ME TO SEND IT TO YOU!!)[*]Open your FTP program of choice, and upload it to the /importers directory in your vBulletin folder (You may need to create this folder if you have never run an importer before)[*]Log into your vBulletin Control Panel[*]On the left navigation pane, find the 'Import & Maintenance' section, and click on 'BB Import Systems'[*]In the page that loads, select 'phpBB2 RC4+', and click 'Begin Import'[*]Follow the instructions from there[/list=1]
Post your results here! Let me know anything that goes wrong, or your success story

Current Version: 0.9.5.2

[Nebula]

Sorry, but I guess I have no choice but to not completely support this anymore, seeing as vBulletin has completely wasted all my time and effort I put into this. :hurt: ARGH!!!! Poop on you vBulletin.

I guess if you're still having problems with this, go try vBulletin's "official" importer.

This would have been done a long time ago, but I got real busy with school, and obviously vBulletin took the chance, and ran with it.

::screams:: :dead:

Oh well, can't win them all. Just so you know vBulletin, I hope you feel good about your importer. :disappointed:

[CodeDawg]

Don't give up the support yet!!!! I have had much more success with your importer than the official one from vB.

I am getting one error, but I think it may be my database or something:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: INSERT INTO pollvote (pollid,userid,votedate) VALUES (1,,985364649)
mysql error:

mysql error number: 0

No clue what is wrong with this particular post, but it is causing the conversion to stop. I know from the ohomyadmin I just ran it doesn't like the datestring.

Any help?????

[Nebula]

well, it's nice to know SOMEONE appreciates what I do.

I will be able to work on it tonight, since I will have plenty of time (my last final was yesterday). No more homework for 3 months!!

CodeDawg: I'll look into this tonight.

[CodeDawg]

Well I kinda got around that issue by setting all the polls to "inactive"

THen it hung up on me last night, then the web server died...so I will give it another go tonight and see what happens...will keep you posted.

Just so you know, the official version doesn't convert nearly as much as your script....but the vB guys did fix an error I found in theirs at 2:30 am.

[CodeDawg]

Nebula:

I got the script to work, didn't convert the polls. Had a bunch of post come through as sticky, but fixed that fairly quickly by doing an update on the threads table and turning off all sticky post....then simply went in and made the 10 or so post that needed to be sticky.

One idea that maybe you and someone over at vBulletin.com might want to look at is merging the two scripts. I tried to use both and found that yours was far more detailed in what it converted, but was missing some key things that the official one had.

I have been up for about 22 hours trying to get things converted and running so I will post some detailed ideas for you once I get some sleep and a clear head.

I do have to say THANKS!!!!! to you for creating this script...even with the glitches I ran into it did a MUCH better job than the official one from vB. :nervous:

[NeRilkA]

hi

i just want to thank Nebula for this wonderful script !! which works great !! and helped me a lot

the official team of vbulletin should replace their script by yours !!!

thanks again !!!

[Nebula]

Hey! Version 0.9.4 is out (finally :P). Sorry it took me so long for an update, I was really swamped with homework at the end of the year.

Anyways, here is a list of updates:

• Script now only works if the vBulletin database and the phpBB database are on the same server (caused too much trouble and bugs)
• Fixed bug with database switching (script would try to read phpBB data from the vBulletin database or vice-versa)
• Fixed poll import bug (Thanks CodeDawg)
• Fixed thread sticky bug
• Improved BBdecode routine
• Many other things I've forgotten about

I also tried the official vBulletin importer, and I must say, I don't like it Mine's a lot more user friendly, and it importes much, much more

Sorry about the sticky bug...I feel really stupid, here's what was wrong (for you PHP Guru's):

PHP Code:

// What it was
if ($threadData[topic_type] == 1) {
  $thread[sticky] = 1;
}

// What it should be (and is now)
if ($threadData[topic_type] == 1) {
  $thread[sticky] = 1;
} else {
  $thread[sticky] = 0;
} 


Basicially, if one thread was sticky, every other thread was made sticky after that until a new page loaded. I think I was asleep when I coded that ^^;;;;

Anyways, enjoy. I ran this a lot this morning, and believe it to be bug free with every DB I've ran it on so far. Hehe. If you have a problem with your DB, send it to me, and I'll fix it up in a jiffy

EDIT #1: I renamed the actual importer filename, so that you could store both the official and unofficial script in the same directory (the vBulletin one is stupid, and doens't like being renamed, yet mine doesn't care if it's renamed. Another reason mine is better ).

EDIT #2: I moved the attachment to the first post. I forgot that's where I put them, lol

[CodeDawg]

Nebula,

Thanks for the updated script. I will download it tonight and give it a try.

[dieKetzer]

I used your importer quite a while ago and had great success with it. I'm sure that there are many others that are happy and thankful to you for releasing this hack. For many, waiting many months for vb to release an 'official' importer was not an option )

[Brad]

Nebula, ran with great results on my local system with a phpbb2 to vB 2.2.6 import.