Recent Topics
General error: 1267 Illegal mix of collations
-
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 '='
updatecategories
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)
-
Hi there,
Please change your database collation with utf8mb4_unicode_ci
-
@sanjay-webkul said in General error: 1267 Illegal mix of collations:
de_ci
I have in the database utf8mb4_unicode_ci
-
Which version of Bagisto are you using?
-
bagisto: 1.4.5
addons: livestream , marketplace vendor
php:8.1
-
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)