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

  • Posts: 196
  • Thank you received: 11
  • Hikashop Business
8 years 1 month 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: 83746
  • Thank you received: 13549
  • MODERATOR
8 years 1 month 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.054 seconds
Powered by Kunena Forum