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]

...

All I can think of is that you entered your phpBB details inside the vBulletin database. That's the ONLY way you could be getting errors about a phpBB database through the vBulletin wrapper.

If you want to give me FTP access, I can check it out. Email me the details if you want, don't post them here, for obvious reasons.

[Timmmmmy]

you can have all the access you want lol i can change the pwd when your done do you have icq?

[Timmmmmy]

i added you to my icq or at least requested that you let me lol..i also sent you an email with the info you requested......just let me know what else you need...if you need access to the board i can do that too...whatever you need let me know thanks again

[James5mith]

I'm trying to convert my phpBB2 forums over to vB.

I don't care about styles.
I don't care about smileys.

All I want is my user information and threads transferred over.

I cannot get that far though, because the converter keeps erroring out on trying to transfer over the styles, and then the smileys.

I have set the converter script to:

Do Not import subsilver
Do Not import smileys
# of styles to Import: 0

It's still giving me errors.

Any suggestions?

*Edit:

I'm at step 3.

Options:
Should I skip users who's username is already in the database? (Not Complete)
Yes

Would you like me to import avatars?
No

What style should the users have by defualt?
(There is no option to chose at this point, is this the problem?)

Then I get two error windows below, and cannot proceed:

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: SELECT title,styleid FROM style ORDER BY title
mysql error: Table 'sbf.style' doesn't exist

mysql error number: 1146

Date: Tuesday 16th of April 2002 03:04:55 PM
Script: http://www.spaghettibasgetti.net/vb2...f&iprefix=sbf_
Referer:

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: UPDATE session SET lastactivity=1018991095,location='' WHERE sessionhash='f84f112c57569ed34494c5bff4bd8d1e'
mysql error: Table 'sbf.session' doesn't exist

mysql error number: 1146

Date: Tuesday 16th of April 2002 03:04:55 PM
Script: http://www.spaghettibasgetti.net/vb2...f&iprefix=sbf_
Referer:

[Timmmmmy]

Well im not an expert, nor do i have your answer but those that can help, would probably like to know what errors your getting. Its like going to get your car fixed and saying its broken lol....sorry...kinda frustrated myself...im probably getting the same errors as you lol...i try no to everything, i just want my forums as far as the layout with categories and forums...the posts and the users not to much to ask lol i did talk to Nebula i gave him some info so hopefully he can fix it

[James5mith]

^^

After going through it about 5 more times, that same error keeps appearing. At every step.

Even though the import script will continue past the first two steps, at the bottom of each page is a window with pretty much that exact error.

[DemiNeo0101]

time to give this script the stress test. I got a phpbb with a 150 meg DB that need to merge with me vbb. I'll tell you all how it comes out.

Http://forums.cheatlist.com

[Nebula]

ugh, sorry for not replying for a while.

Due to current complications in my already busy live with my brain running at 1000% normal capacity, I don't think I'm going to have time for this for a little bit. I'm going to work on it this weekend, someone email me so I don't forget, LOL

James5Smith: I don't know what's wrong, I'll look into it this weekend.

Timmmmmy: My brain's running fast enough already, I'm planning on working on your DB this weekend.

[Timmmmmy]

Hey dont worry about it man, i went on without it.....i manually registered people LOL I only have arround 30 members, i just did a copy and paste job, and told them if there are any posts they want saved to copy them over....thanks though

[Nebula]

Version 0.9.1 is out!! Here's a changelog:

• BUG FIX: Options would not take effect until you entered the config page in the vB Control Panel, and saved configuration.
• Added option to skip importing a user if their username is already in the database
• Removed duplicate moderator detector, because vBulletin's import routine has it built in (doh )
• Special Forums now import
• BUG FIX: Script would not pause while smilies were imported
• Added links during pause so that you could modify individual items (links only appear if you elect to pause)
• BUG FIX: Would import thread subscriptions even if asked not to

Go download it. The script looks pretty much complete. I want to rewrite some of the parts the user sees, but I think all the bugs are gone. Please help test this almost complete version!!