General error: 1267 Illegal mix of collations

[danieldino]

I want to add categories and I have this error?

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

[sanjay-webkul]

Hi there,
Please change your database collation with utf8mb4_unicode_ci

[danieldino]

@sanjay-webkul said in General error: 1267 Illegal mix of collations:

de_ci

I have in the database utf8mb4_unicode_ci

[sanjay-webkul]

Which version of Bagisto are you using?

[danieldino]

bagisto: 1.4.5
addons: livestream , marketplace vendor
php:8.1

[danieldino]

ok, problem

problem solved

i have next one it is in marketplace

when i go to the dealer

Attempt to read property "id" on null (View: /var/www/html/bagisto/packages/Webkul/Marketplace/src/Resources/views/shop/velocity/sellers/account/catalog/products/accordians/categories.blade.php) (View: /var/www/html/bagisto/packages/Webkul/Marketplace/src/Resources/views/shop/velocity/sellers/account/catalog/products/accordians/categories.blade.php)