vB 3.x convertor

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Suggested Hosts
User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34459
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run

Re: vB 3.0.x convertor for phpbb3 rc1

Post by A_Jelly_Doughnut »

thejdm wrote:guessing this will work for vb3.6.4 converting to phpbb3 gold?

i converted from phpbb to vB awhile back but i had a friend do it. is it that hard to do?
No. You just need to enter some details about the location of your vB board, then just wait for it to complete.
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish
xnitelifex
Registered User
Posts: 126
Joined: Wed Jun 27, 2007 6:35 pm

Re: vB 3.0.x convertor for phpbb3 rc1

Post by xnitelifex »

Now that phpbb3 is final, I would like to give this a try, but before I do so, can someone let me know what will not migrate over? attachments? polls? avatars?
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: vB 3.0.x convertor for phpbb3 rc1

Post by D¡cky »

xnitelifex wrote:Now that phpbb3 is final, I would like to give this a try, but before I do so, can someone let me know what will not migrate over? attachments? polls? avatars?
I believe that everything will convert over. The way to know for sure is to try it and see.

Use the files in this post, http://www.phpbb.com/community/viewtopi ... 4#p3362284
Have you hugged someone today?
dream7070
Registered User
Posts: 1
Joined: Wed Dec 19, 2007 1:03 pm

Re: vB 3.0.x convertor for phpbb3 rc1

Post by dream7070 »

helloo, :cry: I've been trying the converter and have hit almost every error that Nando was getting (and the fixes have worked for me so far) :cry: but I've hit a new error not listed here:

SQL ERROR [ mysqli ]

Incorrect string value: '\xAB°...' 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_rules, left_id, right_id) VALUES ('1', '�۩۞۩ ��������� ��������� ۩۞۩�', 0, '', '', 0, 0, '', 1, 2)

BACKTRACE


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

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

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

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

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

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

FILE: install/index.php
LINE: 274
CALL: module->load()
xnitelifex
Registered User
Posts: 126
Joined: Wed Jun 27, 2007 6:35 pm

Re: vB 3.0.x convertor for phpbb3 rc1

Post by xnitelifex »

D¡cky wrote:
xnitelifex wrote:Now that phpbb3 is final, I would like to give this a try, but before I do so, can someone let me know what will not migrate over? attachments? polls? avatars?
I believe that everything will convert over. The way to know for sure is to try it and see.

Use the files in this post, http://www.phpbb.com/community/viewtopi ... 4#p3362284
I will certainly give that a try. That's for pointing me to that attachment.
xnitelifex
Registered User
Posts: 126
Joined: Wed Jun 27, 2007 6:35 pm

Re: vB 3.0.x convertor for phpbb3 rc1

Post by xnitelifex »

Another question before migrating over ...

vbulletin url: http://localhost/forum/forumdisplay.php?f=xx
phpbb3 url: http://localhost/phpbb3/viewforum.php?f=xx

vbulletin url: http://localhost/forum/showthread.php?t=xx
phpbb3 url: http://localhost/phpbb3/viewtopic.php?f=xx

Since search engines already have it indexed, is there a way to avoid dead links?

TIA
Last edited by xnitelifex on Thu Dec 20, 2007 5:49 am, edited 1 time in total.
User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34459
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run

Re: vB 3.0.x convertor for phpbb3 rc1

Post by A_Jelly_Doughnut »

xnitelifex: the best way to handle that would be with Apache's mod_rewrite. Just search Google for RewriteRule, or ask your web host :)
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish
xnitelifex
Registered User
Posts: 126
Joined: Wed Jun 27, 2007 6:35 pm

Re: vB 3.0.x convertor for phpbb3 rc1

Post by xnitelifex »

These are the errors I'm seeing in between conversion:

[phpBB Debug] PHP Notice: in file /install/convertors/functions_vb30.php on line 73: copy
(./../../forum/../attach/7/3/3/1.attach) [function.copy]: failed to open stream: No such file or directory

[phpBB Debug] PHP Notice: in file /install/index.php on line 440: Cannot modify header information - headers already sent by (output started at /includes/functions.php:2922)

