Bagisto Forum

    Bagisto

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

    Cannot delete Category

    General Discussion
    2
    3
    199
    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.
    • G
      golith last edited by

      Illuminate \ Database \ QueryException (HY000)
      SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '=' (SQL: update categories set _lft = case when _lft between 15 and 16 then _lft-1 when _lft between 14 and 16 then _lft+2 else _lft end, _rgt = case when _rgt between 15 and 16 then _rgt-1 when _rgt between 14 and 16 then _rgt+2 else _rgt end where (_lft between 14 and 16 or _rgt between 14 and 16))

      any ideas about this error

      "Of all the things I've ever missed ... I miss my mind the most."

      1 Reply Last reply Reply Quote 0
      • devansh-webkul
        devansh-webkul last edited by

        Hi @golith,

        Please use utf8_unicode_ci when creating a database.

        1 Reply Last reply Reply Quote 1
        • G
          golith last edited by golith

          so when i create the database in the first instance i need to declare it .. ty 🙂
          CREATE DATABASE bagisto CHARACTER SET utf8 COLLATE utf8_general_ci;

          "Of all the things I've ever missed ... I miss my mind the most."

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