[CONVERTOR]myBB 1.4.x to phpBB 3.0.5

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
vovas
Registered User
Posts: 14
Joined: Sun Feb 14, 2010 9:37 am
Location: USSR

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by vovas »

Sorry.

Third screenshot... ;)
tables
tables
unnamed.JPG (149.88 KiB) Viewed 1962 times
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: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by D¡cky »

Thank you. I see where the problem is. Now to try and fix it.
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
Contact:

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by D¡cky »

vovas,

This should work for you

OPEN functions_mybb.php
FIND

Code: Select all

	$sql = 'SELECT * FROM ' . $convert->src_table_prefix . 'forums ORDER BY pid, fid, disporder' ;
REPLACE WITH

Code: Select all

	$sql = 'SELECT * FROM ' . $convert->src_table_prefix . 'forums ORDER BY type, fid' ;
Warning to others: The above is only a temporary fix. It may or may not work for you
Have you hugged someone today?
User avatar
vovas
Registered User
Posts: 14
Joined: Sun Feb 14, 2010 9:37 am
Location: USSR

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by vovas »

DIcky,

I downloaded converter and try again.
Changed this row to correct one:

Code: Select all

$sql = 'SELECT * FROM ' . $convert->src_table_prefix . 'forums ORDER BY type, fid' ;
But still this error

Code: Select all

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 '' at line 3 [1064]

SQL

UPDATE phpbb_forums SET left_id = left_id + 2, right_id = right_id + 2 WHERE left_id > 

BACKTRACE


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

FILE: install/convertors/functions_mybb.php
LINE: 463
CALL: dbal_mysqli->sql_query()

FILE: install/install_convert.php(1003) : eval()'d code
LINE: 7
CALL: mybb_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: 409
CALL: install_convert->main()

FILE: install/index.php
LINE: 286
CALL: module->load()
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: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by D¡cky »

vovas,

I just tried again with the forum setup that you have posted in your screenshots and the convertor converted all the forums with no problem.

Would you double check in functions_mybb.php that line 334 is

Code: Select all

$sql = 'SELECT * FROM ' . $convert->src_table_prefix . 'forums ORDER BY type, fid' ;
ORDER BY type, fid is important.

Also look at the phpBB3 forums table and tell me what forums have been inserted so far.
Have you hugged someone today?
User avatar
vovas
Registered User
Posts: 14
Joined: Sun Feb 14, 2010 9:37 am
Location: USSR

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by vovas »

Ok. Thanks. Convert finished successfully. But after conversation I can not open main page of my forum. Address is http://forums.infoblog.ws.
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: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by D¡cky »

Gzip compression is probably turned on. You can turn it off with phpMyAdmin. In the phpBB config table, set gzip_compress to 0. After changing this setting, empty the phpBB cache folder of all files except for .htaccess and index.htm.
Have you hugged someone today?
User avatar
vovas
Registered User
Posts: 14
Joined: Sun Feb 14, 2010 9:37 am
Location: USSR

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by vovas »

Thank You very much! Now it's works fine :) Unfortunately without attachements...
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: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by D¡cky »

vovas wrote:Thank You very much! Now it's works fine :) Unfortunately without attachements...
It doesn't do private messages either.
Have you hugged someone today?
Pat.rick
Registered User
Posts: 1
Joined: Sun Apr 11, 2010 12:51 am

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by Pat.rick »

Thanks a lot for the converter. The only problem I've discovered is that posts by unregistered users / guests aren't converted.
JarekMk
Registered User
Posts: 1
Joined: Sun Apr 25, 2010 2:53 pm

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by JarekMk »

Hi,

I've quiet problem... I started convert about 40 min ago and it's still making something.. is't isn't to long? My board is quiet smal...

Thanks for reply.


BR
lukasamd
Registered User
Posts: 100
Joined: Sat Jul 12, 2008 8:14 am

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by lukasamd »

I've the same problem...
Forum about 15.000 posts using mysql myisam db engine and utf-8 unicode coding.

There aren't any information in mysql slow-logs, php error log and apache logs during the convert process.
I tried convert mybb 1.4.9 to phpbb 3.0.7-pl1, and there is a "freeeze", when I start convert.

Should I convert exactly to phpBB 3.0.5?
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: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by D¡cky »

lukasamd wrote:I've the same problem...
Forum about 15.000 posts using mysql myisam db engine and utf-8 unicode coding.

There aren't any information in mysql slow-logs, php error log and apache logs during the convert process.
I tried convert mybb 1.4.9 to phpbb 3.0.7-pl1, and there is a "freeeze", when I start convert.

Should I convert exactly to phpBB 3.0.5?
The convertor will work the same on 3.0.7-PL1 as 3.0.5. You should always use the latest version of phpBB.

What do you mean by "freeeze?"
What step are you at?
Do you get a blank screen or an error message?
Have you hugged someone today?
lukasamd
Registered User
Posts: 100
Joined: Sat Jul 12, 2008 8:14 am

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by lukasamd »

D¡cky wrote:What do you mean by "freeeze?"
What step are you at?
Do you get a blank screen or an error message?
I done all steps, and convert was started.
I was waiting, waiting, waiting and waiting... about 25 minutes.

Page was still loading, but there wasn't any error (I have correct error_reporting) and I didn't get a blank page.
When I closed browser with running converter and opened the phpbb3 forum, there weren't any posts, topics or users. All looks like before attempt.
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: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by D¡cky »

lukasamd wrote:
D¡cky wrote:What do you mean by "freeeze?"
What step are you at?
Do you get a blank screen or an error message?
I done all steps, and convert was started.
I was waiting, waiting, waiting and waiting... about 25 minutes.

Page was still loading, but there wasn't any error (I have correct error_reporting) and I didn't get a blank page.
When I closed browser with running converter and opened the phpbb3 forum, there weren't any posts, topics or users. All looks like before attempt.
The first step checks for colliding usernames which doesn't display anything until after it is done. I assume that you have less than 18000 members which shouldn't take 25 minutes to do, but it could take 10 minutes or more. The convertor does create a userconv table to temporarily store the usernames. You can check that table to see if it is being populated. I cannot say if the problem is with your MyBB database or with the function itself. I don't have a board of any size to test on.
Try the following and see if it helps.
Open phpbb3/install/install_convert.php

Find:

Code: Select all

<?php
/**
*
* @package install
* @version $Id: install_convert.php 9936 2009-08-07 12:50:25Z bantu $
* @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');
Have you hugged someone today?
Locked

Return to “[3.0.x] Convertors”