[SPLIT] Convert MyBB to phpBB?

[Mick]

This tends to cause more confusion than help

What does, searching?

I’d be inclined to think the topics of those who have successfully converted would be useful research.

[Times Enemy]

This tends to cause more confusion than help

What does, searching?

I’d be inclined to think the topics of those who have successfully converted would be useful research.

For nearly every topic there is a different setup with different solutions. Searching is easy. Following each topic hoping to get the same results is where the frustration kicks in. Yes, it does cost time, but it also helps widen what does not work for my setup.

I kinda see going through an entire topic, hoping to find a solution, about as helpful as your response.

[Times Enemy]

Where I am at presently:

• Created a new Virtual Machine (VM).
• Installed Debian using the unattended install.
• Installed php5.6 (had to separately install php5.6-xml as well).
• Installed MyBB 1.8.37.
• Installed phpBB 3.1.
• Installed the mybb -> phpbb converter 1.0.2: viewtopic.php?f=486&t=2278541
• Backed up my live MyBB forum. Transferred the backup to my VM.
• Had to manually delete the MyBB database tables one by one. I could have scripted it, but by the time I would have that done I could have just deleted them. This was manually done because phpmyadmin is not fond of php5.6, and every time I try running multiple versions of php I run into errors. So I am trying to do this incrementally.
• Manually imported the MyBB backup database into my VM MyBB database.
• Logged into one of the MyBB Admin accounts and set the theme to some basic theme. (This is because when I deleted everything and imported the backup database the theme was off so all css references failed meaning a basic text and broken formatted forum. Setting the theme fixed this.)
• Based on this topic, I commented out the users.aim line in the convert_mybb18.php file: viewtopic.php?t=2527116
• From the phpBB install page, clicked the convert tab, and began the conversion, until I ran into this error:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'users.yahoo' in 'field list' [1054]

SQL

SELECT users.uid, users.website, users.yahoo, users.icq, users.skype, userfields.fid1 FROM mybb_users users LEFT JOIN mybb_userfields AS userfields ON (users.uid = userfields.ufid) ORDER BY users.uid LIMIT 2000

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/mysql_base.php
LINE: 45
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 261
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

FILE: [ROOT]/install/install_convert.php
LINE: 1263
CALL: phpbb\db\driver\driver->sql_query_limit()

FILE: [ROOT]/install/install_convert.php
LINE: 214
CALL: install_convert->convert_data()

FILE: [ROOT]/install/index.php
LINE: 409
CALL: install_convert->main()

FILE: [ROOT]/install/index.php
LINE: 289
CALL: module->load()

This looks similar to the users.aim error mentioned here: viewtopic.php?t=2527116

• I commented out the users.yahoo line, just as I had commented out the users.aim line.
• This worked!

I now have a phpBB 3.1 instance of my forum up. I do not have any forums or such visible yet, but I can see them in there when in the ACP. I will have to tinker with phpBB a bit to get the forums and posts visible, then I will upgrade 3.1 to 3.2 to 3.x.

Thank you for any assistance you may have provided. If someone finds this topic in the future I hope it is helpful. I did not break my steps down by showing keystrokes, but the bullet list in this post alone should suffice to get you through the conversion.

[Times Enemy]

Resetting all my forum permissions is a hassle. It would be nice if the converter tool was more interactive with this portion of the conversion and walked us through forum permissions.

Icons and such seem to be odd, in that the Topic Icons during the post composition process are not being displayed. (I will search on this and possibly make another topic on it.)

The default spam features for phpBB seem to be lacking. The moment I made my newly converted forum live (online) I received a pile of spam accounts that I had to clean out. I have since upped the registration security to questions and answers. We shall see where that takes us.

All in all, I am very excited to be part of the phpBB community!