WP 5.7 + Woocommerce 5.1 collation error

  • I updated my store to WordPress 5.7 and Woocommerce 5.1 yesterday and just now learned customers couldn’t submit orders on my website. I tried myself and got the error message:

    SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='

    It took a while to figure out what this meant and more importantly how to solve it. I’m writing this here in case someone else is frenetically looking for a solution to the same problem. The simple solution is the plugin Database Collation Fix:

    https://www.ads-software.com/plugins/database-collation-fix/

    As you can see in the plugin reviews I’m not the only one who got this issue after this last update, so there’s a pattern here.

    I installed the plugin, and now my store is back to normal. The plugin changes all table collations in the database to use the same collation.

Viewing 13 replies - 1 through 13 (of 13 total)
Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘WP 5.7 + Woocommerce 5.1 collation error’ is closed to new replies.