MyBB Community Forums

Full Version: MyBB SQL Error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Good morning.

I'm really wanting to convert my old (like really old) PhpBB 3.0.x message board over to MyBB. However, I have run into an error importing the users.. 

SQL Error:
1054 - Unknown column 'aim' in 'field list'

Query:
INSERT INTO mybbcp_users (`usergroup`,`additionalgroups`,`etc...)

Possible that the "aim" field was not a default phpbb3 field? Idk but there's no "plugins" to disable for that. How does one get around this? Maybe there needs to be a "skip field import"? Obviously don't need this field anymore these days anyway.. lol who uses AIM??? All i can do is pause and go back to the index and hit resume and get the same error. 
 
Any help is much appreciated..
Please try to use the latest dev build from GitHub: https://github.com/mybb/merge-system
Download the merge system as a .zip file: https://github.com/mybb/merge-system/arc...eature.zip

By the way, you might want to remove some sensitive data from your post where hashed password is included.
Also attached a screencap of the user control area fields.. i would assume id run into issues with some of these others, MSN, ICQ? old stuff...

Well i guess attachments didnt work.. but the copy i got of the merge was at "https://resources.mybb.com/downloads/merge_1811.zip"

I love you bro. lol

The copy of the merge system one you recommended seems to have worked. I'll report back after testing.

"General Statistics
You merged phpBB 3 to your forum.

Import began
Fri, 29 May 2020 14:11:52 +0000
Import finished
Fri, 29 May 2020 17:17:35 +0000"