[Convertor] vBulletin 3.x to phpBB3

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Anti-Spam Guide
htmlc
Registered User
Posts: 2
Joined: Wed May 23, 2012 12:41 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by htmlc »

Ok I decided to go ahead with the conversion. I got everything installed for phpBB3 and the converter as well. But the converter wants "This is the relative path on disk to your former board from the root of this phpBB3 installation."

Problem is - I removed all of the files from vb because i want the phpbb3 in the same root dir.

Any ideas how to get around this?

Thanks!
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: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

htmlc wrote:Ok I decided to go ahead with the conversion. I got everything installed for phpBB3 and the converter as well. But the converter wants "This is the relative path on disk to your former board from the root of this phpBB3 installation."

Problem is - I removed all of the files from vb because i want the phpbb3 in the same root dir.
I hope you know that by deleting the vB files attachments, avatars and smilies won't get converted if you have them saved on the filesystem.
htmlc wrote:Any ideas how to get around this?

Thanks!
Create a file and name it showthread.php. The content doesn't matter. Save the file somewhere on your server. When you run the convertor, enter the relative path to this file.
htmlc wrote:how does this converter deal with vbseo urls? I want to make sure the urls are converted over.
The convertor does not touch url's. They get transferred over as is.
Have you hugged someone today?
helmar99
Registered User
Posts: 7
Joined: Thu Jun 28, 2012 8:49 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by helmar99 »

Hello,

I have a vBulletin 3.8.6 that i'm itching to get moved over to phpBB3 but i've run into some issues that I cannot solve despite 2 days of trying and searching :)

Threads: 26,500
Posts: 270,000
Members: 4,500

All seems to go well with initial conversion until the script starts to process the posts table, at which point I will get various errors that state:

Post ID: Message parser error:
Your message contains too few characters.

But the script seems to move on from these errors but it gets to a stage around about row 100000 of the posts table and the script just stops, no error (just the standard IE9 can't find page error). It never gets past Step 7 of 17.

I am doing this offline and i've tried it under various versions of xammp, easyphp, wampserver etc and I get the same result each time.

Can anyone offer any advice?

Thanks!
helmar99
Registered User
Posts: 7
Joined: Thu Jun 28, 2012 8:49 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by helmar99 »

Well, i'm still failing big time to get this import to work. I've looked at the posts in question where the import stops and there seems to be nothing wrong with them.

If the import is failing due to something about these posts, is there a way to get the script to ignore them and carry on without failing?
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: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

@jwaiv,

The posts most likely have a long unbroken string of characters. The following procedure may help.

1) Run the convertor until it stops
2) Open install/install_convert.php
3) Change the batch_size to 1000
4) Run the convertor again until it stops
5) Change the batch_size in install_convert.php to 500
6) Run the convertor again until it stops
7) Change the batch_size in install_convert.php to 100
8) Run the convertor again until it stops
9) Change the batch_size in install_convert.php to 10
10) Change num_wait_row to 1
11) Run the convertor again until it stops
12) Change the batch_size in install_convert.php to 1
13) Run the convertor again until it stops
14) Look in the phpBB3 phpbb_posts table and make a note of the last post entered.
15) Look in the vBulletin post table and find the post that was last entered into phpBB.
16) Look at the next 1 or 2 posts (you may want to sort the messages table by post_id) and see if there is a post with a long unbroken string of characters.
17) If there is a post with a long unbroken string of characters, edit the post to remove the long string.
18) Change the batch_size back to 2000.
19) Change the num_wait_rows back to 20
20) Continue with the conversion by refreshing the page or going to install/index.php?mode=convert and choosing "Continue with previously started conversion".
Have you hugged someone today?
helmar99
Registered User
Posts: 7
Joined: Thu Jun 28, 2012 8:49 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by helmar99 »

Thanks for that, i'm giving it a try now. It still stops on a normal post (no long strings).

I'm manually moving up skip_rows= in the url and refreshing, sometimes i have to move the number up by 1-3 rows but it then starts to run again. I suspect this will result in a couple of lost posts will be a small price to pay to get me off vb.

Could you define how long an unbroken string would have to be in order to break the script?

Wish me luck :)
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: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

jwaiv wrote:Could you define how long an unbroken string would have to be in order to break the script?
I don't know. So far, I have not been able to determine the exact number, but I estimate at least 100 characters, probably more.
Have you hugged someone today?
helmar99
Registered User
Posts: 7
Joined: Thu Jun 28, 2012 8:49 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by helmar99 »

