SMF 2.0.1 - phpbb 3.0.9

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Scam Warning
GTunney
Registered User
Posts: 125
Joined: Thu May 17, 2007 4:53 pm

SMF 2.0.1 - phpbb 3.0.9

Post by GTunney »

Hi Everyone,

I'm trying to convert my SMF 2.0.1 board to phpbb 3.0.9 using the 2.0 converter.

Everything seems great at first and the conversion starts and transfers my forum sections and sub sections. but after about 5 minutes the phpbb conversion page doesn't look as though it's doing anything and just goes white.

Both forums are on the same server under different directories.

Any suggestions?
Regards,
Greg
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: SMF 2.0.1 - phpbb 3.0.9

Post by D¡cky »

It could be a couple of things. It could be that the server becomes overloaded and times out. If it is stopping while converting the posts, it could be that you have some very large posts or a post with a long unbroken string of characters.

Try this first:
Open phpbb3/install/install_convert.php

Find:

Code: Select all

<?php
/**
*
* @package install
* @version $Id$
* @copyright (c) 2006 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
*/
After add:

Code: Select all

@set_time_limit(0);
@ini_set('memory_limit', '256M');
@ini_set('upload_max_filesize', '128M');
@ini_set('post_max_size', '256M');
@ini_set('max_input_time', '-1');
@ini_set('max_execution_time', '-1');
@ini_set('expect.timeout', '-1');
@ini_set('default_socket_timeout', '-1');
If the convertor stops while doing the posts and seems to stop at the same place every time, then you probably have a post with a long unbroken string of characters. To find the post that may be causing the problem:

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 phpbb_posts table and make a note of the last post entered.
15) Look in the SMF mesages 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 SMF_messages table by id_msg) 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.
Have you hugged someone today?
GTunney
Registered User
Posts: 125
Joined: Thu May 17, 2007 4:53 pm

Re: SMF 2.0.1 - phpbb 3.0.9

Post by GTunney »

Ok so just to double check.

When you say continue with conversion do you mean continue with previous conversion or start a new converstion?
GTunney
Registered User
Posts: 125
Joined: Thu May 17, 2007 4:53 pm

Re: SMF 2.0.1 - phpbb 3.0.9

Post by GTunney »

Ok managed to get to step 11 of 15 in the conversion and now get this.

Code: Select all

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. 
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: SMF 2.0.1 - phpbb 3.0.9

Post by D¡cky »

GTunney wrote:Ok so just to double check.

When you say continue with conversion do you mean continue with previous conversion or start a new converstion?
You can either start over and choose "continue with previous conversion" or simply refresh the page you are on.
GTunney wrote:Internal Server Error
I am not sure what could be causing that. Did you check the Server Error Log? It may be the same problem that caused the whitepage.
Is this happening while converting the posts table? If it is, were you able to find the offending post?
Have you hugged someone today?
GTunney
Registered User
Posts: 125
Joined: Thu May 17, 2007 4:53 pm

Re: SMF 2.0.1 - phpbb 3.0.9

Post by GTunney »

Any idea roughly where the server error log would be kept?

Also i didn't manage to catch which stage it was on. I just know it was step 11 of 18.
GTunney
Registered User
Posts: 125
Joined: Thu May 17, 2007 4:53 pm

Re: SMF 2.0.1 - phpbb 3.0.9

Post by GTunney »

This is on the end of the url

sub=in_progress&tag=smf20RC2&current_table=10&skip_rows=3801&language=en

So i would presume its the current_table operation.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: SMF 2.0.1 - phpbb 3.0.9

Post by D¡cky »

GTunney wrote:Any idea roughly where the server error log would be kept?
It should be found in your server control panel; cPanel, DirectAdmin or whatever your host uses.
GTunney wrote:This is on the end of the url

sub=in_progress&tag=smf20RC2&current_table=10&skip_rows=3801&language=en

So i would presume its the current_table operation.
It does appear that it is converting the posts table when the convertor gets stuck. You can look at the phpbb_posts table to see if some rows have been converted.
If you do the procedure I posted earlier, you should be able to find the post that is causing the problem.
Have you hugged someone today?
GTunney
Registered User
Posts: 125
Joined: Thu May 17, 2007 4:53 pm

Re: SMF 2.0.1 - phpbb 3.0.9

Post by GTunney »

You sir are a legend.

Thanks for you help they were 4 or 5 posts down.

There is one more problem after the conversion the posts are not showing images correctly.

e.g. [img width=600 height=450]http://i449.photobucket.com/albums/qq22 ... 44/pug.jpg[/img]

Is how it appears, i know this is something to do with the way phpbb handles the size. Is there anyway to quickly solve this for all pics?
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: SMF 2.0.1 - phpbb 3.0.9

Post by D¡cky »

I have attached a modified version of the Support Toolkit which will correct the [img] tags that have the width and height. The tool adds a new bbcode, imgwh, and converts the [img] tag with width and height to the new imgwh tag.

Download the zip file to your computer and decompress
Upload the stk folder to your phpBB root directory.
Run the tool by going to {phpbb_root_directory}/stk/index.php
Log in to the tool.
Click the Admin tools tab
Click the Reparse bbcodes link.
Check Parse all Posts.
Submit
Attachments
stk.zip
Modified Support Toolkit to convert [img] tags with width and height attributes to [imgwh] tag
(323.31 KiB) Downloaded 127 times
Have you hugged someone today?
GTunney
Registered User
Posts: 125
Joined: Thu May 17, 2007 4:53 pm

Re: SMF 2.0.1 - phpbb 3.0.9

Post by GTunney »

Once finished should it return to a completed / finished page?

I have followed your instructions but it hasnt done anything and just returns to the reparse BBcode page waiting for me to submit again.

Just keeps going to the white page similar to yesterday.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: SMF 2.0.1 - phpbb 3.0.9

Post by D¡cky »

GTunney wrote:Once finished should it return to a completed / finished page?
Yes, you should get a completed page.
GTunney wrote:I have followed your instructions but it hasnt done anything and just returns to the reparse BBcode page waiting for me to submit again.

Just keeps going to the white page similar to yesterday.
Does it go back to the Reparse BBcode page or to the white page? It can't be doing both.

Did you check the box to parse all posts?
Have you hugged someone today?
GTunney
Registered User
Posts: 125
Joined: Thu May 17, 2007 4:53 pm

Re: SMF 2.0.1 - phpbb 3.0.9

Post by GTunney »

Sorry at first it went back to the reparse screen but not it keeps going to the white screen everytime.

Whilst on the white screen its refreshing then stops.

Yes i did check the box.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: SMF 2.0.1 - phpbb 3.0.9

Post by D¡cky »

When do you get the white page, immediately on pressing Submit?

You should be getting a progress report shortly after pressing Submit, "Step 1 completed, moving on to step2.... Step 2 completed, moving on to step 3 .... etc.

Check your board and see if the imgwh bbcode has been added, Administration Control Panel -> Posting -> BBCodes.
Have you hugged someone today?
GTunney
Registered User
Posts: 125
Joined: Thu May 17, 2007 4:53 pm

Re: SMF 2.0.1 - phpbb 3.0.9

Post by GTunney »

I click submit and it stays on the same page and looks as though it's refreshing then after 2 or 3 minutes the page goes white and it's no longer doing anything.

Similar to the issue when I was trying to convert.

Yes it has added the imgwh bb code but from what I can see hasn't changed any img posts.
Locked

Return to “[3.0.x] Convertors”