[Skip to main content](#vessel-content) # how to fix 'Illegal mix of collations' error ## - **[jkfang](/forum/user/31251-jkfang "View jkfang's Profile")** - [![jkfang's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31251-jkfang "View jkfang's Profile") Topic Author - [ Offline](/forum/user/31251-jkfang) Less More - Posts: 24 - Thank you received: 1 - - 9 years 3 months ago - 9 years 3 months ago [\#275324](#275324) by [jkfang](/forum/user/31251-jkfang "View jkfang's Profile") *[how to fix 'Illegal mix of collations' error](/forum/25-install-update/891401-how-to-fix-illegal-mix-of-collations-error#275324 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.1.5 -- Browser(s) name and version -- : Chrome 59.0.3071.115 I installed Hikashop Business 3.1.1 this morning. When I checked database in system/configuration，I found the following error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' This error seems to relate to 'User email addresses synchronized' How to fix this error?")* was created by *[jkfang](/forum/user/31251-jkfang "View jkfang's Profile")* -- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.1.5 -- Browser(s) name and version -- : Chrome 59.0.3071.115 I installed Hikashop Business 3.1.1 this morning. When I checked database in system/configuration，I found the following error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' This error seems to relate to 'User email addresses synchronized' How to fix this error? - [ ![error.jpg](/forum/attachment/39558) ](/forum/attachment/39558 "error.jpg") [ ](/forum/attachment/39558?download=1 "error.jpg") Last edit: 9 years 3 months ago by [jkfang](/forum/user/31251-jkfang "View jkfang's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTQwMS1ob3ctdG8tZml4LWlsbGVnYWwtbWl4LW9mLWNvbGxhdGlvbnMtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jkfang](/forum/user/31251-jkfang "View jkfang's Profile")** - [![jkfang's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31251-jkfang "View jkfang's Profile") Topic Author - [ Offline](/forum/user/31251-jkfang) Less More - Posts: 24 - Thank you received: 1 - - 9 years 3 months ago [\#275363](#275363) by [jkfang](/forum/user/31251-jkfang "View jkfang's Profile") Replied by *[jkfang](/forum/user/31251-jkfang "View jkfang's Profile")* on topic *[how to fix 'Illegal mix of collations' error](/forum/25-install-update/891401-how-to-fix-illegal-mix-of-collations-error#275363 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.1.5 -- Browser(s) name and version -- : Chrome 59.0.3071.115 I installed Hikashop Business 3.1.1 this morning. When I checked database in system/configuration，I found the following error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' This error seems to relate to 'User email addresses synchronized' How to fix this error?")* The problem has been solved. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTQwMS1ob3ctdG8tZml4LWlsbGVnYWwtbWl4LW9mLWNvbGxhdGlvbnMtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26395 - Thank you received: 4077 - - [](http://obsi.dev) - 9 years 3 months ago [\#275367](#275367) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[how to fix 'Illegal mix of collations' error](/forum/25-install-update/891401-how-to-fix-illegal-mix-of-collations-error#275367 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.1.5 -- Browser(s) name and version -- : Chrome 59.0.3071.115 I installed Hikashop Business 3.1.1 this morning. When I checked database in system/configuration，I found the following error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' This error seems to relate to 'User email addresses synchronized' How to fix this error?")* Hello, Good to know that your problem is solved. Just in case, if other user got the same kind of problem : The message in the "check database" is not problematic if your users are already sync. It mostly indicate that it can't perform the verification. But it also means that you have tables in your database with different collations and you might want to uniformise them. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTQwMS1ob3ctdG8tZml4LWlsbGVnYWwtbWl4LW9mLWNvbGxhdGlvbnMtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.043 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)