Recent Topics

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



  • 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.



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


Log in to reply