I get error anytime I try adding new category on bagisto none showing on velocity

[gideoti]

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: 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))

[Vaishali Agarwal]

@gideoti
Kindly check the solution provided here https://github.com/bagisto/bagisto/issues/2901

[gideoti]

I tried the steps here but nothing changed, am still having same issue

[gideoti]

The categories I have added so far can't show on the front-end (velocity)

[Vaishali Agarwal]

@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