Facing "Illegal mix of collations" with MySQL schema for Bagisto 1.1

AshJi

Hi,
I have recently downloaded Bagisto 1.1 and did a fresh install via composer. Installation went fine and was able to start the server. But when I tried to add a new Category from Admin login, I am constantly getting following error

SQL Error [1267] [HY000]: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='

This while executing following SQL

UPDATE
	`categories`
set
	`_lft` =
	case
		when `_lft` >= 14 then `_lft` + 2
		else `_lft`
	end,
	`_rgt` =
	case
		when `_rgt` >= 14 then `_rgt` + 2
		else `_rgt`
	end
where
	(`_lft` >= 14
	or `_rgt` >= 14)

Tried from MySQL command prompt and still same error.

I also had installation of Bagisto v0.1.6 and related DB in same MySQL instance. Was able to ran the above update SQL successfully. Thus it seems that the schema in v1.1 is created differently and has some specific req which are not mentioned in the Installation Guide.

Please help if anyone knows the solution to fix.

Vaishali Agarwal

Hi @AshJi
click here, same issue is resolved here https://github.com/bagisto/bagisto/issues/2901

Recent Topics

Facing "Illegal mix of collations" with MySQL schema for Bagisto 1.1