[Convertor] vBulletin 3.x to phpBB3

[fgforty2]

Can I run this converter multiple times to update the (inactive)phpbb DB with newer posts now on the (active) vB DB? I saw in the SMF converter thread via search it would work fine, but I just wanted to check if there was a limitation to the vb converter regarding that.

Thanks

[r3delmasry]

first thanks for the great topic
second i have some errors in my converting
first one
i got error with my members. 4 of them get the same user name with different user Id ,
i delete all of them
and i restart the converting again and it was cool
but i have error with the language i think that i have to change the encode but for what i don't know
my board language is Arabic ( EGYPT )
next thing
i try to restart the converting process with changing the encoding Step :

OPEN functions_vb30.php

FIND

Code: Select all
$encoding = 'ISO-8859-1';

but i don't know what is my encode
i think its UTF-8
i get that one from Mozilla Fire fox : View > Character Encoding
when i try to restart the converting process it failed
and when i return to the phpBB3 board i found the message :

This board has no forums.

but when i try to open the * View unanswered posts i found my threads over there with this view :

phpmyadmin ÇåãíÊå æßíÃ

the words after phpmyadmin in Arabic language that is the look in the encode : Western ( ISO-8895-1 )
and this look :
phpmyadmin ÇåãíÊå æßíÃ
under the encode : UTF-8
and when i try to open the topic i got that error :

The requested topic does not exist.

so what can i do ??
the last error cause is the converting process fail may be
and enough for now and waiting for help
thanks

[vampiresnake]

hi , great work but i got an error too ;
can u help me ?

Code: Select all

General Error
SQL ERROR [ mysqli ]

Incorrect string value: '\xD9' for column 'forum_name' at row 1 [1366]

SQL

INSERT INTO phpbb_forums (forum_id, forum_name, parent_id, forum_parents, forum_desc, forum_type, forum_status, forum_flags, forum_desc_bitfield, forum_desc_options, forum_desc_uid, forum_link, forum_password, forum_style, forum_image, forum_rules, forum_rules_link, forum_rules_bitfield, forum_rules_options, forum_rules_uid, forum_topics_per_page, forum_posts, forum_topics, forum_topics_real, forum_last_post_id, forum_last_poster_id, forum_last_post_subject, forum_last_post_time, forum_last_poster_name, forum_last_poster_colour, display_on_index, enable_indexing, enable_icons, left_id, right_id) VALUES (188, 'بخش مالتی مدیای تلفن های همراه و اسکرین سیور و والپیپر �', 183, '', '', 1, 0, 34, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, 1, 0, '100', 101)

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: install/convertors/functions_vb30.php
LINE: 417
CALL: dbal_mysqli->sql_query()

FILE: install/install_convert.php(1003) : eval()'d code
LINE: 8
CALL: phpbb_insert_forums()

FILE: install/install_convert.php
LINE: 1003
CALL: eval()

FILE: install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: install/index.php
LINE: 405
CALL: install_convert->main()

FILE: install/index.php
LINE: 282
CALL: module->load()

[fgforty2]

Can I run this converter multiple times to update the (inactive)phpbb DB with newer posts now on the (active) vB DB? I saw in the SMF converter thread via search it would work fine, but I just wanted to check if there was a limitation to the vb converter regarding that.

Thanks

I'm going to answer my own question and say YES you can run the converter multiple times to update your conversion with new posts. If I totally missed the answer before... I apologize, but the search did not give me an answer regarding vb 3X to phpBB 3x converter and multiple conversion passes.

[woodp]

I'm experiencing the same problem as wwalla

Code: Select all

SQL ERROR [ mysql4 ]

Unknown column 'userfield.field3' in 'field list' [1054]

SQL

SELECT user.userid, user.userid AS poster_id, user.usergroupid, user.ipaddress, user.salt, user.joindate, user.username, user.password, user.posts, user.email, user.birthday, user.lastvisit, user.lastactivity, user.timezoneoffset, userfield.field2, userfield.field3, userfield.field4, user.homepage, user.msn, user.yahoo, user.aim, user.icq, user.customtitle, avatar.avatarpath, user.pmunread, user.emailstamp, user.autosubscribe, usertextfield.signature, user.joindate AS post_time FROM ((user LEFT JOIN userfield ON user.userid = userfield.userid) LEFT JOIN usertextfield on user.userid=usertextfield.userid) LEFT JOIN avatar on user.avatarid=avatar.avatarid WHERE (user.userid <> -1) ORDER BY user.userid LIMIT 2000

Looking at the old vB database, I have a userfield.field1, .field2, .field5, .field6 and .field8

