[F] phpBB3: SQL error 1062 during users import

[Michael S.]

A user reported that he gets the following error converting from phpBB3. He said he had no problems with beta3 but with beta5 it isn't working.

Code:

SQL Error:
    1062 - Duplicate entry 'K' for key 2
Query:
    INSERT INTO mybb_users (`usergroup`,`additionalgroups`,`displaygroup`,`import_usergroup`,`import_additi​​onalgroups`,`import_displaygroup`,`import_uid`,`username`,`password`,`salt`,`lo​g​inkey`,`email`,`regdate`,`lastactive`,`lastvisit`,`website`,`showsigs`,`signat​ur​e`,`showavatars`,`timezone`,`avatardimensions`,`avatartype`,`avatar`,`lastpos​t`,​`icq`,`aim`,`yahoo`,`msn`,`hideemail`,`allownotices`,`regip`,`lastip`,`longr​egip​`,`longlastip`,`language`,`passwordconvert`,`passwordconverttype`,`postnum`​,`inv​isible`,`birthday`,`birthdayprivacy`,`subscriptionmethod`,`receivepms`,`pm​notice​`,`pmnotify`,`remember`,`showquickreply`,`ppp`,`tpp`,`daysprune`,`timefor​mat`,`d​st`,`buddylist`,`ignorelist`,`style`,`away`,`awaydate`,`returndate`,`ref​errer`,`​reputation`,`timeonline`,`showcodebuttons`,`totalpms`,`unreadpms`,`pmfo​lders`,`n​otepad`,`threadmode`,`showredirect`,`dateformat`,`dstcorrection`,`warn​ingpoints`​,`moderateposts`,`moderationtime`,`suspendposting`,`suspensiontime`,`​coppauser`,​`classicpostbit`,`loginattempts`,`failedlogin`) VALUES ('2','','2','2','','2','635','K�bler','','irgendeincode','irgendeincode','email@​​example.com','Nummer','Nummer','GleicheNummerWieDavor','','1','','1','10','0|0','','','0​​','','','','','1','0','***IP-Adresse***','','0','0','','***Code***','phpbb3','0','1','','all','0','1','1','1'​​,'1','1','0','0','0','D j. M Y, H:i','1','','','0','0','0','0','0','0','0','1','0','0','1**Inbox$%%$2**Sent Items$%%$3**Drafts$%%$4**Trash Can','','','1','0','1','0','0','0','0','0','0','0','0','0')

[MattRogowski]

Me and Josh actually got this on Beta 3 IIRC. It's doesn't seem to happen every time though, it's odd, sometimes it works fine, sometimes it gives this error.

[Ryan Gordon]

Please provide repro. instructions. There is no clear reason why this is happening as we already have a separate duplicate users handling code

[pcworld]

I'm the user who get this error.

The error comes, when I convert the users, but only with users, who have German umlauts like ä, ö or ü in their username.

The database encoding is UTF-8 Unicode.

pcworld

[Ryan Gordon]

That makes more sense - Though it is still odd that MySQL isn't matching those strings properly

[pcworld]

Is it possible that this bug can be fixed?

pcworld

[pcworld]

So, now it is working.
The database must have the correct encoding...

But there was one bug, too: Then I it was possible to convert the phpBB3. But if there was a German umlaut like ä, ö or ü in a forum description or in a post, the post was be cutted at the place, where normally the umlaut stands.
So that is the answer to this problem:
Before converting, replace in inc/config.php this:

Code:

$config['database']['encoding'] = 'utf8';

with this:

Code:

$config['database']['encoding'] = '';

And after the converting do it backwards.

Sorry for my bad English
German users can read the answer to the problem here: http://forum.mybboard.de/thread-13566-post-97010.html

pcworld

[Ryan Gordon]

I think I fixed it - It looks like the LOWER() function in MySQL isn't UTF-8 safe or has some sort of bug.

[Ryan Gordon]

This bug has been fixed in the latest version of the MyBB Merge System.

Please note the latest code is not live on the site or for download. An update for the MyBB Merge System will be released which contains this fix.

With regards,
The MyBB Group