Page 1 of 1

converting mybb to phpbb

Posted: Fri Aug 10, 2018 4:09 am
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]


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


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 :)

Re: converting mybb to phpbb

Posted: Fri Aug 10, 2018 8:01 am
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".

Re: converting mybb to phpbb

Posted: Fri Aug 10, 2018 8:21 am
by Mick
Please start a fresh topic in support for your permission questions, thanks.