XF 2.3 Cannot import database ERROR 1062 Duplicate entry for key 'xf_user.username'

unproperlypropagated

unproperlypropagated

Active member
ERROR 1062 (23000) at line 7089: Duplicate entry 'Zerø' for key 'xf_user.username'

It won't let me import the database because it says 2 users have the name
In reality only the first 4 characters are the same. Why does it stop checking there? Something about the ø character? Maybe it shouldn't be allowed?

Zerø
Zerø-BlackCat

Untitled.webp

Untitled1.webp
 
Last edited:
Sort by date Sort by votes
Code: 
ERROR 1062 (23000) at line 7098: Duplicate entry 'noxx' for key 'xf_user.username'

Untitled3.webp


what's going on here?

update
unproperlypropagated

XF 2.2 Thread 'ø is seen as a normal o under utf8mb4_general_ci'

Xenforo considers ø and o as different characters, allowing 2 different people having usernames like
yolo and yolø

But then when you export this database and try to re-import it:
Code: 
ERROR 1062 (23000) at line 7098: Duplicate entry 'yolo' for key 'xf_user.username'

Suggestion: instead of utf8mb4_general_ci use utf8mb4_unicode_ci (Accent-Sensitive)

I'm not sure about modifying the database so if an admin can reply it'll be grand.
 
Last edited:
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

btmgreg
  • Question Question
XF 2.2 ACP Error - Job XF:Feeder: MySQL query error [1062]: Duplicate entry '4-1641832730903322626' for key 'PRIMARY'
Replies
5
Views
706
btmgreg
btmgreg
B
MySQL query error [1062]: Duplicate entry '9738' for key 'PRIMARY'
Replies
1
Views
1K
by_carizma
B
Nirjonadda
Server issue MySQL query error [1062]: Duplicate entry 'hasan69' for key 'xf_user.username'
Replies
7
Views
1K
javilonas
javilonas
C
  • Question Question
MG 2.2 XFMG MySQL query error [1062]: Duplicate entry
Replies
3
Views
893
chrisf
C
AndyB
XF 2.2 XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry
Replies
2
Views
742
AndyB
AndyB
Back
Top Bottom