[CONVERTOR]myBB 1.4.x to phpBB 3.0.5

[vovas]

Sorry.

Third screenshot...

tables

unnamed.JPG (149.88 KiB) Viewed 1962 times

[D¡cky]

Thank you. I see where the problem is. Now to try and fix it.

[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

[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()

[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.

[vovas]

Ok. Thanks. Convert finished successfully. But after conversation I can not open main page of my forum. Address is http://forums.infoblog.ws.

[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.

[vovas]

Thank You very much! Now it's works fine Unfortunately without attachements...

[D¡cky]

Thank You very much! Now it's works fine Unfortunately without attachements...

It doesn't do private messages either.

[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]

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]

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?

[D¡cky]

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?

[lukasamd]

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.

[D¡cky]

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');