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)

danieldino

hi,

I install new bagisto , only shop , a have same problem

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 between 0 and 0 then _lft + 1
when _lft between 0 and 1 then _lft -1
else _lft
end,
_rgt = case
when _rgt between 0 and 0 then _rgt + 1
when _rgt between 0 and 1 then _rgt -1
else _rgt
end
where
(
_lft between 0 and 1
or _rgt between 0 and 1
)

danieldino

works as I changed to

utf8mb4_general_ci;

danieldino

hi,

I install bagisto shop 1.5 , a have problem

look the screen

I don't see any tab

database set to

'charset' => 'utf8mb4',
'collation' => 'utf8mb4_general_ci',

i change on utf8mb4_unicode_ci

no changes ?

I've run out of ideas

danieldino

Amitk-Webkul

Hi there,
Can you please share the steps which you are following for installing the Bagisto?