Error converting from mybb 1.8.20 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.
emmy229
Registered User
Posts: 15
Joined: Fri Oct 09, 2015 6:58 pm

Error converting from mybb 1.8.20 to phpbb

Post by emmy229 »

Good day, I am attempting to convert my mybb board from the version 1.8.20 to phpbb3.1 prior to converting to phpbb3.2. As the only available convertor works for phpbb3.1. In the process of the conversion, the following errors came up.

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 mybbvn_users users LEFT JOIN mybbvn_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()
I appreciate any and all help on this. Thank you.
User avatar
EA117
Registered User
Posts: 2171
Joined: Wed Aug 15, 2018 3:23 am

Re: Error converting from mybb 1.8.20 to phpbb

Post by EA117 »

Hmm. I've never used myBB, but looks like their 1.8.16 update intentionally dropped the users.aim column from the database as obsolete. So now this March 2015 / myBB 1.6.16-era converter cannot work as-is. Or I should say, at minimum this is why it cannot work as-is.

It looks straight-forward enough to simply remove the attempt to convert the myBB AIM profile field into a phpBB AIM profile field? But I have no way to know, no way to test, and no reason to think there can't be other myBB changes that we'll just run into next. But willing to give it a shot if you are.

Can't post a .ZIP file here though, and the phpBB 3.1.x converter thread is locked so I can't drop it there either. So I've sent "exactly the same 1.0.2 converter, but with the AIM profile field handling removed" to your PM inbox. We'll just have to see if that helps at all, or just bumps into yet another issue.
emmy229
Registered User
Posts: 15
Joined: Fri Oct 09, 2015 6:58 pm

Re: Error converting from mybb 1.8.20 to phpbb

Post by emmy229 »

Thank you. Will use this now.
Just did, it passed that stage, though another error is encountered. This,

Code: Select all

General Error
SQL ERROR [ mysqli ]

Duplicate entry 'adsbot [google]' for key 'username_clean' [1062]

SQL

INSERT INTO phpbb_users (username, username_clean, user_password, user_email, user_email_hash, group_id, user_type, user_permissions, user_timezone, user_dateformat, user_lang, user_style, user_actkey, user_ip, user_regdate, user_passchg, user_options, user_new, user_inactive_reason, user_inactive_time, user_lastmark, user_lastvisit, user_lastpost_time, user_lastpage, user_posts, user_colour, user_avatar, user_avatar_type, user_avatar_width, user_avatar_height, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_message_rules, user_full_folder, user_emailtime, user_notify, user_notify_pm, user_notify_type, user_allow_pm, user_allow_viewonline, user_allow_viewemail, user_allow_massemail, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfield, user_form_salt) VALUES ('AdsBot [Google]', 'adsbot [google]', '', '', '00', 13, 2, '', 'UTC', 'D M d, Y g:i a', 'en', 1, '', '', 1571828067, 1571828067, 230271, 0, 0, 0, 1571828067, 0, 0, '', 0, '9E8DA7', '', '', 0, 0, 0, 0, 0, 0, -3, 0, 0, 1, 0, 1, 1, 1, 0, '', '', '', 'aa8977f167bf7633')

BACKTRACE

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

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

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

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

FILE: [ROOT]/includes/functions_convert.php
LINE: 1929
CALL: user_add()

FILE: [ROOT]/install/install_convert.php(1688) : eval()'d code
LINE: 2
CALL: add_bots()

FILE: [ROOT]/install/install_convert.php
LINE: 1688
CALL: eval()

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

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()
Checked the convertor php file noticed there were two similar such entries in line 259 and line 738. Though, i dont know what they are doing, if that is the cause and which to delete if that happens to be the case. Would appreciate any help on this. Thanks all.
User avatar
EA117
Registered User
Posts: 2171
Joined: Wed Aug 15, 2018 3:23 am

Re: Error converting from mybb 1.8.20 to phpbb

Post by EA117 »

Oh well. The odds were against this being the only issue that would be encountered, but one can always hope. 😁

However, I think this particular error is suggesting that we simply needed to "start clean" with the re-conversion attempt. The code failing here is phpBB's own attempt to perform the add_bots() processing provided by /includes/functions_convert.php. When you first attempted conversion, both the phpbb_users and phpbb_bots tables would have been empty, and add_bots() wouldn't have collided with existing bot users in the phpbb_users table.

That you're hitting this error now I think is probably just an indication of "we didn't start the conversion over again with an empty database." If that's not the case, and you did drop all tables from the existing database and/or created a new database for the new conversion attempt, then let us know and we'll look deeper at whether there is some different fundamental issue here. But I think "making the conditions the same as your first-time conversion attempt" is going to avoid this particular error.

Which of course doesn't mean we won't hit a different issue before successful conversion, but that perhaps you can easily avoid this one.


Let me also clarify: I said "this March 2015 / myBB 1.6.16-era converter" because the mybb18_convertor_1.0.2.zip files were dated March 2015, which according to the myBB versions table, was a time frame prior to the myBB 1.6.17 release. But I see in-code comments which declare this to be "the MyBB 1.8.x to phpBB 3.1.x Convertor." So the code's compatibility intention might not be as "old" as myBB 1.6.16; all we know for certain is that it pre-dates the myBB 1.8.16 or later changes.
emmy229
Registered User
Posts: 15
Joined: Fri Oct 09, 2015 6:58 pm

Re: Error converting from mybb 1.8.20 to phpbb

Post by emmy229 »

Thank you very much. Its been successfully converted. I'm really grateful :o :D
User avatar
EA117
Registered User
Posts: 2171
Joined: Wed Aug 15, 2018 3:23 am

Re: Error converting from mybb 1.8.20 to phpbb

Post by EA117 »

Nice; glad that worked out for getting through the conversion.


For anyone who comes across this later and needs to create the same "mybb18_convertor_1.0.2 but without the attempt to convert the AIM profile field" set of files, it really was as straight-forward as just removing this line from the convert_mybb18.php file:

Code: Select all

		array('pf_phpbb_aol',			'users.aim',						array($helper, 'set_encoding')),
Or you can just replace the convert_mybb18.php included in the mybb18_convertor_1.0.2.zip files with the pre-edited copy attached here.

convert_mybb18.php

I should also confirm: This is still a phpBB 3.1 converter, and is only known to work properly when converting to phpBB 3.1.x first. The script has not been evaluated or changed for any phpBB 3.2.x compatibility issues.
You do not have the required permissions to view the files attached to this post.
Rusty2009
Registered User
Posts: 2
Joined: Mon Apr 06, 2015 11:34 am

Re: Error converting from mybb 1.8.20 to phpbb

Post by Rusty2009 »

I was having issues converting mybb 1.8.37 to phpbb 3.1.12

Simllar issues the OP had.

But this time reporting users.yahoo

I had to remove the line from the updated file for the conversion to complete.

Line 793

Code: Select all

array('pf_phpbb_yahoo',			'users.yahoo',						array($helper, 'set_encoding')),

Return to “[3.2.x] Convertors”