What isn't obvious is what I need to do to function_vb30.php to make it run. Any help is appreciated.

[woodp]

Got past the "Unknown column 'userfield.field3' in 'field list' [1054]" hurdle by modifying lines 682-685 of vb30.php as follows:

Code: Select all

array('user_number', 'userfield.field1', array('function1' => 'phpbb_set_encoding')),
array('user_from', 'userfield.field2', array('function1' => 'phpbb_set_encoding')),
array('user_phone', 'userfield.field5', array('function1' => 'phpbb_set_encoding')),
array('user_operate', 'userfield.field6', array('function1' => 'phpbb_set_encoding')),
array('user_own', 'userfield.field8', array('function1' => 'phpbb_set_encoding')),

But when I inspect the new SQL database, the phpbb_users table is only populated with the 101 'bots - None of my users were imported. Worse, where the original author may have been user number X, now phpbb is showing the author to be a 'bot.

The rest of the import seemed to have gone well. What do I need to do to import my users?

[r3delmasry]

hi there
how to convert my members only not all the forum ??
thanks

[bowzer11121]

Alright, I have 3 databases from 3 different forums of mine that I want to consolidate into my new site.

If I run the converter for each db set, will they wipe out the old files, or just add the additional files over top?

Also, is it possible to add just the forum posts and not any of the users. Perhaps have it uploaded by user *archive*.

Thanks.

[r3delmasry]

i have that error :

General Error
SQL ERROR [ mysqli ]

Incorrect string value: '\xCA\xE6\xC8\xEC \xE5...' for column 'forum_name' at row 1 [1366]

SQL

INSERT INTO lastdbforums (forum_id, forum_name, parent_id, forum_parents, forum_desc, forum_type, forum_status, forum_rules, left_id, right_id) VALUES ('1', '���� ���� ������', 0, '', '', 0, 0, '', 1, 2)

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: install/convertors/functions_vb30.php
LINE: 315
CALL: dbal_mysqli->sql_query()

FILE: install/install_convert.php(1003) : eval()'d code
LINE: 15
CALL: phpbb_insert_forums()

FILE: install/install_convert.php
LINE: 1003
CALL: eval()

FILE: install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: install/index.php
LINE: 405
CALL: install_convert->main()

FILE: install/index.php
LINE: 282
CALL: module->load()

and i try that one :

Got past the "Unknown column 'userfield.field3' in 'field list' [1054]" hurdle by modifying lines 682-685 of vb30.php as follows:

Code: Select all

array('user_number', 'userfield.field1', array('function1' => 'phpbb_set_encoding')),
array('user_from', 'userfield.field2', array('function1' => 'phpbb_set_encoding')),
array('user_phone', 'userfield.field5', array('function1' => 'phpbb_set_encoding')),
array('user_operate', 'userfield.field6', array('function1' => 'phpbb_set_encoding')),
array('user_own', 'userfield.field8', array('function1' => 'phpbb_set_encoding')),

But when I inspect the new SQL database, the phpbb_users table is only populated with the 101 'bots - None of my users were imported. Worse, where the original author may have been user number X, now phpbb is showing the author to be a 'bot.

The rest of the import seemed to have gone well. What do I need to do to import my users?

and i start over againg and the same error
any help

[r3delmasry]

yahooooooooooooooooooooooooooooooooooooooo
worked cooooooooooooooool
but the sub forum look Weird
what can i do ?

[Hrxsz]

Is this convertor work well with vBulletin 3.8.2?

[woodp]

Is this convertor work well with vBulletin 3.8.2?

Absolutely. The vB database format is pretty much unchanged since 3.5 or 3.6 ...

The problem that most of us strugglers are facing is that we defined custom fields, and the converter doesn't know what to do with them without manual intervention.

If you have a garden variety board, you're in great shape!

[r3delmasry]

hi there
can u help me in my forum encoding ??
please how to convert my forum encoding
my forum url : http://www.2bh.info/phpBB3
any help gays

[mx1001]

A great THANKS to whom made this convertor .

I succsesfully converted a really old Vbulletin 3.07 forum with attachments within the sql .

With the help of 1-2 minor modifications not listed here (mostly concerning collation issues),
Everything gone fine.

T H A N K S !.

[mmyo]

when i kick off the convert script, the page just hangs. i've had my host up the resources allocated to me, so it doesn't timeout. however, i had it run for nearly eight hours with no results (phpbb DB was still empty).

any thoughts on how to troubleshoot? is there a log i can access to see what went wrong?

my vbulletin DB is about 300MB (Threads: 12,174, Posts: 289,791, Members: 761)