[CONVERTOR]myBB 1.4.x to phpBB 3.0.5

[Paul]

A first version of the myBB 1.4.x to phpBB 3.0.5 convertor is now available.
Please note this is a very first version, which is limited tested. Make sure, prior to using it, that you have backups of your boards, and that you have checked if they are working.

Currently, the only way to get the convertor is by SVN, via this page: [Removed] (updated viewtopic.php?p=12874980#p12874980)
Use http://my-svn.assembla.com/svn/mybb_phpbb as checkout url for SVN. If you don't know how SVN works, you should currently not use this convertor.

Please report bugs directly into trac, and ask for support in this topic.
Make sure you read readme.txt prior to using the convertor. This file contains important information.
If you have any suggestions for the convertor, please post them in this topic, or as task at trac.

[mrl586]

Regarding permissions:
The myBB permission system is a pretty weird system, so currently I have decided not to convert any forum or forum moderation permission

MyBB forum permissions seems like phpBB 2.0.x forum permissions.

[Paul]

No, code wise they aren't . At least there is some other stuff around that makes it a bit more complex. I need to find some time to deep digger into the mybb code to see how its really working, but there is some situation where the permissions are not set but there is somewhere a default set.

[PrinceTaz]

how do we download it?

[Paul]

You only can download it from svn, linked from the first post. You will need to have a svn client to be able to download it.

[leoj]

Finally a convertor for MyBB! Will try it out someday this week.

Thanks!

[Mr Brainz]

Hi there,

This is great work. I'm dying to get off MyBB.

Just ran your converter with an install of MyBB 1.4.9 and I got an error on stage .

Can you help me?

Thanks,

Greg

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 ' 16, 0)' at line 2 [1064]

SQL

INSERT INTO k7pk_user_group (user_id, group_id, user_pending) VALUES (, 16, 0)

BACKTRACE

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

FILE: includes/functions_convert.php
LINE: 1169
CALL: dbal_mysqli->sql_query()

FILE: install/convertors/functions_mybb.php
LINE: 789
CALL: user_group_auth()

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

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

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

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

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

FILE: install/index.php
LINE: 282
CALL: module->load()

[Paul]

can you try this version of the file: http://my-trac.assembla.com/mybb_phpbb/ ... s_mybb.php
I think that should fix it.

[Mr Brainz]

Hi Paul,

Thank you for your update. The conversion appears to have worked with no errors.

I really appreciate you taking the time to fix it.

I will have to wait till a quite time on my board to do the migration as the permission changing will take some time!

Thanks again.

[coreymanshack]

I get 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: 464
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: 405
CALL: install_convert->main()

FILE: install/index.php
LINE: 282
CALL: module->load()

What can I do to fix it?

[coreymanshack]

Well I guess I'm going to continue to use mybb since there is no support for this topic anymore.

[Paul]

Well I guess I'm going to continue to use mybb since there is no support for this topic anymore.

Please be a bit patient, iam currently at school and havent had time yet to look. I probarly will not have time this evening,g as I am at work. I will have a look at it tomorrow morning.

[coreymanshack]

I don't know much about phpbb, but from what I know about php,

Code: Select all

$cat_row['right_id']

is blank in this query.

Code: Select all

		$sql = 'UPDATE ' . FORUMS_TABLE . '
			SET left_id = left_id + 2, right_id = right_id + 2
			WHERE left_id > ' . $cat_row['right_id'];

This is how

Code: Select all

$cat_row['right_id'];

is acquired...

Code: Select all

		$sql = 'SELECT left_id, right_id
			FROM ' . FORUMS_TABLE . '
			WHERE forum_id = ' . $row['pid'];
		$_result = $db->sql_query($sql);
		$cat_row = $db->sql_fetchrow($_result);
		$db->sql_freeresult($_result);

I wish I knew more about phpbb or I'd fix it myself

[coreymanshack]

Well, this has taken entirely to long. I knew it was going to be a pain for me to do this, but I went from MyBB1.4>SMF1.*>PHPBB3

All my users passwords are jacked but I'll have to deal with it.

[Paul]

Sorry, but I have a personal life as well . Such things are not just as easy as it looks like, and I cant you just give you a solution.