I get error anytime I try adding new category on bagisto none showing on velocity
-
I get error anytime I try adding a new category on bagisto, and even though it's added, it does not appear on the velocity front-end
Illuminate \ Database \ QueryException (HY000)
SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '=' (SQL: updatecategories
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)) -
@gideoti
Kindly check the solution provided here https://github.com/bagisto/bagisto/issues/2901 -
I tried the steps here but nothing changed, am still having same issue
-
The categories I have added so far can't show on the front-end (velocity)
-
@gideoti
you need to add the category under the root category https://prnt.sc/tu8bm4, then it will be visible under shop by category in velocity