MyBB Community Forums

Hi,


Hi, I have the following problem with migrating IPB 4 forum to MyBB. Has the database structure changed somehow and the migrator needs to be modified somehow? I will mention that there are no duplicates in the name field.

https://i.imgur.com/2jf2bAj.png

https://i.imgur.com/UqAF8jI.png

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1062 - Duplicate entry '' for key 'username'
Query:
INSERT INTO mybb_users (`usergroup`,`additionalgroups`,`displaygroup`,`import_usergroup`,`import_additionalgroups`,`import_displaygroup`,`import_uid`,`username`,`password`,`salt`,`loginkey`,`email`,`regdate`,`lastactive`,`lastvisit`,`website`,`showsigs`,`signature`,`showavatars`,`timezone`,`avatardimensions`,`avatartype`,`avatar`,`lastpost`,`icq`,`skype`,`google`,`hideemail`,`allownotices`,`regip`,`lastip`,`language`,`passwordconvert`,`passwordconverttype`,`postnum`,`invisible`,`birthday`,`birthdayprivacy`,`subscriptionmethod`,`receivepms`,`receivefrombuddy`,`pmnotice`,`pmnotify`,`showquickreply`,`ppp`,`tpp`,`daysprune`,`timeformat`,`dst`,`buddylist`,`ignorelist`,`style`,`away`,`awaydate`,`returndate`,`referrer`,`referrals`,`reputation`,`timeonline`,`showcodebuttons`,`totalpms`,`unreadpms`,`pmfolders`,`notepad`,`threadmode`,`showredirect`,`dateformat`,`dstcorrection`,`warningpoints`,`moderateposts`,`moderationtime`,`suspendposting`,`suspensiontime`,`suspendsignature`,`suspendsigtime`,`coppauser`,`classicpostbit`,`loginattempts`,`usernotes`,`showimages`,`showvideos`,`passwordconvertsalt`) VALUES (4,'',0,4,'',0,2,'','','','','[email protected]',1694163889,1697654166,1697550479,'',1,'',1,'1','','','',0,'','','',1,1,X'5beea6ef',X'','','$2y$10$sdffsdsdfsfdsfdsfd/YJ.sdfssdfsfdgdssgdgd','ipb3',0,0,'','all',2,1,0,1,1,1,0,0,0,'',0,'','',0,0,0,'',0,0,0,0,1,0,0,'0**$%%$1**$%%$2**$%%$3**$%%$4**','','',1,'',1,0,0,0,0,0,0,0,0,0,0,'',1,1,'')

The 8th field in the Insert query is 'username', and the 8th value is '', so it seems there's a mismatch between the 2 systems. Username must be unique and not null. You can investigate the script to find out how the source fields for username, password, salt and loginkey are coming up empty.

In the past, when migration problems have occurred, the suggestion is to get the migration tool from github somewhere. Maybe you are running an outdated merge tool.

Just guessing. Never had the option to merge from somewhere else.

Good luck.

(2023-12-13, 02:39 PM)HLFadmin Wrote: [ -> ]the suggestion is to get the migration tool from github somewhere

somewhere may be here: https://github.com/mybb/merge-system

and here is a propably solution: https://github.com/mybb/merge-system/pull/297/files

Could it be possible IPB allows for empty names ? Just from the screenshot it seems there are (empty) duplicates for the name column.

(2023-12-13, 05:48 PM)Omar G. Wrote: [ -> ]Could it be possible IPB allows for empty names ? Just from the screenshot it seems there are (empty) duplicates for the name column.

To confirm I send a snapshot, the name table does not contain duplicates, nor is it empty - I had to hide the data for obvious reasons.
https://i.imgur.com/Un7KbO9.png



@HLFadmin
Thanks for the hint, I just noticed that the column is not loading from the correct location.

@bv64
I used this package and patch regarding IPB4, but in my case it did not solve the problem - I will analyze the code, maybe it is enough to improve something in it
https://github.com/mybb/merge-system/pull/297/files

good luck

If you feel like it you could share an thread in the Private Inquiries forum sharing your data base file I could make some tests :
https://community.mybb.com/forum-135.html

Thank you all for your help so far, the solution seemed trivial. It seemed to me that it would be necessary to convert to UTF-8 and without that not to move, it was enough to uncheck this option in my case so that the data from the core_members table is correctly retrieved from the database. Snapshot below of the option in migrator.

https://i.imgur.com/8qSubbs.png

It is possible that option should be disabled by default.

(2023-12-15, 05:40 AM)Soczysty Wrote: [ -> ]Thank you all for your help so far, the solution seemed trivial. It seemed to me that it would be necessary to convert to UTF-8 and without that not to move, it was enough to uncheck this option in my case so that the data from the core_members table is correctly retrieved from the database. Snapshot below of the option in migrator.

https://i.imgur.com/8qSubbs.png

Hmm. Did you use the Merge System from MyBB's download site or from GitHub?

You may use the development build from https://github.com/mybb/merge-system , get it as a .zip file via https://github.com/mybb/merge-system/arc...eature.zip although this one could also have bugs.