Mixed Collation Error on get_url on product categories
Receiving this error while attempting to add a category as a sub-category of an already existing parent:
SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '=' (SQL: update
_lft= case when
_lftbetween 33 and 34 then
_lftbetween 14 and 34 then
_rgt= case when
_rgtbetween 33 and 34 then
_rgtbetween 14 and 34 then
_rgtend where (
_lftbetween 14 and 34 or
_rgtbetween 14 and 34))
Seems to be related to the trigger or get_url_path_of_category function on the categories table. All collations throughout the database are set to utf8mb4_unicode_ci, so this cannot be changed.
My local version is v1.4.2
Our staging application that's available to the client for testing is using v1.3.3 as it uses the Vendor Marketplace plugin and was more stable.
This error is happening on both, so I don't think it's a version issue.
devansh-webkul last edited by