how to fix 'Illegal mix of collations' error

  • Posts: 24
  • Thank you received: 1
7 years 3 months ago #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?

Attachments:
Last edit: 7 years 3 months ago by jkfang.

Please Log in or Create an account to join the conversation.

  • Posts: 24
  • Thank you received: 1
7 years 3 months ago #275363

The problem has been solved.

Please Log in or Create an account to join the conversation.

  • Posts: 26159
  • Thank you received: 4028
  • MODERATOR
7 years 3 months ago #275367

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.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Time to create page: 0.060 seconds
Powered by Kunena Forum