How to fix this problem? Error Illegal mix of collisions

  • Posts: 25
  • Thank you received: 0
  • Hikashop Business
7 years 6 months ago #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?

Attachments:

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

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
7 years 6 months ago #269006

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

The following user(s) said Thank You: Tassanai

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

  • Posts: 25
  • Thank you received: 0
  • Hikashop Business
7 years 6 months ago #269058

I try to do as Hikashop told me already.
But there are also Error Messages, what do I do?

Attachments:

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

  • Posts: 25
  • Thank you received: 0
  • Hikashop Business
7 years 6 months ago #269059

Attachments:

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

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
7 years 6 months ago #269064

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 or Create an account to join the conversation.

Time to create page: 0.068 seconds
Powered by Kunena Forum