Bagisto Forum

    Bagisto

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups

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

    Knowledge Base
    2
    2
    952
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A
      AshJi last edited by

      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.

      1 Reply Last reply Reply Quote 0
      • V
        Vaishali Agarwal last edited by

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

        1 Reply Last reply Reply Quote 0
        • First post
          Last post