Import vBulletin into phpBB

Temporary forum to obtain support while phpBB.com is offline.
Please use the support forum on phpBB.com
Forum rules
Temporary forum to obtain support while phpBB.com is offline.
Please use the support forum on phpBB.com
Locked
GreaterGood
Registered User
Posts: 1
Joined: Thu Feb 05, 2009 6:39 pm

Import vBulletin into phpBB

Post by GreaterGood »

Ok here goes.
I have a vBulletin website and the license is about to expire, On the 7th to be exact, We tried to raise the money but no luck, So i would like to import my 700+ members and all my posts and threads to an installation of phpBB so people can continue to enjoy the forums on my site. ANY help would be greatly appreciated, Im still trying to get used to the finding things for phpBB as it is harder than on vb.

Regards,
GreaterGood
User avatar
Lumpy Burgertushie
Registered User
Posts: 1006
Joined: Tue Feb 28, 2006 5:26 pm

Re: Import vBulletin into phpBB

Post by Lumpy Burgertushie »

when the main site comes back up, you will find a converters forum there with all the info you need to do this.


robert
Dicky
Registered User
Posts: 125
Joined: Tue Feb 08, 2005 4:15 am

Re: Import vBulletin into phpBB

Post by Dicky »

You can grab the vBulletin convertor at http://dicky.askmaggymae.com/files/vb30x_phpbb3(2).zip

The phpBB3 files & vBulletin files and vBulletin database and phpBB3 database need to be on the same server.
phpBB3 needs to be installed before doing the conversion.
vBulletin avatars and attachments need to be saved on the filesystem, not in the database.

Unzip vb30x_phpbb3(2).zip
Upload the files to your server.
auth_vb3.php needs to go in the phpBB3 includes/auth folder
convert_vb30.php and functions_vb30.php need to go in the install/convertors folder

Browse to {phpbb3_root}/install/index.php
Click the Convert tab
Select the vBulletin convertor
When asked for database information, enter the database information to connect to the vBulletin database.
meyrick
Registered User
Posts: 1
Joined: Tue Nov 15, 2005 12:07 am

Re: Import vBulletin into phpBB

Post by meyrick »

Hi Dicky,

Have just ran the convertor and got:

Code: Select all

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',"20 inch or above",1)' at line 1 [1064]

SQL

insert into phpbb_poll_options (poll_option_id,topic_id,poll_option_text,poll_option_total) values(,,"20 inch or above",1)
Any ideas how i can over come this?

I am running phpBB 3.0.4 and vBulletin 3.6.4
Dicky
Registered User
Posts: 125
Joined: Tue Feb 08, 2005 4:15 am

Re: Import vBulletin into phpBB

Post by Dicky »

meyrick wrote:Hi Dicky,

Have just ran the convertor and got:

Code: Select all

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',"20 inch or above",1)' at line 1 [1064]

SQL

insert into phpbb_poll_options (poll_option_id,topic_id,poll_option_text,poll_option_total) values(,,"20 inch or above",1)
Any ideas how i can over come this?

I am running phpBB 3.0.4 and vBulletin 3.6.4
This is from my memory. I do have a fix posted at phpbb.com but I can't get to it right now.

OPEN functions/vb30.php
FIND

Code: Select all

$sql='select p.*, t.threadid from '. $convert->src_table_prefix . 'poll p left join '. $convert->src_table_prefix .'thread t ON p.pollid=t.pollid';
REPLACE WITH

Code: Select all

$sql='select p.*, t.threadid FROM '. $convert->src_table_prefix . 'poll p, '. $convert->src_table_prefix .'thread t WHERE p.pollid=t.pollid';
FIND

Code: Select all

$sql='insert into '.POLL_OPTIONS_TABLE.' (poll_option_id,topic_id,poll_option_text,poll_option_total) values('.$row['pollid'].','.$topicid.','.addslashes($option[$i-1]).','.$vote[$i-1].')';
REPLACE WITH

Code: Select all

$sql='insert into '.POLL_OPTIONS_TABLE.' (poll_option_id,topic_id,poll_option_text,poll_option_total) values('.$poll_id.','.$topicid.',\''.addslashes($option[$i-1]).'\','.$vote[$i-1].')';
SAVE/CLOSE
Locked