[Skip to main content](#vessel-content) # How to fix this problem? Error Illegal mix of collisions ## - **[Tassanai](/forum/user/33163-tassanai "View Tassanai's Profile")** - [![Tassanai's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33163_2015-03-11.jpg)](/forum/user/33163-tassanai "View Tassanai's Profile") Topic Author - [ Offline](/forum/user/33163-tassanai) Less More - Posts: 25 - Thank you received: 0 - - - - [](http://www.aconplus.co.th) - 9 years 5 months ago [\#268989](#268989) by [Tassanai](/forum/user/33163-tassanai "View Tassanai's Profile") *[How to fix this problem? Error Illegal mix of collisions](/forum/4-how-to/890133-how-to-fix-this-problem-error-illegal-mix-of-collisions#268989 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : Joomla! 3.7.0 -- PHP version -- : 3.5.8.2 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error Illegal mix of collisions (utf8_general_ci, IMPLICIT) and (utf8_unicode_ci, IMPLICIT) for operation '=' I checked the database in hikashop config. Error Illegal mix of collisions (utf8_general_ci, IMPLICIT) and (utf8_unicode_ci, IMPLICIT) for operation '=' How to fix this problem?")* was created by *[Tassanai](/forum/user/33163-tassanai "View Tassanai's Profile")* -- HikaShop version -- : 3.0.1 -- Joomla version -- : Joomla! 3.7.0 -- PHP version -- : 3.5.8.2 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error Illegal mix of collisions (utf8_general_ci, IMPLICIT) and (utf8_unicode_ci, IMPLICIT) for operation '=' I checked the database in hikashop config. Error Illegal mix of collisions (utf8_general_ci, IMPLICIT) and (utf8_unicode_ci, IMPLICIT) for operation '=' How to fix this problem? - [ ![2017-05-08_16-40-40.jpg](/forum/attachment/38004) ](/forum/attachment/38004 "...8_16-40-40.jpg") [ ](/forum/attachment/38004?download=1 "...8_16-40-40.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MDEzMy1ob3ctdG8tZml4LXRoaXMtcHJvYmxlbS1lcnJvci1pbGxlZ2FsLW1peC1vZi1jb2xsaXNpb25zP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86357 - Thank you received: 14289 - - 9 years 5 months ago [\#269006](#269006) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to fix this problem? Error Illegal mix of collisions](/forum/4-how-to/890133-how-to-fix-this-problem-error-illegal-mix-of-collisions#269006 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : Joomla! 3.7.0 -- PHP version -- : 3.5.8.2 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error Illegal mix of collisions (utf8_general_ci, IMPLICIT) and (utf8_unicode_ci, IMPLICIT) for operation '=' I checked the database in hikashop config. Error Illegal mix of collisions (utf8_general_ci, IMPLICIT) and (utf8_unicode_ci, IMPLICIT) for operation '=' How to fix this problem?")* Hi, Edit your hikashop_user table or the users table of Joomla via your PHPMyAdmin and make sure that they use the same charset. [ mediatemple.net/community/products/dv/20...er-set-and-collation](https://mediatemple.net/community/products/dv/204403914/default-mysql-character-set-and-collation) The following user(s) said Thank You: [Tassanai](/forum/user/33163-tassanai "View Tassanai's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MDEzMy1ob3ctdG8tZml4LXRoaXMtcHJvYmxlbS1lcnJvci1pbGxlZ2FsLW1peC1vZi1jb2xsaXNpb25zP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Tassanai](/forum/user/33163-tassanai "View Tassanai's Profile")** - [![Tassanai's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33163_2015-03-11.jpg)](/forum/user/33163-tassanai "View Tassanai's Profile") Topic Author - [ Offline](/forum/user/33163-tassanai) Less More - Posts: 25 - Thank you received: 0 - - - - [](http://www.aconplus.co.th) - 9 years 5 months ago [\#269058](#269058) by [Tassanai](/forum/user/33163-tassanai "View Tassanai's Profile") Replied by *[Tassanai](/forum/user/33163-tassanai "View Tassanai's Profile")* on topic *[How to fix this problem? Error Illegal mix of collisions](/forum/4-how-to/890133-how-to-fix-this-problem-error-illegal-mix-of-collisions#269058 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : Joomla! 3.7.0 -- PHP version -- : 3.5.8.2 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error Illegal mix of collisions (utf8_general_ci, IMPLICIT) and (utf8_unicode_ci, IMPLICIT) for operation '=' I checked the database in hikashop config. Error Illegal mix of collisions (utf8_general_ci, IMPLICIT) and (utf8_unicode_ci, IMPLICIT) for operation '=' How to fix this problem?")* I try to do as Hikashop told me already. But there are also Error Messages, what do I do? - [ ![IMG_0468.PNG](/forum/attachment/38024) ](/forum/attachment/38024 "IMG_0468.PNG") [ ](/forum/attachment/38024?download=1 "IMG_0468.PNG") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MDEzMy1ob3ctdG8tZml4LXRoaXMtcHJvYmxlbS1lcnJvci1pbGxlZ2FsLW1peC1vZi1jb2xsaXNpb25zP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Tassanai](/forum/user/33163-tassanai "View Tassanai's Profile")** - [![Tassanai's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33163_2015-03-11.jpg)](/forum/user/33163-tassanai "View Tassanai's Profile") Topic Author - [ Offline](/forum/user/33163-tassanai) Less More - Posts: 25 - Thank you received: 0 - - - - [](http://www.aconplus.co.th) - 9 years 5 months ago [\#269059](#269059) by [Tassanai](/forum/user/33163-tassanai "View Tassanai's Profile") Replied by *[Tassanai](/forum/user/33163-tassanai "View Tassanai's Profile")* on topic *[How to fix this problem? Error Illegal mix of collisions](/forum/4-how-to/890133-how-to-fix-this-problem-error-illegal-mix-of-collisions#269059 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : Joomla! 3.7.0 -- PHP version -- : 3.5.8.2 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error Illegal mix of collisions (utf8_general_ci, IMPLICIT) and (utf8_unicode_ci, IMPLICIT) for operation '=' I checked the database in hikashop config. Error Illegal mix of collisions (utf8_general_ci, IMPLICIT) and (utf8_unicode_ci, IMPLICIT) for operation '=' How to fix this problem?")* [ ![IMG_0468_2017-05-09.PNG](/forum/attachment/38025) ](/forum/attachment/38025 "...2017-05-09.PNG") - [ ![IMG_0468_2017-05-09.PNG](/forum/attachment/38025) ](/forum/attachment/38025 "...2017-05-09.PNG") [ ](/forum/attachment/38025?download=1 "...2017-05-09.PNG") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MDEzMy1ob3ctdG8tZml4LXRoaXMtcHJvYmxlbS1lcnJvci1pbGxlZ2FsLW1peC1vZi1jb2xsaXNpb25zP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86357 - Thank you received: 14289 - - 9 years 5 months ago [\#269064](#269064) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to fix this problem? Error Illegal mix of collisions](/forum/4-how-to/890133-how-to-fix-this-problem-error-illegal-mix-of-collisions#269064 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : Joomla! 3.7.0 -- PHP version -- : 3.5.8.2 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Error Illegal mix of collisions (utf8_general_ci, IMPLICIT) and (utf8_unicode_ci, IMPLICIT) for operation '=' I checked the database in hikashop config. Error Illegal mix of collisions (utf8_general_ci, IMPLICIT) and (utf8_unicode_ci, IMPLICIT) for operation '=' How to fix this problem?")* Hi, In any case, note that this is not really a problem. The error only happens on a sycnhronization query which you don't normally have to use as HikaShop already synchornize the users between HikaShop and Joomla thanks to the HikaShop user synchronization plugin. This query is only useful when the users are desynchronized because you made some changes like for example you migrated the tables of a HikaShop to another Joomla website and thus the users of HikaShop and Joomla are not synchronized. Since it's probably not your case, you can simply ignore that message. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MDEzMy1ob3ctdG8tZml4LXRoaXMtcHJvYmxlbS1lcnJvci1pbGxlZ2FsLW1peC1vZi1jb2xsaXNpb25zP3RtcGw9bWFya2Rvd24=) 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.098 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)