General error: 1267 Illegal mix of collations

[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?