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: updatecategories
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;