Facing "Illegal mix of collations" with MySQL schema for Bagisto 1.1
AshJi last edited by
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  [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 last edited by