Categories Addition Issues

[imshibaji]

When I want to added a category under the root or different position. That time i faced the problem.

SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '=' (SQL: update bccategories 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)).

Please Resolved this problem in your latest version.

[Vaishali Agarwal]

@imshibaji
This error is coming because of database mis configuration
kindly check the below solution, hope this work
https://github.com/bagisto/bagisto/issues/4347#issuecomment-744276804
https://github.com/bagisto/bagisto/issues/3790
https://forums.bagisto.com/topic/1414/error-while-adding-categories