DB check error COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'

  • Posts: 189
  • Thank you received: 11
  • Hikashop Business
7 years 7 months ago #266441

-- url of the page with the problem -- : http://localhost
-- HikaShop version -- : 3.0.1
-- Joomla version -- : 3.6.5
-- PHP version -- : 5.6.x
-- Browser(s) name and version -- : FF

When I check the database for errors from HikaShop I get an error: COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4' SQL=SELECT DISTINCT order_status COLLATE utf8_bin FROM `#__hikashop_order` WHERE order_type = 'sale'

All my tables are either utf8mb4_general_ci or utf8_general_ci.

Regards

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
7 years 7 months ago #266455

Hi,

That's normal. We only support utf8, not utf8mb4. Normally, when the HikaShop tables are created, they are all created with utf8_general_ci as you can see in the file administrator/components/com_hikashop/tables.sql
So please don't change the charset of the tables and you won't get that error message.

The following user(s) said Thank You: Rixters

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

Time to create page: 0.061 seconds
Powered by Kunena Forum