[phpBB Debug] PHP Notice: in file /install/convertors/functions_vb30.php on line 108: rename
(./..//images/avatars/gallery/avatar2_0.gif,./..//images/avatars/upload/38d3885135ef863fd38671645645213f_2.gif) [function.rename]: No such file or directory
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: vB 3.0.x convertor for phpbb3 rc1

Post by D¡cky »

xnitelifex,
Are your attachments stored in the database or as files on the server?

You need to have your attachments and avatars in the images/attach and images/avatars directories respectively.
Have you hugged someone today?
xnitelifex
Registered User
Posts: 126
Joined: Wed Jun 27, 2007 6:35 pm

Re: vB 3.0.x convertor for phpbb3 rc1

Post by xnitelifex »

D¡cky wrote:xnitelifex,
Are your attachments stored in the database or as files on the server?

You need to have your attachments and avatars in the images/attach and images/avatars directories respectively.
Thanks for your quick reply. Once I make the correction, do I need to reinstall phpbb3 and start the entire process over or can I simply return to the index page? Just want to make sure I re-setup correctly.
xnitelifex
Registered User
Posts: 126
Joined: Wed Jun 27, 2007 6:35 pm

Re: vB 3.0.x convertor for phpbb3 rc1

Post by xnitelifex »

Attachments are currently being stored in the filesystem at ../forum/images/attach

Then I went to http://localhost/phpbb3/install/index.p ... anguage=en and clicked on New Conversion.

Same error message as before:
[phpBB Debug] PHP Notice: in file /install/convertors/functions_vb30.php on line 73: copy (./../../forum/../attach/7/3/3/1.attach) [function.copy]: failed to open stream: No such file or directory

[phpBB Debug] PHP Notice: in file /install/index.php on line 440: Cannot modify header information - headers already sent by (output started at /includes/functions.php:2922)

[phpBB Debug] PHP Notice: in file /install/convertors/functions_vb30.php on line 108: rename (./..//images/avatars/gallery/avatar2_0.gif,./..//images/avatars/upload/38d3885135ef863fd38671645645213f_2.gif) [function.rename]: No such file or directory

Note: on line 72, I uncomment //print $file.'<br>';
during the conversion it outputs: ./../../forum/../attach/7/3/3/1.attach
xnitelifex
Registered User
Posts: 126
Joined: Wed Jun 27, 2007 6:35 pm

Re: vB 3.x convertor

Post by xnitelifex »

Also getting this error:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Out of range value adjusted for column 'forum_id' at row 1 [1264]

SQL

INSERT INTO phpbb_acl_users (user_id, forum_id, auth_role_id) VALUES (1308, -1, 11)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/functions_convert.php
LINE: 1512
CALL: dbal_mysql->sql_query()

FILE: install/convertors/functions_vb30.php
LINE: 702
CALL: mass_auth()

FILE: install/install_convert.php(1653) : eval()'d code
LINE: 2
CALL: phpbb_convert_authentication()

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

FILE: install/install_convert.php
LINE: 800
CALL: install_convert->jump()

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

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

FILE: install/index.php
LINE: 274
CALL: module->load()
Last edited by xnitelifex on Fri Dec 21, 2007 6:35 pm, edited 1 time in total.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: vB 3.x convertor

Post by D¡cky »

xnitelifex wrote:Also getting this error:

General Error
SQL ERROR [ mysql4 ]

Out of range value adjusted for column 'forum_id' at row 1 [1264]

SQL

INSERT INTO phpbb_acl_users (user_id, forum_id, auth_role_id) VALUES (1308, -1, 11)
Please read through the previous posts. Another user had the same problem and it was explained how to fix it; change the forum_id to a positive value.
Have you hugged someone today?
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: vB 3.0.x convertor for phpbb3 rc1

Post by D¡cky »

[quote="iamcommie"]Thanks for the help. I got the same error:

Code: Select all

SQL ERROR [ mysqli ]

Out of range value adjusted for column 'poll_option_id' at row 1 [1264]

SQL

insert into phpbb_poll_options (poll_option_id,topic_id,poll_option_text,poll_option_total) values(425,10392,"HOMEMADE",33)[/quote]
According to the error, you have 425 options for that poll. That is way too many.
Run this query in phpMyAdmin[code]SELECT options, votes, pollid p, question, numberoptions, voters, threadid  FROM `vb3_poll` p LEFT JOIN vb3_thread t ON p.pollid = t.pollid WHERE t.threadid='199';
If your vBulletin table prefix is not vb3_, change it in the code in two places, vb3_thread and vb3_poll.
Post a screenshot of the results.
Have you hugged someone today?
sixtyseven
Registered User
Posts: 1
Joined: Tue Nov 27, 2007 1:21 pm

Re: vB 3.x convertor

Post by sixtyseven »

Hi,
i get also this error:
SQL ERROR [ mysqli ]

Data too long for column 'config_value' at row 1 [1406]

SQL

UPDATE phpbb3_config SET config_value = 'xxxxxxx' WHERE config_name = 'sitename'

BACKTRACE

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

FILE: includes/functions.php
LINE: 148
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_convert.php
LINE: 1288
CALL: set_config()

FILE: install/install_convert.php
LINE: 987
CALL: restore_config()

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

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

FILE: install/index.php
LINE: 274
CALL: module->load()
Please help :?:

Return to “[3.0.x] Convertors”