Hmm, theres nothing close to being that long in the posts :(

Will keep trying.
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: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

jwaiv wrote:Hmm, theres nothing close to being that long in the posts :(

Will keep trying.
Have a look at http://www.phpbb.com/community/viewtopi ... #p12996138
Have you hugged someone today?
helmar99
Registered User
Posts: 7
Joined: Thu Jun 28, 2012 8:49 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by helmar99 »

Thanks, will give it a shot.
helmar99
Registered User
Posts: 7
Joined: Thu Jun 28, 2012 8:49 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by helmar99 »

D¡cky wrote:
jwaiv wrote:Hmm, theres nothing close to being that long in the posts :(

Will keep trying.
Have a look at http://www.phpbb.com/community/viewtopi ... #p12996138
Really useful script!

It was long words (in this case some long ass gamespy url's), the magic number for me was unbroken strings of 255 characters or above. After the posts got done there were poll issues but there was a fix for that in this thread already.

Thanks again D¡cky, all looks good now!
Persia1
Registered User
Posts: 3
Joined: Sun Jan 01, 2012 10:13 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Persia1 »

Hello

i've problem in converting my vb to phpbb3

in step 3 ,i got this error

-------------------------------
General Error

SQL ERROR [ mysqli ]

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 'where config_name="board_startdate"' at line 1 [1064]

SQL

update phpbb_config set config_value= where config_name="board_startdate"

BACKTRACE

FILE: [ROOT]/includes/db/mysqli.php
LINE: 182
CALL: dbal->sql_error()

FILE: [ROOT]/install/convertors/functions_vb30.php
LINE: 66
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/install/install_convert.php(1654) : eval()'d code
LINE: 2
CALL: vb_import_polloption()

FILE: [ROOT]/install/install_convert.php
LINE: 1654
CALL: eval()

FILE: [ROOT]/install/install_convert.php
LINE: 799
CALL: install_convert->jump()

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

FILE: [ROOT]/install/index.php
LINE: 326
CALL: install_convert->main()

FILE: [ROOT]/install/index.php
LINE: 203
CALL: module->load()

---------------------------------------

please help me to solve this

thanks alot
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: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

Persia1 wrote:Hello

i've problem in converting my vb to phpbb3

in step 3 ,i got this error
You either don't have any posts in the phpbb_posts table or there is a post that does not have a post time.
Have you hugged someone today?
Alagos
Registered User
Posts: 2
Joined: Sat Jul 07, 2012 3:32 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Alagos »

When I try to run try to run the converter I get this on step 2:

Code: Select all

[phpBB Debug] PHP Warning: in file [ROOT]/install/convertors/functions_vb30.php on line 86: copy(./../../kuhba/./uploads/8/8/0/5687.thumb) [function.copy]: failed to open stream: No such file or directory
[phpBB Debug] PHP Warning: in file [ROOT]/install/convertors/functions_vb30.php on line 80: copy(./../../kuhba/./uploads/8/8/0/5688.attach) [function.copy]: failed to open stream: No such file or directory
[phpBB Debug] PHP Warning: in file [ROOT]/install/convertors/functions_vb30.php on line 86: copy(./../../kuhba/./uploads/8/8/0/5688.thumb) [function.copy]: failed to open stream: No such file or directory
[phpBB Debug] PHP Warning: in file [ROOT]/install/convertors/functions_vb30.php on line 80: copy(./../../kuhba/./uploads/1/3/4/5689.attach) [function.copy]: failed to open stream: No such file or directory
[phpBB Debug] PHP Warning: in file [ROOT]/install/convertors/functions_vb30.php on line 86: copy(./../../kuhba/./uploads/1/3/4/5689.thumb) [function.copy]: failed to open stream: No such file or directory
[phpBB Debug] PHP Warning: in file [ROOT]/install/index.php on line 361: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3815)
[phpBB Debug] PHP Warning: in file [ROOT]/install/index.php on line 362: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3815)
Do you have any idea what might be wrong there?
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: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

Alagos wrote:Do you have any idea what might be wrong there?
It looks like the vBulletin forum path is missing. Where are your vBulletin attachments stored?
Look in the vBulletin database at the settings table. What is the value for varname['attachpath']?
Have you hugged someone today?

Return to “[3.0.x] Convertors”