Cannot delete Category



  • 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



  • Hi @golith,

    Please use utf8_unicode_ci when creating a database.



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


Log in to reply