Page 1 of 12

[CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Posted: Tue Sep 01, 2009 11:57 am
by 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.

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

Posted: Sun Sep 13, 2009 12:17 am
by 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.

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

Posted: Sun Sep 13, 2009 7:22 am
by 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.

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

Posted: Mon Nov 02, 2009 1:31 am
by PrinceTaz
how do we download it?

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

Posted: Mon Nov 02, 2009 9:37 am
by 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.

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

Posted: Mon Nov 02, 2009 5:56 pm
by leoj
Finally a convertor for MyBB! Will try it out someday this week.

Thanks! :D

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

Posted: Tue Nov 10, 2009 8:54 pm
by 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()

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

Posted: Wed Nov 11, 2009 11:00 am
by 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.

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

Posted: Wed Nov 11, 2009 11:42 am
by 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.

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

Posted: Thu Nov 26, 2009 4:48 am
by 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? :)

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

Posted: Thu Nov 26, 2009 3:21 pm
by coreymanshack
Well I guess I'm going to continue to use mybb since there is no support for this topic anymore.

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

Posted: Thu Nov 26, 2009 3:27 pm
by Paul
coreymanshack wrote: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.

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

Posted: Thu Nov 26, 2009 3:47 pm
by 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 :(

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

Posted: Sat Nov 28, 2009 4:47 pm
by 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.

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

Posted: Sat Nov 28, 2009 7:31 pm
by 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.