converting mybb to phpbb

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
jonhcarter
Registered User
Posts: 37
Joined: Fri Aug 10, 2018 4:04 am

converting mybb to phpbb

Post by jonhcarter »

Hello friends,

i'm converting mybb 1.8.17 to latest phpbb 3.1.12 & i'm getting error given below:

Code: Select all

General Error
SQL ERROR [ mysqli ]

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

SQL

SELECT users.uid, users.website, users.yahoo, users.aim, 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()
please help me to fix this issue.

thanks in advance :)
jonhcarter
Registered User
Posts: 37
Joined: Fri Aug 10, 2018 4:04 am

Re: converting mybb to phpbb

Post by jonhcarter »

i have fixed it myself & i have migrated forum from mybb1.8 > 3.1.12 > 3.2 successfully. now the problem is the user of the forum is getting "This board has no forums." error. i have fixed it for anonymous users but for existing use which permission will work "newly registered user" or "standard features".
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26870
Joined: Fri Aug 29, 2008 9:49 am

Re: converting mybb to phpbb

Post by Mick »

Please start a fresh topic in support for your permission questions, thanks.
  • "The more connected we get the more alone we become” - Kyle Broflovski© 🇬🇧

Return to “[3.2.x] Convertors”