MyBB Community Forums

Full Version: UTF8 problem with Arabic language
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Ok I want someone showing me how to solve this problem

I did at first choosing " Yes " with this choice


" Automatically convert messages to UTF8?:
Turn this off if the conversion creates
weird characters in your forum's messages. "

But the forum appears as it seen in attachment 1

Next I have chosen " No "

but when I have started the second step

merging the users I have got the problem in attachment 2

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`,`aim`,`yahoo`,`msn`,`hideemail`,`allownotices`,`regip`,`lastip`,`longregip`,`longlastip`,`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`,`failedlogin`,`usernotes`,`passwordconvertsalt`) VALUES ('2','','2','','','0','661','ÑÇÖí','','','0','[email protected]','1297528129','1297528996','1297528129','','1','','1','','','','','0','','','','','1','1','218.111.7.156','','0','0','','95d33d3003bb8d9db6a7908fab0ffa9a','vb3','0','0','','all','2','1','0','1','1','1','0','0','0','0','0','','','0','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','0','0','','z$,')


by the way merging from VB 3.8 to Mybb with Arabic language

I hope you can help me in this problem
Hello
1062 - Duplicate entry 'ÑÇÖí' for key 'username'
means there is already a user by that username in the database.
However, I am not that familiar with the merge system.
Its a new Mybb forum merging with old database


and so what to do with this ?
السلام عليكم
هى القاعدة القديمة بتاعة ماى بى بى ؟

شوف الشرح ده علشان تحول ترميز القاعدة الى utf8
بس ده من خلال الشل ودى احسن طريقة انا جربتها وحولت المنتدى بتاعى بيها بكل بساطة
http://www.traidnt.net/vb/traidnt1425464/

سلام
still waiting for a help