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 categories set _lft = case when _lft between 33 and 34 then _lft-19 when _lft between 14 and 34 then _lft+2 else _lft end, _rgt = case when _rgt between 33 and 34 then _rgt-19 when _rgt between 14 and 34 then _rgt+2 else _rgt end where (_lft between 14 and 34 or _rgt between 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.



  • Use utf8_unicode_ci.


Log in to reply