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]

hehe, lemme know how it works out

[plauderer]

I use phpBB2.0 Gold and I have this error:

Script That Crashed: phpBB2 Importer
Script Returned: Bad SQL Syntax: SELECT * FROM themes ORDER BY themes_id ASC LIMIT 0,10
mySQL Said: Table 'db34382616 .themes' doesn't exist (Error Number 1146)
Date of Error: April 10th, 2002 at 9:47 PM
URL of Script: /importers/bbimport_phpbb2.php
Referring Page:

Table Prefix are _phpBB and I type this in the importer script! Now I see db34382616... it´s the name of the database ???

???

Plauderer

[Nebula]

Hmm, lemme get this straight:

Your table prefix is: '_phpBB'

okie, I understand that much. It looks like there's a trailing space at the end of the database name, you may want to check that. Or, it could be how vBulletin saved the data

::skimms through code::

ah, found the problem. Expect a new version in a few minutes...sorry about this...

[Nebula]

Here's Version 0.6.3. What's changed:

• Table Prefixing should now work
• Added version indicator at top of every page
• Fixed Minor HTML Bugs
• Optimizations here and there

Lemme know if this version works

BTW...FireFly, there's a bug in the re-uploading thing. You try to select data from the 'attachmentid' table. I think you went to fast while coding that :-P

[rochen]

I just tried this and when it comes to the styles import section I get this error

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: INSERT INTO style (styleid,replacementsetid,templatesetid,title,user select,importstyleid) VALUES (null,19,1,'phpBB2 - subSilver
mysql error:

mysql error number: 0

This is on version 2.2.5.

Even if I opt to not import the styles it still gives me this error. Any ideas?

[Nebula]

Ugh, put a comma instead of a period when executing the query

Expect a new version soon (one that imports polls and (hopefully) announcements, whee! ).

[Nebula]

Version 0.7.1 is released! Here's a more-or-less complete changelog (forgot to keep track):

• Topic Polls now import
• Forum Announcements now import
• Started work on not importing users if their username is already in the database
• BUG FIX: Bad Style Import query
• BUG FIX: Would not skip subSilver even if requested

That's it. Download it

[Timmmmmy]

I tried to use this import script but i get this error

Database error in vBulletin Control Panel 2.2.5:

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

mysql error number: 1146

Date: Tuesday 16th of April 2002 03:03:38 PM
Script: http://www.allmadden.hwgn.net/forums...iprefix=phpbb_
Referer: http://www.allmadden.hwgn.net/forums/admin/?

It gets to step step three then right below it says the error above....i can take a screen shot if need be

Im using phpbb2 gold (final release)

Ive also tried it with RC4

the phpbb forums are located at:
phpBB2

VBB 2.2.5
VBB 2.2.5

[Nebula]

I think you messed something up. (Or, I'm not feeling well, read note#1)

In vBulletin's config file, it should point to your vBulletin database. From what it looks like, the vBulletin DBwrapper is giving you an error, and you're trying to access a database labeled 'ama_phpbb2'. That's the only thing I can think of. Make sure in your vBulletin config file, that you enter the correct settings for your vBulletin database, not your phpBB database.

You enter your phpBB details when you run the importer.

NOTE: I'm not feeling well (I have some form of heat stroke), it's really hot here in Michigan!

NOTE #2: A new version is on the way. Everything is perfect, and ready to be released, except the BBcode routines. I'm having lots of fun with converting size tags. phpBB measures font size in pixels, and vBulletin measures in points, or something other then pixles. Maybe a new version will be out tonight or tomorrow.

[Timmmmmy]

I can assure you the problem isnt with me, ive dont this about 15 times or so. The MySQL error im getting is whats throwing me off. Its looking for

mysql error: Table 'ama_phpbb2.style' doesn't exist

now im not sure, if thats in the vb db or the phpbb db? does that makes sense?

I think ill try to create a ama_phpbb.style in the vb forums, otherwise ill just wait until your final release....anyways hope you feel better, and thanks for the quick reply!

I used to have access to my db, thru phpmyadmin, but i lost the URL my host gave me. Im waiting on a email back from them.

I created the style ama_phpbb2 and it didnt work

I know it was a crazy idea lol

I then selected to quit at the top right hand corner and i get these errors...

Warning: Supplied argument is not a valid MySQL result resource in /home/sites/site50/web/forums/admin/db_mysql.php on line 195

Warning: Supplied argument is not a valid MySQL result resource in /home/sites/site50/web/forums/admin/db_mysql.php on line 154

Warning: Cannot add header information - headers already sent by (output started at /home/sites/site50/web/forums/admin/db_mysql.php:195) in /home/sites/site50/web/forums/importers/bbimport_phpbb2.php on line 167

Since my host is getting ready to move servers its all just playing ground for me right now anway...so any help today would be cool if not ill just wait

PS
Database info is

usr: allmadden
pwd:*******
db name: ama_phpbb2
prefixhpbb_

I have to change them to lower case for both the db and bb from what the control panel gives me, because its not right. if that makes sense