Import vBulletin into phpBB

[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

[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]

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]

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]

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